Alv verifies Oracle archive logs to ensure there is a viable set available for DB recovery. It can be run from wherever the logs are stored, so verification may be offloaded from the DB server. Checks are made on file size and type. By default, the checksum of each redo record is also verified. Program output consists of log sequence numbers and character codes which indicate status and highlight any gaps. Environment variable settings allow for custom log name formats and to check the DBNAME set within a log.
|Tags||Oracle verification Archive Log Utility|
|Operating Systems||Unix Linux|
Release Notes: Now supports 11gR2 as the default build. New routines have been added to support mixed processor architectures on the client and server. E.g. you can check archive logs from a SUN SPARC server on a Linux x64 client (and the converse). The release tar archive now includes a UNIX man page and Makefile.
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).