Chat now with support
Chat with Support

NetVault Plug-in for Oracle 11.3 - User Guide

Introducing Quest® NetVault® Backup 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 Troubleshooting

Using the Oracle® Flashback Database

Using the Oracle® Flashback Database
•
Flashback Database: an overview
•
Viewing Flashback Database status
•
Flashback Database options
•
Flashback Database restrictions
•
Restoring data with the plug-in and Flashback Database

Flashback Database: an overview

Introduced in Oracle® 10g, Flashback Database lets you rewind an Oracle database to a previous time to correct problems caused by logical data corruptions or user errors as long as the datafiles are intact. Flashback Database is not true media recovery because it does not involve restoring physical datafiles. Flashback Database is preferable to using the RESTORE and RECOVER commands in some cases because it is faster and easier and does not require restoring the whole database.

For more information on Flashback Database, see Configuring Oracle Flashback Database and Restore Points in the Oracle Database Backup and Recovery User’s Guide.

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 Create New next to the Selections list.
2
In the selection tree, open the applicable client node.
3
Double-click Plug‑in for Oracle, and select the applicable database.
4
From the Actions list, select View Details.
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.
5
To close the dialog box, click OK.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating