Be Careful When Restoring
Looking through this list of potential uses, there are a number of situations where you
could use snapshots in non??“disaster recovery situations. Take care in mixing snapshot
functionality within the same database if you ever anticipate ???snapping back.??? Remember
that list of requirements for restoring a snapshot? You must remove all existing
snapshots. If you have to revert back, and other snapshots exist for something like pointin-
time reporting, those latter snapshots will be completely gone. Restoring to a snapshot
will result in data loss not only to the database itself, but also to all other snapshots created
on the same source database.
Database Snapshots and Disaster Scenarios
So how do database snapshots fit in with the disaster categories? You??™ve already seen
that they fit well with process and user errors. Here??™s how they work with five disaster
categories:
CHAPTER 9 n DATABASE SNAPSHOTS 240
??? Environmental: Since database snapshots require an active database in order to
be used, they are of absolutely no help in the event of a tornado, fire, flood, or
power outage.
Pages:
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442