Oracle® Identity Manager Upgrade Guide Release 9.1.0 (9.0.3.2 Upgrade) Part Number E13340-01 |
|
|
View PDF |
You run this utility to archive the task data. When you run this utility, data is transferred from the active task tables to the new archival tables. As a result, extracting active task data takes less time and the performance improves.
This appendix discusses the following topics:
All Oracle Identity Manager Task Archival files are located in the PATCH/db/oracle/Utilities/TaskArchival directory when you are using Oracle Database. Table D-1 provides details of the files that are part of the Oracle Identity Manager Task Archival utility:
Table D-1 Task Archival Files
File | Description |
---|---|
cr_taskarchival_ddl_table.sql |
Creates the OIM_TASK_ARCH_DDL table. This table is used by the Task Archival utility, which calls the OIM_SP_TASKS_ARCHIVAL stored procedure to store the DDL statements that are generated when the tool archives or deletes the tasks data. |
Create_TasksArch_Tables.sql |
Creates the arch_* tables that have the same structure as the active tasks tables. In addition, this script afds a primary key to tables. |
OIM_SP_TASKS_ARCHIVAL.sql |
Archives task data into the task archival tables and deletes the archived data from the active task tables. |
To use the Task Archival utility, run the following script:
For Microsoft Windows: OIM_TasksArch.bat
For UNIX: OIM_TasksArch.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_Tasks_YYYY_MM_DD_HH_MM.log
If running the utility generates an error:
Err_Arch_Tasks_YYYY_MM_DD_HH_MM.log
For UNIX:
If the utility runs without error:
Arch_Tasks_YYYY_MM_DD_HH_MM.log
If running the utility generates an error:
Err_Arch_Tasks_YYYY_MM_DD_HH_MM.log
When you run the script, you are prompted to enter the following information:
Name of the Oracle home directory
Database name
User name
Database password
The utility permits only three connection attempts.
The following options are present in the Task Archival utility main menu:
Archive all the provisioning tasks on resource instances, which have been revoked for disabled/deleted users
Archive all the provisioning tasks on resource instances, which have been revoked
Archive all the approval tasks in which the request status is Request Complete/Request Cancelled/Object Approval Complete
Exit