C Reconciliation Archival

The Reconciliation Archival utility archives data from active reconciliation tables to archival reconciliation tables and to delete data from the active and archival reconciliation tables.

This utility is added to increase performance. Run this utility only if you want to archive the reconciliation data. Data is transferred from the active reconciliation tables to the new archival tables. As a result, extracting active reconciliation data takes less time, and the performance improves.

This appendix discusses the following topics:

Location and Components
Oracle Identity Manager Reconciliation Archival Functionality

C.1 Location and Components

All Oracle Identity Manager database reconciliation archival files are located in the PATCH/db/oracle/Utilities/ReconArchival directory when you are using Oracle Database. Table C-1 provides details of the files that are part of the Oracle Identity Manager Reconciliation Archival utility:

Table C-1 Reconciliation Archival Files

File	Description
cr_recon_ddl_table.sql	Creates the OIM_RECON_DDL table. This table is used by the Reconciliation Archival utility, which calls the OIM_SP_ReconArchival stored procedure to store the DDL statements that are generated when the tool archives or deletes the reconciliation data.
Create_recon_arch_tables.sql	Creates arch_rc* tables with the same structure as the active reconciliation tables. In addition, a primary key is added by the script to the tables.
OIM_SP_ReconArchival.sql	Archives reconciliation data into the reconciliation archival tables and deletes the archived data from active reconciliation tables. It also allows you to clean up the data in archival and active reconciliation tables.

C.2 Oracle Identity Manager Reconciliation Archival Functionality

To use the Reconciliation Archival utility, run the following script:

For Microsoft Windows, run OIM_ReconArch.bat.

For UNIX, run OIM_ReconArch.sh.

After you run the script, a log file is generated with the following name:

For Microsoft Windows:

If the utility runs without error:
```
Arch_Recon_YYYY_MM_DD_HH_MM.log
```
If running the utility generates an error:
```
Err_Arch_Recon_YYYY_MM_DD_HH_MM.log
```

For UNIX:

If the utility runs without error:
```
Arch_Recon_YYYY_MM_DD_HH_MM.log
```
If the running the utility generates an error:
```
Err_Arch_Recon_YYYY_MM_DD_HH_MM.log
```

C.2.1 Authentication

When you run the Reconciliation Archival utility, you are prompted to enter the following information:

Name of the Oracle home directory
Database name
Database user name
Database password

The utility permits only three connection attempts.

C.2.2 Functionality

The following options are present in the Reconciliation Archival utility main menu:

Archive data from active reconciliation tables: Provides options to archive selective data or all the data
Delete all data from archival reconciliation tables: Provides options to delete all the data from the reconciliation archival tables
Delete all data from active reconciliation tables: Provides the options to delete all the data from the active reconciliation tables
Exit: Exits the Archival Utility