Upgrade Dbvisit Standby

1.  Introduction


The Dbvisit Standby upgrade process in Version 10 will be similar to the process in earlier versions.  There are a number of pre-requisites before upgrading:

  • Dbvisit Standby version to be upgraded MUST be at least version 9 or Version 8 (latest update recommended).
  • The Operating System and Database Version requirements are met.  
  • Dbvisit Standby version 10 will not work with Oracle versions lower than 10.2.0.5

Prior to performing any upgrades, it is recommended to make sure you have sufficient backups.  This is good practice for any software upgrade.

This can easily be done by just backing up the DBVISIT_BASE folder prior to installing the new version.


The rest of this section will take you through the upgrade process from Dbvisit Standby version 8.0.x, 9.0.x to 10.0.x


Important Notes:

  1. If you are using Dbvisit Standby version 5 or 6, you can either first install version 7 and then upgrade to version 8 then version 10, or install a new version 10 (in a separate location) and re-create your DDC configurations. You will not be required to recreate standby databases. 
  2. IMPORTANT: Before performing the upgrade process it is important to make sure that all pre-requisite checks were performed and met. Ignoring these can lead to Dbvisit Standby version 9 installation failure as well as Dbvisit Standby not behaving as expected. For more detail please see Installation Prerequisites
  3. If you are upgrading from version 7.0.x in an Oracle RAC configuration, please note the following:
    1. Dbvisit Standby version 8, 9 and 10 handles Oracle RAC configurations different.
    2. You MUST create a new DDC file from scratch - you cannot perform an upgrade as when using version 8 or 9 or 10 in an Oracle RAC configuration, the RAC settings in the DDC file is totally different. The upgrade process will not upgrade these old DDC files to the correct format - you must run the NEW DDC file creation.
    3. In Version 8 and above, Dbvisit Standby is more Oracle RAC aware and it is recommended to run Dbvisit Standby from only one node in the RAC cluster instead of running it on each of the nodes.
    4. There is no more RAC_TAKEOVER or RAC_TAKEOVER_FORCE settings in the DDC File and if set they will be ignored.
    5. Dbvisit Standby version 8 and above, will detect all Threads in the cluster and ship all archive logs, no need to set the takeover settings or have Dbvisit Standby run on both RAC nodes.
    6. We recommend the use of shared storage for the Dbvisit Standby installation - example the use of ACFS, which is then shared between the RAC nodes. This will allow Dbvisit Standby components such as Dbvnet, Dbvserver and Dbvagent to be added as cluster resources.
    7. If you do not have the option to create shared storage, you will have to use local storage. This does have some challenges, as if the node you are running on fail, you do not have shared storage that can fail over. To accommodate this, you can use a tool such as "rsync" to sync this folder between the RAC nodes. Then in the case of failure on the one node, you have the other node where you can then start Dbvisit Standby - note that we still recommend the use of a Virtual IP to be used.
      For more detail on Oracle RAC configurations, please see the advance Oracle RAC configuration section in the documentation

For creating a new Oracle RAC DDC files see the examples here

  1. Oracle RAC primary to Single Instance standby - Creating the DDC File#2.5.CreateaDDCFile-OracleRACprimarytoSingleInstanceStandby
  2. Oracle RAC primary to Oracle RAC standby - Creating the DDC File#2.4.CreatingaDDC-OracleRACprimarytoOracleRACstandby



2.  Linux - Upgrade from Dbvisit Standby version 7.0.x

If you are using Dbvisit Standby 7.0.x you must first upgrade to Dbvisit Standby version 8 before you can upgrade to version 10.0.x. You can directly move to Version 10.0.x by doing a fresh install and creating a fresh DDC file. Remember you don't have to re-create your standby database for moving Version 7.0.x to Version 10.0 if your standby already exists and is in sync.

For more details on upgrading from version 7.0.x to version 8.0.x please see the Dbvisit Standby version 8 documentation. 


3.  Linux - Upgrade from Dbvisit Standby version 8.0.x or 9.0.x  to 10.0.x


It is recommended to be on the latest update of Dbvisit Standby version 8 or 9 prior to upgrading to version 10.

The upgrade process consists of two key steps:

  1. Upgrade (install) the new version 10 software.
  2. Upgrade the DDC files and repository to reflect the latest release.

When upgrading from version 8.0.x or 9.0.x, the process is easy and should only take a few minutes.

The high level recommended steps are:

  1. Stop your Dbvisit Schedules if you have any running.
  2. Stop or wait for any Dbvisit processes that might still be executing.
  3. Backup the Dbvisit Base location where your software is installed.
  4. Download the latest version from www.dbvisit.com
  5. Extract the install files into a temporary folder, example /home/oracle/10.0
  6. Start the Installer and select to install the required components.
  7. Once the update is complete, you can remove the temporary install folder where the installer was extracted.
  8. Apply the new version 10 license key.
  9. It is recommended to run a manual send/apply of logs once an upgrade is complete.
  10. Re-enable any schedules

The section below will show you a detailed example of the upgrade process.

3.1.  Example 1 - Upgrading Dbvisit Standby Core Components

The first example shows the upgrade process for the Dbvisit Standby version 8 core components which include - Dbvnet, Dbvagent and the Standby Core CLI.

The steps followed below are:

3.1.1.  Prerequisite Steps

  1. Stop all schedules if used - on Unix systems if schedules are used it would be via the UNIX "CRON" schedule.  You can use the "crontab -l" command to list any schedules and if you want to edit them use "crontab -e
  2. Stop the Dbvisit components. Check the processes running and by running ps -ef |grep dbv which would list out processes that are running and you can stop them. Below is the example for stopping the Dbvisit components from both primary and standby. We have our dbvserver installed in the standby server in this example.


  1. Backup the Dbvisit Standby installation directory (optional - but recommended)

    In this example, we will backup the /usr/dbvisit directory using the "tar" command to create a backup in a backup folder called /home/oracle/backup.  You can use the "du -sh" command to confirm the /usr/dbvisit directory size prior to backup.  The "tar" command used in this case will use the -z option to enable compression.




Now that the required process is stopped and a backup is created, you can continue with the upgrade process.

3.1.2.  Start The Upgrade Process

  1. Download the latest installation package and placed it in /home/oracle/10.0 folder - which was empty 
  2. A listing of the install file is shown
  3. The install package is then extracted using the "unzip <package-name>.zip" command followed by the extracting of the archive file with the command "tar -xf <package-name>.tar"
  4. You will now have a subfolder called dbvisit with the install files located inside.
  5. Navigate to the dbvisit/installer subdirectory with cd dbvisit/installer 
  6. The installer is then started with the command: ./install-dbvisit 
  7. The first question that will be asked is the destination installation path also known as the Dbvisit Base directory, in the example, the default is used "/usr/dbvisit" as this is where the previous version was installed, that we want to upgrade.
  8. The next screen will display a summary of the options installed as well as the new installer version.  (The major or minor version numbers may be different)
  9. You will be asked to confirm if you want to Install, Uninstall components or Terminate the installer.  In this case, we want to select "Install" which is option "1"
  10. The following menu option will display the 6 possible options.  In this case, we have the Core components installed - dbvnet, dbvagent and standby (CLI) and we would like to upgrade them.  We select option "1" to continue upgrading these 3 components.
  11. The installer will now start updating the Standby Core (CLI) first, followed by Dbvnet and then the Dbvisit Agent (dbvagent).  
  12. Once the update is complete, you will be presented with a menu showing you the installed components and their versions.
  13. Select the option "3" to Terminate the installer as we are not complete with this step.


The example below shows you the steps as discussed above:



Next steps is to upgrade Dbvisit Standby Core components (Standby Cli , Dbvnet and dbvagent) in the Standby Server. 


3.1.3.  Upgrade The DDC File


The next step is to update the Dbvisit Standby Configuration (DDC) files which are located in DBVISIT_BASE/standby/conf directory. Before doing the below step please start all components from both primary and standby.


During this upgrade process, the original DDC file will automatically be backed up with a date-timestamp suffix.

The command to upgrade the DDC files is:  ./dbvctl -d <DDC> -o upgrade 


After the upgrade is completed you have to apply the version 10.0 license from the Primary before we can start sending and applying logs.


3.2.  Example 2 - Upgrade Central Console (Dbvserver)

This section will show you the upgrade process for the Dbvisit Standby version 10 Central Console (Dbvserver).  

The process is similar to the upgrading of the core components, but in this case, the Dbvserver component will be selected for installation (upgrade).

Prior to upgrading the Dbvserver component, it is required to first stop Dbvserver if it is already running followed by a backup of the installation destination (Dbvisit Base). 

3.2.1.  Prerequisite Steps

The steps are similar to what we have used earlier for Dbvnet and Dbvagent, the steps for Dbvserver is shown below:

  1. Stop Dbvserver:

    First, we confirm if the process is running, if it is we stop it using the "./dbvserver -d stop", followed by confirming no dbvserver processes are running.

    [oracle@dbv103 dbvisit]$ pwd
    /usr/dbvisit
    [oracle@dbv103 dbvisit]$ ps -ef|grep dbvserver|grep -v grep
    oracle   26664     0  0 22:25 ?        00:00:00 ./dbvserver -d start
    [oracle@dbv103 dbvisit]$
    [oracle@dbv103 dbvisit]$ cd dbvserver
    [oracle@dbv103 dbvserver]$ ./dbvserver -d stop
    dbvserver attempt to stop pid: 26664
    [oracle@dbv103 dbvserver]$
    [oracle@dbv103 dbvserver]$ ps -ef|grep dbvserver|grep -v grep
    [oracle@dbv103 dbvserver]$



  2. Backup the Dbvisit Standby installation directory (optional - but recommended)

    In this example, we will backup the /usr/dbvisit directory using the "tar" command to create a backup in a backup folder called /backup.  You can use the "du -sh" command to confirm the /usr/dbvisit directory size prior to backup.  The "tar" command used in this case will use the -z option to enable compression.

    [oracle@dbv103 dbvisit]$ pwd
    /usr/dbvisit
    [oracle@dbv103 dbvisit]$ tar czf /backups/usr_dbvisit.tar.gz .
    [oracle@dbv103 dbvisit]$ ls -al /backups/usr_dbvisit*
    -rw-r--r-- 1 oracle oinstall 3755257 Sep  5 22:27 /backups/usr_dbvisit.tar.gz
    [oracle@dbv103 dbvisit]$

3.2.2.  Upgrade Dbvserver

We are now ready to perform the upgrade of the Central Console (Dbvserver).

Below are the example steps followed to upgrade the Dbvserver component:



4.0.  Windows - Upgrading from Dbvisit Standby version 9.0.x to 10.0.x

Important: Prior to installing Dbvisit Standby version 10 on Windows, please make sure you have performed the pre-requisite steps prior to starting the installer - Installing Dbvisit Standby#2.5.WindowsEnvironmentPre-requisites

In this section, we will review the process to upgrade an existing Dbvisit Standby version 9 installation to the latest version 10.  It is recommended that before you perform the upgrade process that you have the Dbvisit Standby version 9 already at the latest version 9 update.  

When upgrading a Windows-based installation, there are only a few key steps to follow.  In summary, the installer will ask for the Dbvisit Base location to install the Dbvisit Software.  If you already have an installation, please make sure you select the existing installation folder as the destination.  The installer will detect that a version is already installed and will perform the upgrade - replacing the version 8 executable files with the new version 10.

4.1.   Prerequisites

The first step to stop any schedules if you have any configured.

The example below shows the disabling of a Windows scheduled task.  Select the task, right click and select disable.


If you are using Daemon service, Please stop the daemon process in both Primary and Standby

  1. Click on Daemon Actions
  2. Select the host for which you want to stop the daemon service
  3. Click stop to completely stop the daemon service.


Below screenshot will provide the status of the daemon service.

4.2.  Step 2: Installing the latest version 10.0.x software

  1. Download the latest Dbvisit Standby version 10 software, the install file will be a compressed zip file, example:  dbvisit-standby10.0.0-win64.zip
  2. Extract the downloaded install file into a temporary folder, example D:\Software\dbvisit-standby10.0.0-win64.exe
  3. Make sure that you have stopped the Dbvisit Standby schedules and that you are not running any Dbvisit processes during the upgrade process.  Stop the dbvagent and dbvnet services in both Primary and Standby. Also, stop the dbvserver service before proceeding with the installation. In this example the Primary server has dbvagent and dbvnet service and the standby has dbvagent,dbvnet and dbvserver services running. We also have the daemon service running which was stopped in the previous step.

4. Start the Installer by running (double click) the dbvisit-standby10.0.0-win64.exe file

The installer will start shortly. By default the installer will have the Dbvagent, Dbvnet and Standby CLI selected.  Note that the Dbvserver (Central Console) is not selected.  This is intentional as it is recommended to have the Dbvserver component installed on its own system.  However, if required you can install the central console as part of the installation, but be advised that this is not recommended(We need to select it for this example as we have installed the dbvserver in standby).  If the primary or standby system running the Central Console is down due to a disaster, you will not be able to access the Dbvisit Standby version 10 GUI. The installation process is similar to the Dbvisit Version 9.0.x installation process. The Dbvnet, Dbvagent and the Dbvserver configurations are updated and the services are started.


5. Once the above step is completed. Run the upgrade command from the Primary dbvctl.exe -d <DDC> -o upgrade . This has to be done before starting the daemon process in both primary and standby.

6. Apply the version 10 license key before starting the daemon service from Primary.

7. Now run the Archivelog send/apply manually and then start the daemon process for the automatic process to take over.


5.  Steps performed post upgrade in the central console.

The steps performed are common for both Linux and Windows, After the CLI upgrade the GUI repository needs to updated with the latest DDC information.

1. Open the browser and type in the console address to view the version 10.0 GUI interface and to check the DDC file go to Manage Configurations page.

2. The DDC should still show the old version and allow you to click on the status to upgrade to the Version 10.0 release.

3. After the above step, you should see the current version of Dbvisit Standby and also the status showing a tick mark.

4. Post upgrade the Database Actions screen with Time Gap displayed between Primary and Standby (This will be displayed only after the first send and apply of archivelogs).


IMPORTANT:  Please make sure that you have upgraded both primary and standby Dbvisit Standby software prior to upgrading the DDC files.  This includes making sure Dbvnet is running on both systems.

For more detail on network communication please see - Dbvisit Standby Networking - Dbvnet#Dbvnet-5.TestingDbvnetCommunication

In Windows, you may have to delete the old daemon service, install it and start it,  please see Dbvisit Standby Scheduling

6. Blogs & Videos

6.1 Upgrade from Dbvisit Standby v8 to v9 on Linux

https://dbvisit.com/blog/upgrade-dbvisit-standby-v8-v9-linux

6.2 Upgrade Dbvisit Standby v8 to v9 on Windows

https://dbvisit.com/blog/upgrade-dbvisit-standby-v8-v9-windows