After you have restored one or more databases from long-term storage to the archive directory, you must change ownership of the archive directory to the caelmservice user before notifying CA Enterprise Log Manager that the databases have been restored with the LMArchive utility. Archived files owned by root are not recognized by the LMArchive utility.
Running LMArchive with the -notify rest option changes the state of the archived database files from cold to defrosted so that they are available for querying and reporting.
Administrators configure the number of hours a defrosted archived database is retained before being automatically deleted from the archived directory with the Export Policy setting on the Event Log Store service configuration.
To restore manually archived database files
su - root
cd /opt/CA/LogManager/data
chown -R caelmservice:caelmservice archive
Ownership of the archive files is changed to caelmservice, the internal operating system user, which is a non-login account.
cd $IGW_LOC
LMArchive -euser username -epassword pwd -notify rest -files file1,file2,file3
A restoration confirmation appears. CA Enterprise Log Manager defrosts the specified files. Defrosted files are retained for the configured number of hours, where you can configure retention for up to seven days.
Note: You can now run queries and reports against the event data contained in the restored archive files.
Example: Notify CA Enterprise Log Manager that Certain Databases Have Been Restored
The following command issued by a CA Enterprise Log Manager user with an Administrator role notifies the CA Enterprise Log Manager event log store that the specified cold database, calm04_20091206192014.db, has been copied into the archive directory.
LMArchive -euser Administrator1 -epassword calmr12 -notify rest ‑files calm04_20091206192014.db.cerod
A restoration confirmation appears in a format similar to the following:
Restore notification sent for file calm04_20091206192014.db.cerod
Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |