1 project tagged "Archive Log"
Point-in-time recovery of an Oracle DB entails the use of transaction log files. The set of such logs grows over the lifetime of a DB, and their management often requires that they be copied to remote locations and/or backed up to offline storage. Alv can verify a set of archive logs prior to its use in a DB recovery scenario: checks are made on file size and type, and the checksum of each redo record is verified. The output is a sequence of log file numbers and character codes to indicate status and highlight any gaps in the sequence (which would stall a recovery). Environment variables can be set to allow for custom log file name formats and to check the DBNAME associated with each log.