Veritas NetBackup™ for Oracle Administrator's Guide
- Introduction
- NetBackup for Oracle QuickStart
- Installing NetBackup for Oracle
- About linking Oracle RMAN with NetBackup for UNIX
- Oracle policy configuration
- Preparing for NetBackup for Oracle configuration
- Instance management for an Oracle Intelligent Policy
- About Oracle Intelligent Policies (OIP)
- About script- or template-based Oracle policies
- About adding backup selections to an Oracle policy
- About configuring the run-time environment
- About creating templates and shell scripts
- About creating RMAN scripts manually
- Performing backups and restores of Oracle
- About NetBackup for Oracle backups
- About NetBackup for Oracle restores
- Using NetBackup for Oracle in a Microsoft Windows cluster environment
- Guided Recovery
- Troubleshooting Guided Recovery
- NetBackup for Oracle with Snapshot Client
- About NetBackup for Oracle with Snapshot Client
- How NetBackup for Oracle with Snapshot Client works
- About configuring Snapshot Client with NetBackup for Oracle
- Restoring NetBackup for Oracle from a snapshot backup
- About configuring NetBackup for Oracle block-level incremental backups on UNIX
- About Snapshot Client effects
- About Oracle support for Replication Director
- Troubleshooting
- Troubleshooting RMAN backup or restore errors
- Appendix A. Real Application Clusters
- Appendix B. Best practices for protecting Oracle RAC with NetBackup
- Appendix C. Deduplication best practices
- Appendix D. Snapshot Client support of SFRAC
- Appendix E. Script-based block-level incremental (BLI) backups without RMAN on UNIX and Linux systems
- Verifying installation requirements for BLI backups without RMAN
- Creating NetBackup policies for script-based BLI backup
- Creating notify scripts for BLI backups
- Performing backups and restores
- About troubleshooting backup or restore errors
- Appendix F. XML Archiver
- NetBackup for Oracle XML export and XML import
- About XML export templates and shell scripts
- Performing an XML export archive
- Restoring an XML export archive
- Troubleshooting XML export or XML import errors
- Appendix G. Register authorized locations
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
Note:
The NetBackup appliance media server can only be configured in a pure IPv4 or dual stack IPv4/IPv6 mode.
More Information
Single-step restore to ASM storage from a Copilot recovery point