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.
SSA SQL sniffer is an TCP SQL stream adapter that allows you to capture, adapt, and forward TCP streams with SQL statements sent through the network. It allows you to adapt your software database repository to a different database. It has an Oracle/PostgreSQL driver to perform conversion from an Oracle TCP SQL stream to PostGreSQL. It supports SELECT, INSERT, UPDATE, and DELETE.