Previewing Oracle Archives

Before you run an archive job, you can preview the archive script that outputs the criteria that the software uses to select the archived data, the number of rows and size to be archived, or the actual data content to be archived.

Note: The parent/child relationship determines the step order for each table.

The script details include:

1. A step for each archived table with the following information:

   • The archived table name.

   • Each parent table name (if applicable) and the step that it was archived.

   • The criteria that is used to perform the archive.

2. A step for each deleted table with the following information:

   • The table name.

   • Each parent table name (if applicable) and what step it was archived.

   • The criteria that is used to perform the deletion.

Once you verify the archive data script, run the archive job or change the archive criteria or archive tables in the subclient content according to the business requirements.

When you preview the archive script , you can see the steps in order with the corresponding archive criteria.

When you preview the data size, you can the number of rows that the software will archive and size of the archived data. The archive data size will be approximate and you must run statistics on the database to get the actual value. Use this option to determine how much approximate space is required on the staging location.

When you preview the data you can see the actual data that the software will archive.

You must provide the production (source) database user credentials to see the data.

Note: The displayed data is only for the target table and does not include any dependent tables.

Procedure

Previewing the Archive Script

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

2. Right-click the archive_subclient and then click Archive.

3. On the Archive Options for Subclient dialog box, select Script.

4. Click Preview.

5. The Script for DBArchive Job dialog box shows the archiving script and the script that deletes the rows from the production database.

6. Click OK to close the Script for DBArchive Job dialog box.

Previewing the Data Size

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

2. Right-click the archive_subclient and then click Archive.

3. On the Archive Options for Subclient dialog box, select Script and then select the Prediction check box.

4. Click Preview.

5. The Script for DBArchive Job dialog box shows the archiving script as well as the script for deleting the rows from the production database. Each step displays the size in KB.

6. Click OK to close the Script for DBArchive Job dialog box.

Previewing the Archived Data

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

2. Right-click the archive_subclient and then click Archive.

3. On the Archive Options for Subclient dialog box, select Data.

4. Click Preview.

5. On the Oracle Database Credentials dialog box, enter the credentials of the schema that owns the table.

   The user and password entered must have database read and write permissions.

6. The Data Preview for ... dialog box displays the data that the software archive.

   The software retrieves and displays the first 100 rows on a page. Use the Next or Page Number button to view additional data.

   For complete information on what data the software displays, see Data Preview.

7. Click OK to close the Data Preview for ... dialog box.