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.