Veritas InfoScale™ 8.0.2 Storage and Availability Management for Oracle Databases - AIX, Linux, Solaris

Manual recovery after a restore operation

Storage Checkpoints and FileSnap services of Storage Foundation for Databases (SFDB) tools provide a restore operation that restores application files from a point-in-time copy. In the case of Oracle, a restore operation restores the database files from the point-in-time copy.

The restore operation restores only the data files onto the primary database data files, thus overwriting them. It lets you then perform a database point-in-time recovery manually to recover the database to the desired recovery target or time. The restore operation also places a copy of the control file from the snapshot in the /var/tmp directory to you to perform point-in-time recovery to the snapshot time.

After performing a restore operation, use the following SQL statements to recover the database to any point-in-time, starting from the time the snapshot was taken:

{ To perform complete recovery:}
1) SET AUTORECOVERY ON;

2) RECOVER DATABASE;

{ To perform incomplete recovery:}

1) SET AUTORECOVERY ON;

2) RECOVER DATABASE UNTIL CANCEL;

OR

RECOVER DATABASE UNTIL TIME <time>;
 
OR

RECOVER DATABASE UNTIL CHANGE <SCN>;

{ Note: The 'USING BACKUP CONTROLFILE' clause must be used 
if recovery is performed using a backup control file, or if using 
the control file from the snapshot.}

3) ALTER DATABASE OPEN RESETLOGS;