Tchater maintenant avec le support
Tchattez avec un ingénieur du support

NetVault Plug-in for Oracle 13.0 - User Guide

Introducing Quest® NetVault® Plug-in  for Oracle Defining a backup strategy Installing and removing the plug-in Configuring the plug-in Backing up data Using the Oracle Flashback Database Restoring data
Restoring and recovering data: an overview Performing User Managed restores Using advanced User Managed restore procedures Performing RMAN restores Using RMAN types of recovery in a non-RAC environment Using advanced procedures with RMAN restores
Maintaining the Recovery Catalog Using the RMAN CLI Using the plug-in with Oracle RAC Using the plug-in in a failover cluster environment Using the plug-in with Oracle Data Guard Using the plug-in with Oracle Container Databases (CDBs) and Pluggable Databases (PDBs) Troubleshooting

Flashback Logs

Flashback Database has its own logging mechanism. Flashback Logs are generated and stored in the FRA. After Flashback Database is enabled, altered datafile data blocks are copied into the Flashback Logs. These data blocks can be used later to reconstruct the datafile contents. Because Flashback Logs are captured at regular time intervals, the data blocks restored from the Flashback Logs are those blocks stored most immediately before the desired target time. After Flashback Logs are applied, the Redo Log is reapplied to Complete Recovery to the target time.

Viewing Flashback Database status

To view database details about a previously configured database ,  including whether FRA and Flashback Database are enabled , perform the following steps.

1
In the Navigation Pane, click Create Backup Job, and click next to the Selections list.
2
In the selection tree, open the applicable client node.
3
Double-click Plug‑in for Oracle, click the applicable database, and select View Details from the context menu.
The Details dialog box includes the following details:
•
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.
Additionally, backups done with plug-in show a Flashback Database node for the plug-in on the Create Selection Set page when you create a restore job. The Flashback Database node lets you perform a Flashback Database instead of a restore or recovery.
4
To close the dialog box, click OK.

Flashback Database options

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.
Restore points can be created using the CREATE RESTORE POINT command. For more information, see Creating Normal and Guaranteed Restore Points in the Oracle Database Backup and Recovery User’s Guide.
•
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.

Flashback Database restrictions

There are two restrictions on selecting Flashback Database:

•
Whole Database and Flashback Database nodes cannot be selected at the same time. If selected, the restore job fails and the NetVault binary logs show an error message:
Cannot select 'Whole Database' and 'Flashback Database' at the same time.
•
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:
Restore Selections Error. Cannot select 'Flashback Database' and Individual Datafiles at the same time.
Documents connexes

The document was helpful.

Sélectionner une évaluation

I easily found the information I needed.

Sélectionner une évaluation