Oracle® Identity Manager Upgrade Guide Release 9.1.0 (9.0.1.5 Upgrade) Part Number E12912-01 |
|
|
View PDF |
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:
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. |
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_mi.log
If running the utility generates an error:
Err_Arch_Recon_YYYY_MM_DD_hh_mi.log
For UNIX:
If the utility runs without error:
Arch_Recon_YYYY_MM_DD_hh_mi.log
If the running the utility generates an error:
Err_Arch_Recon_YYYY_MM_DD_hh_mi.log
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.
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