1 |
3 |
Double-click Plug‑in for Oracle, click the applicable database, and select View Details from the context menu. |
• |
Flash Recovery Area Destination: When FRA is enabled, this option displays the destination of the FRA. |
• |
Flashback Database Enabled: Indicates YES if the Flashback Database feature is enabled or NO if not. |
Selecting Flashback Database in the plug-in is equivalent to the RMAN or SQL FLASHBACK DATABASE command.
Flashback Database has the following options:
• |
To Restore Point: Flashes the database to a specific restore point. A restore point is a named point that can be used as a flashback target. When you create a restore point, you are naming the current System Change Number (SCN). You can create up to 2048 named restore points and these points can either be normal or guaranteed. A guaranteed restore point is used in a Flashback Database. |
• |
To Time: Reverts the database back to its state at the time specified. |
• |
To SCN: Reverts the database back to its state at the specified SCN. |
• |
Before Time: Reverts the database back to its state one second before the specified timestamp. |
• |
Before SCN: Reverts the database back to its state at the system change number just preceding the specified SCN. |
• |
Before Reset Logs (available for Oracle 10.2.x and later versions only): Rewinds the database back to the SCN just before the RESETLOGS happened. |
There are two restrictions on selecting Flashback Database:
• |
On the Create Selection Set page, Flashback Database cannot be selected at the same time as other nodes such as Parameter File, Control Files, Tablespaces, and Datafiles. If selected, the restore job fails and the NetVault binary logs show an error message: |
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center