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

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:

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 Backup binary logs show an error message:

Restoring data with the plug-in and Flashback Database

1
2
On the Create Restore Job — Choose Saveset page, select Plug‑in for Oracle from the Plugin Type list.
5
On the Create Selection Set page, select the Flashback Database node.
6
Click Edit Plugin Options, and then click the Restore Options tab.
7
Select Whole Database Restore, Mount Database Before Restore, and Shutdown Abort Database First.
8
On the Post Recovery tab, select Open Database after Recovery and Read Write and Reset Logs.
9
On the Flashback Database tab, select the applicable Flashback Point Type.
For example, select To Time, and input the time to which the database should be flashed back.
10
Click OK to save the settings, and then click Next.
11
In Job Name, specify a name for the job if you do not want to use the default setting.
12
In the Target Client list, select the machine on which you want to restore the data.
13
Use the Schedule, Source Options, and Advanced Options lists to configure any additional required options.
14
Click Save or Save & Submit, whichever is applicable.

Restoring data

Related Documents