Administration Guide › Log Storage › Manually Restoring Archives to the Original Event Log Store › Prepare to Restore Archived Databases

Prepare to Restore Archived Databases

Before you restore archived databases, you need to know the following:

• The names of the files to restore
• The archive directory path into which you copy the files you retrieve from off-site storage. The path is always /opt/CA/LogManager/data/archive

You can query the archive catalog through the CA User Activity Reporting Module Administration tab, Log Collection Explorer, where you can specify simple or advanced filters. Or you can use the command line utility as described here.

If you already have the needed information at hand, skip this procedure.

To prepare to restore archived databases

1. Use your caelmadmin credentials to log on to the CA Enterprise Log Manager server with the event log store where you want to restore the databases.
2. At the command prompt, switch users to root, that is:

   su - root
   

3. Change directories to /opt/CA/SharedComponents/iTechnology with the following shortcut:

   cd $IGW_LOC
   

4. Identify the databases that you want to restore from a list of files that includes those that have been backed up and moved to external storage. To view the list of all archived files in this archive catalog, execute the following command, where userid and pwd are the credentials of a CA User Activity Reporting Module user account with the Administrator role.

   LMArchive -euser userid -epassword pwd -list all
   

   The list of all archived files appears.

5. (Optional) If restoring from manual backups, determine the location of the archive directory to which the identified cold archive files are to be copied. Execute the following command, where userid and pwd are the credentials of a CA User Activity Reporting Module user account with the Administrator role.

   LMArchive -euser userid -epassword pwd -list loc
   

   The archive directory appears.

Example: Display All Current CA User Activity Reporting Module Archive Files

The following command issued by the CA User Activity Reporting Module Administrator, Administrator1, requests a list of all databases located in the event log store's archive directory.

LMArchive ‑euser Administrator1 ‑epassword calmr12 ‑list all

A list of the current archive files appears, in a format similar to the following:

CAELM Archived Files:

calm04_20091206191941.db.cerod
calm04_20091206191958.db.cerod
calm04_20091206192014.db.cerod
calm04_20091206191941.db.sig
calm04_20091206191958.db.sig
calm04_20091206192014.db.sig

Example: Display the CA User Activity Reporting Module Archive Directory

The following command issued by a CA User Activity Reporting Module Administrator, Administrator1, requests the directory location of the archived databases:

LMArchive -euser Administrator1 -epassword calmr12 -list loc

The following is a typical response:

CAELM Archive Location (localhost) : 
../../LogManager/data/archive

More information:

Query the Archive Catalog