Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

1.  Introduction

This section will provide you with an overview of the new release updates of Dbvisit Standby version 10.  

Note

To check your current Dbvisit Standby Version and Release from the command line.

./dbvctl -V


Dbvisit Standby as of version 10 caters for the following operating systems:

  • Linux
    • Oracle Linux 6, 7 and 7 8 (64 bit)
    • Red Hat 6, 7 and 7 8 (64 Bit)
    • SLES 11 and 12 (64bit) 
  • Windows (See known issues below)
    • Windows Server 2008 and above (64bit)
Note

Dbvisit Standby Version 10 is supported only on Windows and Linux platforms


Dbvisit Standby version 10 supports the following Oracle Database versions:

  • Oracle Database 10gR2 (10.2.0.5 recommended) - If using ASM 11gR2 version required for Graceful Switchover 
  • Oracle Database 11gR2
  • Oracle Database 12cR1 and R2
  • Oracle Database 18c (Supported exclude Oracle 18c RAC)18c 
  • Oracle Database 19c - Linux
  • Oracle Multi-tenant for Oracle SE2 is supported
    • New pluggable databases can be added to an existing primary database, which will be propagated to standby database when you send and apply archivelogs.
    • Max of 3 pluggable databases is allowed in the primary databases. If you are adding more than 3 pluggable databases, please contact Dbvisit support.

1.1.  Important Notes

There is a number of changes being introduced with each update.  Some updates may come with specific requirements.

  • The Central Console must be installed on a Linux or Windows-based system (Linux recommended).
  • Dbvisit Observer (Auto-Failover tool) must also be installed on a Linux or Windows-based system
    • .


Panel

On this page:

Table of Contents


2.  Known Issues

It is possible that some of the release updates will include known issues.  This section should be reviewed for any new release.  

2.1.  Windows

  • Dbvisit Standby currently only supports ipv4, not ipv6.
  • It was noted that on windows Windows ipv6 may be favoured, and if the hostname resolution is not ipv4, Dbvnet, Dbvserver and Dbvagent might may listen on ipv6 when started.It is recommended to make sure the hostnames used in the Dbvisit Standby configurations, resolve to an ipv4 address and not ipv6.
  • If Dbvnet, Dbvserver and Dbvagent are not able to listen on ipv4 due to name resolution favouring ipv6, you will have to make use of ipv4 IP addresses in the Dbvnet, Dbvagent, Dbvserver configuration files as well as your Dbvisit Standby DDC file (for the SOURCE and DESTINATION)
  • Using the following commands after starting Dbvnet, Dbvagent and Dbvserver, you will be able to identify if whether it is listening on ipv4 or ipv6:
    • Dbvnet:   netstat -an|findstr 7890
    • Dbvagent:  netstat -an|findstr 7891
    • Dbvserver: netstat -an|findstr 4433
  • Dbvisit Standby includes Oracle 12.1 2 Instant Client libraries by default. If your system has a different version of Oracle installed, it is possible under some rare circumstances for a library version conflict to occur. If you experience any errors similar to "PRKN-1008: Unable to load the shared library orasrvmhas12.dll", you can usually resolve them easily by renaming this library in the dbvisit/standby folder to "orasrvmhas12.dll.12.12" or by using replacing the 12.1 Instant Client libraries in dbvisit/standby or dbvisit/standby/lib (depending on your operating system) with the 12.2 equivalent files. Please do not change any of these libraries in your Oracle Database Installation.
Note

From Dbvisit Standby v10 onwards, there is an option provided to you for choosing the Oracle instant client libraries. By default, the libraries are Oracle 12.2, else otherwise you can choose to use Oracle 12.1 libraries.


3.  Change Log

Important Notes  

Oracle 10gR2 (

10.2.

0.5) is now supported - using the latest patch set 10.2.0.5 is required
  • IMPORTANT:
    • This excludes Oracle 10g RAC configurations which are not supported
    • If using Oracle ASM - the version of ASM must be 11.2 and above (Graceful Switchover will not be possible if ASM version of 10.2 is used)
  • Using SSH as communication between primary and standby hosts is fully supported. The default is to use Dbvnet, but SSH password-less communication is still supported.
  • For reference on changes and bug fixes done for Dbvisit Standby v10, please refer below.

    9.0.18 (27 October 2020)

    New Feature:

    Oracle Unified Auditing support - Graceful Switchover now fully supports Oracle Unified Auditing.

    New separate mail notification address options (Success, Error, Heartbeat, Alert, Log Gap)

    Updates:

    Dbvisit Standby Snapshot option

    DS9-505: Dbvisit Snapshots - Databases inside Single Snapshots can now be manually stopped/started
    DS9-651: Dbvisit Snapshots - Improved archive log apply process when done in conjunction with a pre-processing script
    DS9-638: Dbvisit Snapshots - Improved edge-case handling of in-Snapshot database state changes

    Dbvisit Standby

    DS9-698: Dbvnet now capable of advanced automatic network error resolution, making connections and remote executions more robust
    DS9-699: New auto-retry logic making log file transfers more reliable on unstable networks
    DS9-653: Sensitive user information (such as email passwords) now always encrypted in configuration files
    DS9-703: Dbvserver now supports HTTP Strict Transport Security
    DS9-714: It is now possible to Cancel Tasks that are in a Paused state, e.g. CSD/Sync using transportable media
    DS9-663: Added timestamps to all Task progress messages
    DS9-615: Improved pre-check handling/user input validation for DR Testing
    DS9-364: Create Standby Database process now possible using non-compressed backups
    DS9-706: Graceful Switchover will no longer create two Tasks in the GUI instead of just one

    9.0.16 (22 July 2020)

    New Feature:

    Advanced Task Tracking - Tasks in the Dbvisit Standby Central Console now offer significantly more information about database events, including accurate tracking of who/what initiated the Task, allowing Tasks to be stopped/terminated right from the Central Console, offering guidance on a variety of possible error states, and retaining relevant process information even after a host-side process crash.

    Dbvisit Standby
    DS9-666: Security improvements for handling connection to the Oracle database
    DS9-636: Significantly reduced chances of Dbvisit Standby sqlite database locking under heavy workloads
    DS9-643: Enabled the Create Standby Database process to more gracefully handle various errors during the creation of the standby database
    DS9-633: Improved handling of backups for databases using RMAN BACKUP OPTIMIZATION
    DS9-646: Changed Dbvisit services to startup type Automatic Delayed on Windows systems
    DS9-604: AMM log maintenance improved after Graceful Switchover
    DS9-652: Dbvisit Observer can now connect to mailservers through SSL, including new optional settings to ignore certificate errors for connection test purposes
    DS9-644: Improved Dbvisit Observer behaviour when working with very slow mailservers
    DS9-657: Improved Japanese translations
    DS9-671: Better display for Task errors caused by manual user interactions (e.g. kill signals)

    9.0.14 (28 May 2020)

    New Feature:

    We now provide the capability for different network ports for primary and standby configurations allowing management of DR environments across different network segments.

    Updates:

    Dbvisit Standby Snapshot Option

    DS9-603: Dbvisit Snapshot Groups information now updates more frequently and handles more potential database states
    DS9-610: Creation of up to 4 Snapshots in a Snapshot Group is now possible

    Dbvisit Standby

    DS9-629: Fixed several memory leaks in dbvagent & dbvserver executables, especially affecting Windows installations
    DS9-512: File handling operations during periods of inconsistent network connection are now more robust
    DS9-599: Added support for using ACFS when using Oracle RAC (please note that using ASM for Oracle RAC is still the recommended option)
    DS9-515: Fixed inconsistent DR Test behaviour on environments hosting multiple DDCs sharing the same database name
    DS9-526: Introduced new NETPORT_DR parameter in DDCs to enable independant custom port configurations on both Primary & Standby
    DS9-533: Improved Japanese language translation
    DS9-597: Improvements to functionality and clarity of the ntf_repo_maintain function to enable easier Task clearing/maintenance

    9.0.12 (9 April 2020)

    New Features:

    Dbvisit Snapshots now support the use of custom database parameters
    Dbvisit Snapshots can now execute custom pre/post-processing scripts during each Snapshot creation

    Updates:

    Dbvisit Standby Snapshot Option

    DS9-537: Ensured activation process will always start regardless of Snapshots state
    DS9-531: Fix Snapshot creation failure if Volume Group contains an extra dash "-"

    Dbvisit Standby
    DS9-503: Changing database state (e.g. RW/RO) now also affects all related PDBs
    DS9-509: Fixed rare Windows installation error
    DS9-513: Improved support for the APPLY_DELAY_LAG_MINUTES setting on 19c
    DS9-527: Improved handling of log shipping after Graceful Switchover on Windows RAC environments
    DS9-521: Include the Disaster Recovery Test repository in the Dbvisit Support Package
    DS9-532: Updated descriptions and text prompts for Log Gap Report to be more clear on Standby sequence state
    DS9-534: Dbvisit Support Packages can now be created even if the database is down
    DS9-472: Improved dbvnet & dbvagent logging and error handling

    9.0.10 (4 March 2020)

    Updates:

    Dbvisit Standby Snapshot Option

    DS9-483: Snapshots created as part of a Snapshot Group can now have activated (i.e. read-write) databases
    DS9-487: Significantly improved error reporting for Snapshot functionality
    DS9-492: Improved Snapshot Alerts behaviour and timeliness

    Dbvisit Standby

    DS9-478: Updated Dbvisit-provided SSL security certificates
    DS9-438/495: Improved Task type and source reporting, added new Task types and new distinctions between User (GUI), Daemon and CLI Tasks
    DS9-446: Resolved all LIBPATH issues on AIX systems
    DS9-479: dbvnet can no longer over-utilize CPU on AIX systems
    DS9-488: MAXDATAFILES value now taken from the origin database during control file creation
    DS9-497: Made the behaviour/distinction between the "dbvctl -c" and "dbvctl -C" commands more intuitive
    DS9-468/499: Improved clarity of terms and parameter descriptions in the Dbvisit product installer
    DS9-269: Opening databases RO through the GUI now also causes all PDBs to open read only also

    9.0.08 (6 December 2019)

    Updates:

    DS9-306: The dbvctl upgrade procedure now requires confirmation that it is being executed on the primary location, in order to avoid erroneous executions on standby
    DS9-323: Dbvisit Observer now has more available actions through the Central Console for resolving various error states
    DS9-381: Improved special-case error messaging for the Dbvisit Snapshots Utility, e.g. attempted use of the Apply Log Gap parameter
    DS9-382: Added new example Dbvisit Observer Custom User Script for Windows
    DS9-398: Disaster Recovery Testing functionality made more robust & reliable, especially in ASM environments
    DS9-401: Improved UX of DDC/CSD parameter editing through the Central Console
    DS9-435: Improved consistency for Central Console reporting of CLI-generated Tasks
    DS9-449: Improved Dbvisit Observer's ability to handle monitoring multiple DDCs at the same time
    DS9-448: CSD creation can now be run from template data stored in a JSON file (using the -j option)
    DS9-453: Improved licence key parameters visibility - the Licence page will now display any available permissions for extra features, e.g. Dbvisit Snapshots
    DS9-471: Improved error reporting for attempting to create Snapshots on unsupported environments, e.g. Windows or non-LVM systems.

    9.0.06 (18 November 2019)

    Features:

    Dbvisit Snapshots - Quickly create automated snapshots of your standby databases

    Updates:

    DS9-298: Dbvisit Observer now allows sendmail interaction on port 25 without AUTH
    DS9-398: Extended length backup image file names now supported
    DS9-399: MAILCFG_FORMAT DDC parameters now editable through the Central Console

    9.0.04 (10 October 2019)

    Features:

    Dbvisit Observer is now available for Windows systems

    Updates:

    DS9-245: Long DDC/Host names should now display nicely on Manage Configurations & Manage Databases pages
    DS9-265: The Installed Databases dropdown during DDC creation should now correctly populate on Windows systems
    DS9-281: Running Graceful Switchover should now always cause the Central Console to auto-update the Host relationship
    DS9-308: Daemon commands from the Manage Databases page will now always execute correctly on all supported operating systems
    DS9-310: Dbvisit Observer logs will now by default go into the same directory as the executable
    DS9-312: "User"-level accounts can now create DDCs between Hosts linked to the User's account
    DS9-313: Add New Host quick-guide now appears correctly
    DS9-314: DMN_MAX_FAIL_NOTIFICATIONS now always works as intended
    DS9-318: Dbvisit Observer actions are now correctly hidden from "User"-level accounts
    DS9-324: Support Packages are now correctly generated in cases of remote execution errors
    DS9-332: dbvagent now capable of handling multiple simultaneous Task requests
    DS9-358: DDC version records on the webserver are now always correctly updated after upgrading DDCs
    DS9-360: It is no longer possible to delete DDCs before disabling Dbvisit Observer monitoring

    9.0.02 (15 July 2019)

    Changes:

    1. New Dbvisit Observer component - remotely monitor your Dbvisit Standby Configurations (DDCs), and auto-failover if necessary
    2. New languages - added Chinese Traditional & Chinese Simplified to the available Central Console (GUI) language options
    DS9-266: Oracle Real Application Cluster (RAC) databases now correctly open in read-only mode
    DS9-283: Log gap report is now correctly attached to scheduler emails
    DS9-243: Password files now correctly copied into Oracle Automatic Storage Management (ASM), if used
    DS9-235: The Disaster Recovery (DR) Test option can now be run in batch mode from the Command Line Interface (CLI)
    DS9-234: The read only test "ro_test" can no longer be run on primary system using the CLI

    9.0.00 (31 May 2019)

    Changes:

    1. New Central Console look and feel - better performance and usability
    2. New Central Console languages - now available in English, French, German, Spanish and Japanese
    3. New Improved and streamlined Create Standby Database (CSD) process
    4. New Disaster Recovery Actions functions - easily test whether your environment is ready to switchover, without affecting your Source location (this includes the option to create backups prior to activation)
    5. New Alert notifications in Central Console - automatic notifications and event tracking in case of important events, e.g. log gap threshold exceeded
    6. New Interactive graphs - statistical information available for host/CPU load and DDC log time gap
    7. New User guides - not sure how to perform a CSD, Sync or other action? Let our new interactive guide system lead you through it step by step.
    8. Command Line Interface (CLI) core tasks will now be pushed to Central Console, making CLI tasks visible in the Console
    9. Better emails - introducing HTML templates
    10. Hundreds of minor improvements to usability, stability, performance and customisation2 (25 Sep 2023)

    • Fixed Security vulnerability prone to SWEET32 attack(CVE-2016-2183)

    • Fixed Security vulnerability for session cookie not using HttpOnly. Now, the session cookie uses HttpOnly. 

    • New default certificates expiring Nov 2025

    10.2.0 (21 March 2022)

    * New Feature: Added full support for Standard Edition High Availability (SEHA) environments

    STDBY-818: Improved interaction between automated log shipping and DR Test Activation
    STDBY-530: Observer settings can now be adjusted regardless of Configuration state
    STDBY-886: Improved PDB state detection during certain edge-cases
    STDBY-795: Replaced statistical Time Gap information with on-demand, real-time "get Time Gap" option
    STDBY-853: Introduced non-standard block size detection and related warning messages
    STDBY-854: Better handling for Graceful Switchover on certain RAC environments
    STDBY-866: Improved automated log shipping on standby cascade environments
    STDBY-874: Significant performance improvements to PDB export processes
    STDBY-880: Corrected logical volume deletion during Snapshot creation
    STDBY-883: Standby DR Testing functionality improved when ASM diskgroups are used
    STDBY-889: Improved Support Package content
    STDBY-902: Resolved Local Temp Tablespace setting problems when combined with Unified Auditing
    STDBY-913: Resolved Configuration creation failing on certain ASM standby cascade environments

    10.1.0 (14 July 2021)

    New Feature: User Interface has been updated to incorporate new Dbvisit branding that is launching from early August 2021

    STDBY-834: PDB datafiles are now synchronized to standby in parallel with archive logs, allowing for transfer of large PDBs without impacting log gap
    STDBY-823: Significantly reduced dbvnet memory consumption
    STDBY-842: Significantly improved use of disk space during CSD/log transfer, by removing backup files as soon as they are transferred or used
    STDBY-845: Detailed state detection for unsynchronized PDBs now available, with full information for identifying and resolving potential problems
    STDBY-810: Improved automatic handling of FRA space during DR Test processes
    STDBY-811: Replica & Snapshot creation now works seamlessly with DR Test Switch To Copy operations
    STDBY-816: PDBs can now be automatically refreshed if the name on standby is different to primary
    STDBY-851: Improved PDB handling on non-OMF environments
    STDBY-852: Improved feedback for consequences of Graceful Switchover on Configurations with closed PDBs
    STDBY-857: Improved PDB state information on setups with multiple threads
    STDBY-862: Improved automatic issue resolution for Reinstate from DR Test on ASM environments
    STDBY-839: Dbvnet now always correctly respects environment variables
    STDBY-843: Dbvserver user account information is now encrypted on disk
    STDBY-825: Renewed SSL certificates used during network communication
    STDBY-836: Improved Snapshots Pre/Post-Processing
    STDBY-656: Better feedback for attempting to use DR Test functions while Snapshots exist on the standby
    STDBY-837: Improved tempfile handling for PDBs during Graceful Switchover
    STDBY-813: Normal restore points no longer cause Graceful Switchover pre-checks to fail
    STDBY-817: Corrected various terms in Japanese
    STDBY-864: Manage Databases page in GUI is now more efficient in using system resources
    STDBY-829: PDB exports are no longer affected by the DMN_DBVISIT_TIMEOUT setting

    10.0.0 (1 January 2021)

    New Feature: Oracle Multitenant support - Seamlessly handle creating and deleting up to 3 Pluggable Databases, always ensuring your standby database is correctly kept up to date.

    New Feature: Reporting Replicas & Test/Dev Snapshots - Save costs and improve performance by fully utilizing both your production and standby environments. Reporting Replicas enable offloading performance-intensive tasks from your primary database onto your standby database, while ensuring that you always have fresh data to work with. Test/dev Snapshots  allow for very quick creation of test/dev environments, often within seconds.
    This feature replaces the optional Dbvisit Snapshots feature in Dbvisit Standby version 9+.

    New Feature: New & Improved Network Management Utility - A new and upgraded Dbvnet, with all-new logging capabilities, better handling of unstable networks and automatic resolution of remote execution errors. Improve the reliability and resilience of your DR solution by getting the most out of your network.

    New Feature: Upgraded Central Console - An updated, more streamlined central console (GUI) with full multi-language support.

    STDBY-481: Dbvisit Standby v10 now comes with Oracle Instant Client libraries 12.1 and 12.2 (default 12.2). Selection of which one to use is possible during the installation process.
    STDBY-783: Graceful Switchover is now possible on Windows environments with both Oracle Unified Auditing and Oracle versions 12.1 and lower
    STDBY-763: Improved interaction of Snapshot creation and Parallel Recovery
    STDBY-802: Improvements and fixes for DDC parameter handling during Graceful Switchover on RAC environments
    STDBY-525: Host status indicators on the Manage Databases page are now real-time
    STDBY-613: Added new options for setting custom DB_DOMAINS on Snapshots
    STDBY-788: Added handling for historical Tasks with missing timestamps
    STDBY-785: Observer will no longer send emails for all monitored DDCs when only one is updated
    STDBY-775: Improved Mail function logging
    STDBY-744: Dbvisit Reporting Replica Snapshot creation time interval is now in minutes instead of seconds
    STDBY-756: Dbvisit Observer now automatically updates itself with any changes to Host configurations (e.g. passphrase)
    STDBY-752: Dbvisit Observer now correctly handles Host passphases containing rare special characters
    STDBY-760: New warnings and user notifications implemented for possible interactions of Reporting Replicas and DR Test functionality
    STDBY-738: Updated description of update_dbenv_file function in help text