Performing Incremental Oracle Archives

You can perform an incremental archive of the Oracle database.

Before You Begin

1. Plan your advanced settings. The options are described for the following advanced settings:

   • Advanced Backup or Archive Options (Data)

   • Job Priorities and Priority Precedence - Online Help - Startup

   • Job Controller - Online Help - Job Retry

   • Advanced Backup/Archive Options (Media)

   • Advanced Backup Options (Data Path)

   • Vault Tracker Feature - Online Help

   • Alerts and Notifications - Online Help

2. Preview the archive.

3. Place the archive database in NOARCHIVELOG mode.

   If you cannot place the database NOARCHIVELOG mode, see Skipping the Mode Check on the Archive Database.

4. Optional: If you want to create tables for the archived data that have the same same as the source tables, set the sMergeIntoSingleDestTable additional setting. For information, see Allowing the Archived Data and Source Data to Use the Same Table Names.

Procedure

1. From the CommCell Browser, expand Client Computers > client > Oracle >instance.

2. Right-click the archive_subclient and click Archive.

   The Archive Options for Subclient dialog box is displayed.

3. Select the backup type and job initiation:

   1. In the Select Backup Type area, select Incremental.

   2. In the Job Initiation section, specify whether to run the backup now or if it will be scheduled.

      Note: If you selected Schedule, set up the schedule.

      For information on configuring a backup schedule, see Schedule Backups.

4. Optional: To set advanced backup options, click Advanced.

5. Click OK.

You can track the progress of the job from the Job Controller. When the backup has completed, the Job Controller displays Completed.

After your backup job is complete, you can view the backup job history. For more information, see Job History.

Results

For an archive in a parquet format, after the archive completes, there is a directory for each table that has the following format:

/Path for Archive Data Files/numericfolder/Tables/SchemaName.Tablename/YYYY_MM/xxxxxxxxJobID/

The software places one Parquet file for each table in a subdirectory for that table. The folder is called 1.parquet.

For an archive in the XML format, after the archive job completes, there are two files per table placed in this directory. There is an xml file type that is in the <Path for Archive Data Files>/Data directory that has the following format:

<SCHEMANAME>.<TABLENAME>.xml

There is an xsd file type that is in the <Path for Archive Data Files>/Config directory and that has the following format:

<SCHEMANAME>.<TABLENAME>.xsd