Previous Topic: Event Log Database StatesNext Topic: Data Integrity Checks


Automating Backup and Restore

A backup process ensures that no data is lost due to the deletion of aged databases. The preferred method of backing up archived databases is to use auto archive. Auto archive is a scheduled, automated transfer of archived databases between pairs of servers. Auto archiving between a source server and a destination server requires non-interactive authentication. Non-interactive authentication uses RSA public-key authentication without a passphrase. You can configure non-interactive authentication and auto archiving:

Note: For details, see the Implementation Guide.

A restore process moves archived databases from remote storage to a CA User Activity Reporting Module server for investigation. The preferred method of restoring archived databases is to use the restore-ca-elm.sh script. This restore utility automates the transfer of archived databases. Like the auto archive process, the restore-ca-elm.sh script uses non-interactive authentication. You can configure non-interactive authentication and run the restore script:

You configure auto archiving to take place on a regular schedule. You invoke restore on an as needed basis.

More information:

Database Move and Backup Strategy Flowchart

Configuring Non-Interactive Authentication for Auto Archive

Example: Auto-Archiving Across Three Servers

Configuring Non-Interactive Authentication for Restore

Restore Auto-Archived Files