Creating an instant recovery point from an Oracle Copilot image
The nborair command can determine if an image is available for Oracle Copilot instant recovery.
Note:
The functionality for creating an instant recovery point is not in the GUI. This feature is command line option only.
Refer to the NetBackup Commands Reference Guide for more usage options using the nborair command.
To create an instant recovery point
- Determine if there are any images available for instant recovery by running the nborair - list_images [-client name] [-server master] command.
The NetBackup administrator or the DBA can run this command from the NetBackup client or master server.
Example output:
# nborair -list_images -client orachost1.demo.com -server mastsrv123 Time: 08/30/2016 15:51:17 ID: orachost1.demo.com_1472590277 Full Backup policy1 Time: 08/31/2016 11:20:17 ID: orachost1.demo.com_1472660417 Full Backup policy1 Time: 09/02/2016 10:42:45 ID: orachost1.demo.com_1472830965 Full Backup policy1 - List the files that are included in the backup image by running the nborair - list_files - backupid backup_id command.
The NetBackup administrator or the DBA can run this command from the NetBackup client or master server. The DBA sees only the files they can access when this command is run.
Example output:
# nborair -list_files -backupid orachost1.demo.com_1472590277 -rw-r----- orac112 dba 807411712 Sep 02 10:42 /backup/data_D-ORAC112_I-3955369132_TS-SYSAUX... -rw-r----- orac112 dba 744497152 Sep 02 10:42 /backup/data_D-ORAC112_I-3955369132_TS-SYSTEM... -rw-r----- orac112 dba 52436992 Sep 02 10:42 /backup/data_D-ORAC112_I-3955369132_TS-UNDOTBS... -rw-r----- orac112 dba 5251072 Sep 02 10:42 /backup/data_D-ORAC112_I-3955369132_TS-USERS_FN... -rw-r----- orac112 dba 163328 Sep 02 10:42 /backup/arch_D-ORAC112_I-3955369132_SCN-3744354_... -rw-r----- orac112 dba 2560 Sep 02 10:42 /backup/arch_D-ORAC112_I-3955369132_SCN-3744354_5i... -rw-r----- orac112 dba 98304 Sep 02 10:42 /backup/spfile_D-ORAC112_I-3955369132_T-20160902_... -rw-r----- orac112 dba 1425408 Sep 02 10:42 /backup/cf_D-ORAC112_I-3955369132_T-20160902_5k... - Create the instance recovery point by running the nborair -create_recovery_point -backupid backup_id -dest_client name command. The backup_id is the same backup_id found in step 1.
The NetBackup administrator must run this command from the NetBackup master server.
For this example, the destination client is oracdest.
Example output:
# nborair -create_recovery_point -backupid orachost1.demo.com_1472590277 -dest_client oracdest Appliance: appl5330 Export path: /shares/share1_orachost1.demo.com_1472590277_rp1 Export options: oracdest(rw,no_root_squash,insecure)
- Mount the recovery point on the destination client using the OS tools and with the required mount options per Oracle documentation.
Example:
mount - t nfs appl5330:/shares/share1_orachost1.demo.com_1472590277_rp1 /mnt
For Windows, Oracle's DNFS needs to be configured. The recovery point has to be exported with the insecure option.
- (Conditional) On the destination host, verify the mount point is from the backup ID that was requested by running the nborair - validate - backupid backup_id -mount_path mount_path command.
The NetBackup administrator or the DBA can run this command on the destination host.
Example output:
# nborair -validate -backupid orachost1.demo.com_1472590277 -mount_path /mnt Validation successful - Recovery point mounted on /mnt was created from backup ID orachost1.demo.com_1472590277
More Information
Single-step restore to ASM storage from a Copilot recovery point