Flashback Restore Points
Enables canceling of planned database changes using user-defined labels (instead
of SCNs or timestamps). Can also be used with Data Guard and RMAN to
resynchronize a clone database.
Oracle Database 11g adds a Flashback Transaction command for backing out an
individual transaction and its dependent transactions by utilizing undo data to revert
data to its original state.
As we noted earlier in this chapter, Oracle now provides a Flashback Data Archive
capability through the Oracle Database 11g Total Recall Option. This data archive is
established for a defined retention period. Update and delete operations are then
recorded in tables that map to the database tables being tracked. If youhave specified
an ???AS OF??? clause in your SQL specifying a particular moment it time, you will
then have access to the data as it appeared at that moment. The updates and deletes
are rolled back, as appropriate, and show youwhat the data looked like at the specified
point in time.
Complete Site Failure
Protection from the complete failure of your primary Oracle site poses significant
challenges.
Pages:
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615