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
Browsing XML export archives using bplist
For a higher level view of the Oracle XML export archive list, you can use the bplist command. The result is the list of XML schema and instance document file names.
Note:
Only XML export archives created using NetBackup mode are searched. Exports stored in an operating system directory using the DIRECTORY parameter are not searched.
The following UNIX or Linux example uses bplist to search all Oracle archives for a client named jupiter. The sample output is produced for two archives, test1 and little_sales, where each archive has one Oracle table (test1 has USER1.TEST1 and little_sales has USER1.LITTLE_SALES).
/usr/openv/netbackup/bin/bplist -C jupiter -t 4 -R /Oracle/XMLArch/ /Oracle/XMLArchive/test1/test1.xsd /Oracle/XMLArchive/test1/USER1/TEST1.xsd /Oracle/XMLArchive/test1/USER1/TEST1.xml /Oracle/XMLArchive/little_sales/little_sales.xsd /Oracle/XMLArchive/little_sales/USER1/LITTLE_SALES.xsd /Oracle/XMLArchive/little_sales/USER1/LITTLE_SALES.xml /exb_n2bm5bco_1_1392342936 /exb_mabm02ko_1_1392170136 /exb_lqbltds6_1_1392083334
The following Windows example uses bplist to search all Oracle archives for a client named jupiter. The sample output is produced for one archive, test.
install_path\NetBackup\bin\bplist -C jupiter -t 4 -R Oracle:\XMLArch\ Oracle:\XMLArchive\test\test.xsd Oracle:\XMLArchive\test\SCOTT\BONUS.xsd Oracle:\XMLArchive\test\SCOTT\BONUS.xml Oracle:\XMLArchive\test\SCOTT\DEPT.xsd Oracle:\XMLArchive\test\SCOTT\DEPT.xml Oracle:\XMLArchive\test\SCOTT\EMP.xsd Oracle:\XMLArchive\test\SCOTT\EMP.xml Oracle:\XMLArchive\test\SCOTT\SALGRADE.xsd Oracle:\XMLArchive\test\SCOTT\SALGRADE.xml
The -t 4 on this command specifies the Oracle backups or archives. The -R specifies the default number of directory levels to search, 999.
For more information on this command, see the bplist man page in the NetBackup Commands Reference Guide.