Skip to content

Archive Management

System Management > Archive Management

The Archive Management section is used to define automatic archive settings and review the history of previous archives.

An automatic archive process can be scheduled to run at a specified time to collect records that are older than a specified date. Several archive databases can be introduced to the archive procedure but only ones which are not closed can be used for the scheduled archive procedure.

Archived databases can be chosen as the default for transaction and audit log search purposes.

Links are provided to Archive Databases, Edit Archive Settings, Archive Database Details and Archive history details pages.

This page displays:

  • Archive Settings

  • Archive Databases link to the Archive Databases page

  • Edit link to the Archive Settings page

Edit Archive Settings

Use the following fields and links to edit the archive settings:

  • Automatic archive checkbox to enable / disable automatic archiving

  • Start date for archiving in dd/mm/yyyy format

  • Start time for archiving in hh:mm format

  • Archive old records every, and select Days or Months from the drop down list to specify how often records should be archived.

  • Collect records which are older than, and select Days or Months from the drop down list to specify the age of records to archive.

  • Automatic archive purge checkbox to enable / disable automatic archive purging

  • Purge start date for purging archived records in dd/mm/yyyy format

  • Purge start time for purging archived records in hh:mm format

  • Purge old archived records every, and select Days or Months from the drop down list to specify how often records should be archived.

  • Purge archived records which are older than, and select Days or Months from the drop down list to specify the age of records to archive.

  • Apply button to save the settings

Archive Databases

This page displays:

  • Archive Databases list

  • New Archive Database

The following fields and links are displayed for each archive database:

  • Select radio button to indicate which archive database to delete

  • Archive database (Archive user)

  • Creation date - the date that the archive database was created.

  • End date - the date that the archive database was closed. A database is closed once a new archive database is added. Closed archive databases are not used for archiving but can still be used for Transaction/Audit Log Searches.

  • Archive user status - indicates which archive database is the default for Transaction and Audit Log searches

  • Set as default for Search link for selecting a different archive database to use for Transaction and Audit Log searches

New Archive Database

Use the following fields to add a new Archive Database:

  • Select either Database Link or Database user

  • If the Database link radio button is selected, enter the Database Link.

    This must be a valid database link to an ActiveAccess archive database with the schema that has already been defined in Archive/archive_schema.sql under the ActiveAccess package.

  • If the Database user radio button is selected, enter a valid ActiveAccess archive database, with a schema that has already been defined in Archive/archive_schema.sql under the ActiveAccess package.

Note

The current ActiveAccess database user should have the appropriate access rights to the archive database user objects.

  • Apply button to save the new Archive Database.

Note

Creating a new archive database closes the current archive database and all subsequently archived records are recorded in the new archive database.
A closed archive database can still be accessed by selecting it as the default for Transaction/Audit Log searches.

Archive Database details

This page displays:

  • Links to the Archive history details pages

The following fields and links are displayed in Archive Database Details page

  • Archive Database is displayed and cannot be changed

  • Creation date is displayed and cannot be changed

  • End date - the date that the archive database was closed. A database is closed once a new archive database is added. Closed archive databases are not used for archiving but can still be used for Transaction/Audit Log Searches.

  • Archive History tab - lists previous archive activities with a link to the Archive history details of each archive run.

  • Purge History tab - lists previously purged archive activities with a link to the Purge history details of each purge archive run.

Archive History Details

The following fields and links are displayed:

  • Archive history details for a specified archive date and time and record age

  • Table - name of the database table archived

  • Number of Records Archived

Purge History Details

The following fields and links are displayed

  • Purge history details for a specified purge date and time and record age

  • Table - name of the database table purged

  • Number of Records Purged