Prerequisites for Running the Offline Data Purge Framework

The following prerequisites must be met before running the offline data purge operation:

  • Before running the offline data purge operation, create a backup of the data to be purged.

  • Ensure that you do not have a business use for the data identified for purging in the mainstream Oracle Identity Governance operations.

  • It is recommended to have sufficient space in OIM, UNDO, and TEMP tablespaces. To calculate extra space required in these tablespaces:

    • Calculate the cumulative size of the tables from which data is required to be purged. The tables are:

      • For orchestration: ORCHPROCESS

      • For provisioning task: OSI, OSH, SCH, OTI

      • For reconciliation: RA_XELLERATE_ORG, RA_LDAPROLEHIERARCHY, RA_LDAPROLEMEMBERSHIP, RA_MLS_LDAPROLE, RA_LDAPROLE, RA_MLS_LDAPUSER, RA_LDAPUSER, RECON_ROLE_MEMBER_MATCH, RECON_ROLE_HIERARCHY_MATCH, RECON_ROLE_MATCH, RECON_ORG_MATCH, RECON_CHILD_MATCH, RECON_ACCOUNT_MATCH, RECON_USER_MATCH, RECON_HISTORY, RECON_EVENT_ASSIGNMENT, RECON_BATCHES, RECON_JOBS, RECON_EVENTS, and other RA_* tables

    • Based on the result of the previous step, double the size can be allocated to OIM tablespace. The UNDO and TEMP tablespaces require lesser space than the OIM tablespace.

  • Make sure to collect latest statistics for OIM database schema.

  • Ensure that Oracle Identity Governance server is down during the purge operation.

  • It is recommended to perform the offline data purge operation in a lower environment with representative data and similar configurable Oracle DBMS scheduled job parameters, to get an idea about how much downtime would be required in production environment beforehand.

  • Enable diagnostic logging during the offline data purge operation, by setting the diagnostic level as the value of the OIM.DBDiagnosticLevelOffPurge system property. See Default System Properties in Oracle Identity Governance for information about this system property.

    After the diagnostic data is collected, reset the value of the system properties from FINISH to the default value of NONE. See Editing System Properties for information about modifying the values of system properties.