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.
|Tags||Oracle Archive Log verification|
|Operating Systems||Unix Linux|
Release Notes: This release detects a corner case for aborted logs which generates ORA-00332, and uses memory mapped files, for faster log scans.
Release Notes: This release fixes a bug with parsing directory names when using the '-q' option. Commands can now utilize environment variables to identify archive log files: ORACLE_SID (set to desired instance DBNAME) and ALV_LNAME (set if your site uses a custom log name prefix).