You can restore your database from a Database Storage Checkpoint as follows.
To restore the database from a Database Storage Checkpoint
$ /opt/VRTSdbed/bin/vxsfadm -s checkpoint -o restore -a oracle \ --oracle_sid=sfaedb --oracle_home=/ora_base/db_home \ --checkpoint_name=XYZ The SCN at the time of taking the checkpoint was : 1170070 Rolling back the application files... Done You may want to use the following file(s) for application recovery /var/tmp/hCgJmBm4AT/control01.ctl /var/tmp/hCgJmBm4AT/binary_controlfile
This command restores all the data files of the application to the point-in-time when the Storage Checkpoint was created.
Note: |
Rollback of Database Storage Checkpoints that are mounted in the read-write mode is not supported. |
After the restore operation, you can bring up the database by using standard recovery techniques. The control file provided is the one present at the time the Storage Checkpoint was created. This control file can be used if there have been some structural changes to the database after the Storage Checkpoint was created.
Note: |
The following operation requires the tablespace and all data files in the tablespace to be offline. |
To restore the data files in a tablespace from a Database Storage Checkpoint
$ /opt/VRTSdbed/bin/vxsfadm -s checkpoint -o restore -a oracle \ --oracle_sid=sfaedb --oracle_home=/ora_base/db_home \ --checkpoint_name=XYZ --tablespace_rollback newtbs Rolling back the application files... Done
This command restores all the data files in the specified tablespace to the point-in-time when the Database Storage Checkpoint was created.
After the restore operation, you must recover the tablespace by using standard recovery techniques.
To restore specified data files from a Database Storage Checkpoint
$ /opt/VRTSdbed/bin/vxsfadm -s checkpoint -o restore -a oracle \ --oracle_sid=sfaedb --oracle_home=/ora_base/db_home \ --checkpoint_name=XYZ \ --datafile_rollback /data/sfaedb/newf01.dbf,/data/sfaedb/newf02.dbf Rolling back the application files... Done
This command restores all the specified data files to the point-in-time when the Database Storage Checkpoint was created.
You can specify the data files to restore by using one of the following options:
datafile_rollback: A list of data files separated by comma.
datafile_list_rollback: A file that contains a list of data files separated by newlines.
After the restore operation, you must recover the data files by using the standard recovery procedures.