Sequence of operation: XML export archive
Figure: XML export archive data flow shows data flow.
NetBackup for Oracle users or automatic schedules start database XML export archives by performing a manual backup of an Oracle policy, by invoking the script or template at the command line on the client, or by invoking a template through the Backup, Archive, and Restore interface.
The NetBackup for Oracle script or template calls the bporaexp utility with a specified parameter file.
The query processor uses the parameters in the specified file to build an SQL query for each table.
Oracle's OCI API executes the queries on the Oracle database instance to be archived.
The query processor passes the output (including metadata and data for a single table or multiple tables) to the XML Generator.
For each table passed, the XML generator builds one or more sets of XML schema and XML instance documents.
XML data streams are backed up by NetBackup.
Alternately, bporaexp allows the files to be saved to an operating system directory.