Dbvisit version Dbvisit 5.3.08 has been released. The complete list of new features and fixes are below.

New features:

  1. Send an email to ADMINS on successful completion of CSD (with trace) (Creation of Standby Database).
  2. Drop tempfiles on standby on completion of graceful switchover for oracle versions 11.2+. As a workaround for Oracle bug: 10292173: “This bug causes rman backups to fail if the tempfiles on the standby are more recent than on the primary”.

Fixes:

  1. Use db_unique_name instead of ORACLE_SID to access subdirectories under flash recovery area.
  2. Allow for different syntax of the asmcmd command to obtain asmcmd version. Previously caused Dbvisit call to asmcmd to hang.
  3. Improved logging for a remote execution of starting the standby database from the primary server.
  4. Make sure datafiles are given unique names when copied to/from temp location during CSD (Creation of Standby Database). Previously datafiles with different paths but same basenames overwrote each other.
  5. Ensure archive log gap report and heartbeat messages are sent to SUCCESS_MAILTO address if SUCCESS_MAILTO is set, not to ADMINS.
  6. Improve the graceful switchover option for RAC. Previously the log gap would not always be 0 to initiate the switchover. This is because the ALTER SYSTEM ARCHIVE LOG was done on the database level and not on the instance. Setting INSTANCE_CLAUSE_FOR_ARCHIVE_LOG_CURRENT = Y will add the optional INSTANCE clause to the ALTER SYSTEM ARCHIVE LOG command.
  7. Fix issue in AMM where it did not delete archives when number of archives reached the number specified by NUM_ARCHSOURCE_TO_KEEP.
  8. Fix issue in AMM where under some circumstances it deleted newer archives first.

Dbvisit can be downloaded from http://www.dbvisit.com/dbvisit_download.php

About Arjen Visser


As the Founder and Technical Director of Dbvisit Arjen is passionate about helping to create software that is highly effective and simple to use. With over 20 years of database experience in the IT industry, his technical expertise and extensive IT knowledge covers a broad range of industries and areas.