NetBackup™ for Oracle Administrator's Guide

To perform a rollback restore in the SFRAC environment

1. Ensure that you previously created a virtual IP for the clustered node. Point that virtual IP to the primary node of the cluster.
2. On all the clustered nodes, take the VCS database service group (Oracle, CFSMount, and CVMVolDg resources) offline by using the following command:

   # hagrp -offline <DB_Service_Group> -any

3. Freeze the database service group.

   # hagrp -freeze <DB_Service_Group>

4. Mount the CFSMount points manually outside VCS on the primary node. This action helps when you start the database in mount state.

   # mount -F vxfs -o cluster <mntPt>

5. Start the database with mount option on the clustered primary node using one of these options:

   Option 1:

   # sqlplus /as sysdba
   # startup mount;
   

   Option 2:

   # sqlplus /as sysbackup
   # startup mount;

6. Run the rollback restore operation from the RMAN script or the client GUI. A sample RMAN script file (hot_database_backup_proc) is located in the following directory path:

   /usr/openv/netbackup/ext/db_ext/oracle/samples/rman

   To perform PIT rollback, add the following parameter to the script:

   NB_ORA_PC_RESTORE=rollback

7. Unmount the CFS on the primary node.

   # umount <mntPt>

8. Unfreeze the VCS database service group.

   # hagrp -unfreeze <DB_Service_Group>

9. On all the clustered nodes, take the VCS database service group (Oracle, CFSMount, and CVMVolDg resources) back online:

   # hagrp -online <DB_Service_Group> -any