Upgrading from version 5.3.x or 6.0.x or 7.0.x to 7.0.x

Please note:

1. Upgrading of Dbvisit Standby software needs to be done on both the primary server and standby servers.

2. For Oracle RAC, the upgrade needs to be done for each node.

3. When upgrading, you will install Dbvisit Standby version 7 into the exact same location as what the current (older) version was installed. Example if you have version 6 installed in /usr/local/dbvisit you will need to make sure you select this same path when asked by the installer what the location (destination) is of the installation. The upgrade process is an in-place upgrade. Do not install Dbvisit Standby version 7 into a separate location, unless you plan to recreate the DDC files from scratch.

4. You may want to create a backup of the Dbvisit Standby install directory for rollback purposes. (all Dbvisit software is contained within the main directory).

5. Existing 7.0 license keys are automatically applied to the new software.

6. Existing 5.3.x and 6.0.x license keys are NOT valid for 7.0. Contact Dbvisit Sales to obtain 7.0 license keys if you have current Dbvisit support.

7. Your current Dbvisit Database Configuration (DDC) configurations will be upgraded and a new configuration (DDC) file will be created. A backup of the original DDC file will be created.

Upgrade Steps

The upgrade steps for Dbvisit Standby in a single or cluster (Oracle RAC) configuration are the same. Where different steps are required this will be highlighted.

Recommended: Before starting the upgrade, it is recommended that the standby database is up to date with the primary database (this is not required, but recommended - all archive logs in the Dbvisit Standby ARCHDEST on the standby server should have been applied to the standby)

The upgrade process is an "in-place" upgrade, meaning you install the version 7 software into the exact same location as your previous version.

When upgrading you will run the installation process exactly the same as you would perform a new installation, with the exception that you need to make sure you specify the location of the current Dbvisit Standby installation during the installation, known as the Dbvisit Base directory.

For example, if you currently have Dbvisit Standby version 6 installed in /usr/local/dbvisit or /opt/dbvisit you will need to make sure that during the installation process that you specify this location as your installation location. When Dbvisit Standby version 7 is installed, the installer will upgrade the required files in this location.

On a high level the upgrade process can be seen as:

Stop your Dbvisit Standby schedules on all systems
Stop Dbvserver (GUI) if you are using it
Stop Dbvnet (Dbvisit Networking)
Download the new Dbvisit Standby version 7 software which will be in a zip archive.
Extract the downloaded software into a temporary directory, example /home/oracle/7.0/ (this is just temporary, once the installation is complete, you can remove this directory)
Start the installer from the extracted download (making sure you select the previous versions, installation directory during installation)
Note that during the installation process if you are upgrading a previous installation, you must select the previous installation base directory for the DBVISIT_BASE.
Example, if you have Dbvisit Standby version 6 installed in /usr/local/dbvisit then you have to install version 7 in the same location.
During the installation, the version 6 DDC files located in DBVISIT_BASE/standby directory (example /usr/local/dbvisit/standby/dbv_PROD.env) will be upgraded to version 7 DDC files and will be copied to the new conf directory under the standby sub directory (example /usr/local/dbvisit/standby/conf/dbv_PROD.env)
Update the Dbvisit Standby Repository
Update the Dbvisit Standby Configuration files (Optional if you want to edit parameters as part of the upgrade)
Remove any old temporary files (*.dbv) that might be located in the DBVISIT_BASE/standby/tmp directory (example /usr/dbvisit/standby/tmp/)
Start Dbvserver and Dbvnet if you did not select the auto start during the installation of the new software
Start your Dbvisit Standby schedules
Once the installation is complete, you can remove the install files, example if you extracted the installer into /home/oracle/7.0/ you can remove this temporary directory.

The next section will provide a more detail overview of the upgrade steps to follow:

In Dbvisit Standby version 7 the Archive logs are renamed when they are copied to the standby server (in the Dbvisit ARCHDEST location). Before upgrading, make sure the standby have already applied all the archive logs that was available in the Dbvisit standby ARCHDEST. New archive logs in this location will have the new naming convention.

<thread>_<sequence>_<resetlogs_id><STANDBY_ARCHIVELOG_NAME_EXTENSION>

Where STANDBY_ARCHIVELOG_NAME_EXTENSION defaults to .arc

Example: 1_45628_ 812975118.arc

Step 1: Stop your Dbvisit Standby schedules, Dbvserver (GUI) and Dbvnet

It is recommended that before you start the upgrade that the standby database are up to date with the primary database - meaning all archive logs in the Dbvisit Standby ARCHDEST on the standby server should be applied to the standby. This is not a strict requirement, but recommended.

Stopping the Schedules

All schedules should be disabled on all servers involved in the Dbvisit Standby configuration.

If you make use of the Unix CRON scheduler for Dbvisit, it is recommended to disable these schedules before performing the upgrade.
If you are using the Dbvisit Scheduler - available in the web based GUI, you will need to first login to the current GUI installation and disable all schedules on all primary and standby nodes. The Scheduler menu can be found under the "Run" main menu option.

If you are already making use of Dbvisit Standby version 7 and upgrading to a new update of version 7, please make sure you stop both Dbvserver (GUI) and Dbvnet (Networking) before you start the upgrade process.

If you are upgrading from a version prior to version 7, example version 6.0.54 then you only need to stop Dbvserver (GUI) as Dbvnet was not part of previous releases.

Stop Dbvserver

To stop Dbvserver (the web based front-end), run the command "./dbvserverd stop" from the DBVISIT_BASE/dbvserver directory:

cd /usr/dbvisit/dbvserver
./dbvserverd stop

Stop Dbvnet

To stop Dbvnet (Dbvisit Network), run the command "./dbvnetd stop" from the DBVISIT_BASE/dbvnet directory:

cd /usr/dbvisit/dbvnet
./dbvnetd stop

Step 2: Download Latest Software

The next step is to download the latest available version if you have not already from the Dbvisit web site http://www.dbvisit.com

If you are upgrading from version 5.0.x or 6.0.x to version 7 you will need to obtain a new license key from Dbvisit Sales team.

The upgrade free at no additional charge for support paying customers.

Once the software is downloaded, you can copy it to a temporary location on your server.

In this example, we create a temporary directory called 7.0 in /home/oracle and copy the software download into this directory.

We now have the following structure:

oracle@dbvlin101[/home/oracle/7.0]: ls -l
total 44084
-rw-r--r-- 1 oracle oinstall 45089534 Aug 21 10:40 dbvisit-standby7.0.01_linux.zip

Step 3: Extract Software

The next step is to extract the software downloaded in the previous step as well as updating the install-dbvisit file permission to allow the execution option.

First use "unzip" to uncompress the downloaded software package, followed by using the "tar -xf" command to extract the archive. The steps are shown below:

oracle@dbvlin101[/home/oracle/7.0]: unzip dbvisit-standby7.0.01_linux.zip
Archive:  dbvisit-standby7.0.01_linux.zip
  inflating: dbvisit-standby7.0.01.tar
  inflating: README.txt
  inflating: online_user_guide_reference.txt
oracle@dbvlin101[/home/oracle/7.0]: ls -l
total 109844
-rw-r--r-- 1 oracle oinstall 45089534 Aug 21 10:40 dbvisit-standby7.0.01_linux.zip
-rw-rw-rw- 1 oracle oinstall 67165696 Aug 19 18:10 dbvisit-standby7.0.01.tar
-rw-rw-rw- 1 oracle oinstall      393 Jul 10 23:21 online_user_guide_reference.txt
-rw-rw-rw- 1 oracle oinstall    87875 Aug 19 14:17 README.txt
oracle@dbvlin101[/home/oracle/7.0]: tar -xf dbvisit-standby7.0.01.tar
oracle@dbvlin101[/home/oracle/7.0]: ls -l
total 109848
drwxr-xr-x 6 oracle oinstall     4096 Aug 21 10:50 dbvisit
-rw-r--r-- 1 oracle oinstall 45089534 Aug 21 10:40 dbvisit-standby7.0.01_linux.zip
-rw-rw-rw- 1 oracle oinstall 67165696 Aug 19 18:10 dbvisit-standby7.0.01.tar
-rw-rw-rw- 1 oracle oinstall      393 Jul 10 23:21 online_user_guide_reference.txt
-rw-rw-rw- 1 oracle oinstall    87875 Aug 19 14:17 README.txt

Note that once the installation is finished you can remove this temporary directory.

Step 4: Running the Dbvisit Installer

The next step in the process is to start the Dbvisit Standby installer. Once you have extracted the tar archive, you will notice a new "dbvisit" directory.

In this directory you will find an "installer" directory which contains the installation script to be executed. Before executing this script you need to make it "executable". This can be done as follow:

oracle@dbvlin101[/home/oracle/7.0]: ls -l
total 109848
drwxr-xr-x 6 oracle oinstall     4096 Aug 21 10:50 dbvisit
-rw-r--r-- 1 oracle oinstall 45089534 Aug 21 10:40 dbvisit-standby7.0.01_linux.zip
-rw-rw-rw- 1 oracle oinstall 67165696 Aug 19 18:10 dbvisit-standby7.0.01.tar
-rw-rw-rw- 1 oracle oinstall      393 Jul 10 23:21 online_user_guide_reference.txt
-rw-rw-rw- 1 oracle oinstall    87875 Aug 19 14:17 README.txt
oracle@dbvlin101[/home/oracle/7.0]: cd dbvisit
oracle@dbvlin101[/home/oracle/7.0/dbvisit]: ls
dbvnet	dbvserver  installer  standby
oracle@dbvlin101[/home/oracle/7.0/dbvisit]: cd installer

oracle@dbvlin101[/home/oracle/7.0/dbvisit/installer]: ls  -l
total 2648
-rw-r--r-- 1 oracle oinstall 2707057 Aug 19 18:10 install-dbvisit

oracle@dbvlin101[/home/oracle/7.0/dbvisit/installer]: chmod u+x install-dbvisit
oracle@dbvlin101[/home/oracle/7.0/dbvisit/installer]: ls -l
total 2648
-rwxr--r-- 1 oracle oinstall 2707057 Aug 19 18:10 install-dbvisit

Now that the install-dbvisit script has the correct permissions, you may execute this script to start the installer.

Below is the detail output of the installation process performing an upgrade.

The example upgrade below is being performed on a Dbvisit Version 6 Installation that was located in /usr/local/dbvisit.

If you were updating an existing version 7 installation you can follow the same procedure.

The key is to make sure you select the correct Dbvisit Base directory where Dbvisit Standby was already installed.

In most cases just accepting the default values should be sufficient, but the key is to make sure you select the Dbvisit Base directory where Dbvisit Standby is already installed:

Start the installer using - ./install-dbvisit command
Provide the DBVISIT_BASE directory where Dbvisit Standby is already installed - /usr/local/dbvisit
Confirm the Oracle Database software owner name - oracle (default)
Specify the dbvnet port number - 7890 (default)
Specify the dbvnet password used for secure communication between nodes - admin (default)
Confirm if you want to auto start dbvnet after installation - yes (default)
Specify the Dbvserver (GUI) protocol (http or https) - https (default)
Confirm the default port number for Dbvserver (GUI) - 8443 (default for https)
Specify the Dbvserver administrator user name - admin (default)
Specify the Dbvserver administrator user password - admin (default)
Confirm if you want to auto start Dbvserver after installation - yes (default)
Do you want to allow error notification (bug tracking Dbvserver) - yes (default)
Confirm bug tracking email address (bug tracking Dbvserver) - bugtrack700@dbvisit.com (default)

Below is an example installation process. At the end of this process the Dbvnet and Dbvserver background processes will be started automatically.

oracle@dbvlin101[/home/oracle/7.0/dbvisit/installer]: ./install-dbvisit

-------------------------------------------------------------------------------
 Welcome. Your Dbvisit product is going to be installed in a moment.
 It will be required by you to enter some configuration parameters
 during installation.
-------------------------------------------------------------------------------

It is recommended to make a backup of our current Dbvisit software
 location for rollback purposes.

>>> INSTALLATION DIRECTORY

Please specify the Dbvisit main installation directory.

The default directory is "/usr/dbvisit".

Note: the various Dbvisit products and components - such as Standby,
 Replicate, Dbvnet, and Dbvserver - will be installed in the appropriate
 subdirectories of this path.

Enter a custom value or press ENTER to accept default [/usr/dbvisit]:
 > /usr/local/dbvisit

-------------------------------------------------------------------------------
 ABOUT TO CONFIGURE: DBVISIT STANDBY
-------------------------------------------------------------------------------

Dbvisit Standby is Dbvisit's disaster recovery software for your
 Oracle database.

>>> ORACLE USER NAME

Please specify the Oracle user name on this server.

The default user name is "oracle".

Note: you must be logged in as the Oracle user to run Dbvisit installer.

Custom value or ENTER for default [oracle]:
 > oracle

-------------------------------------------------------------------------------
 ABOUT TO CONFIGURE: DBVISIT DBVNET
-------------------------------------------------------------------------------

Dbvisit Dbvnet is Dbvisit's network transportation software which
 provides network connectivity for all Dbvisit products. Dbvnet is a
 persistent daemon software that must be running on both the primary
 and standby servers at all times.

>>> DBVNET PORT NUMBER

Please specify the listening port number for Dbvnet on this server.

The default port number used by Dbvnet is 7890. You may choose any
 value between 1024 and 65535.

Note: if you can not access this port after the installation has
 finished, then please double-check your server's firewall settings
 to ensure the selected port is open.

Custom value or ENTER for default [7890]:
 > 7890

>>> DBVNET PASSWORD

Please specify a password to encrypt all network data transmissions
 between servers in your network on which Dbvisit software is running.

The default password is "admin".

Custom value or ENTER for default [admin]:
 > admin

>>> DBVNET START AFTER INSTALLATION

Please specify whether or not Dbvnet should be started when the
 installer has finished.

The default setting is "yes".

Custom value or ENTER for default [yes]:
 > yes

-------------------------------------------------------------------------------

 ABOUT TO CONFIGURE: DBVISIT DBVSERVER
-------------------------------------------------------------------------------

Dbvisit Dbvserver is Dbvisit's web server software that provides a web
 interface for all Dbvisit products. Dbverver is a also a daemon that
 must be running on both servers if you wish to use its built-in
 command scheduler or control Dbvisit software through your web
 browser.

>>> DBVSERVER WEB PROTOCOL

Please specify the web protocol to be used by Dbvserver on this server.

Dbvserver supports both the HTTP and HTTPS web protocols. HTTP sends
 plain text messages across the network and should therefore be used
 on local networks only.

The default web protocol is "https".

If unsure, select HTTPS which safely encrypts all network transmissions.

Custom value or ENTER for default [https]:
 > https

>>> DBVSERVER PORT NUMBER

Please specify the listening port number for Dbvserver on this server.

The default port number used by Dbvserver is 8081 for HTTP and 8443
 for HTTPS. You may choose any value between 1024 and 65535.

Note: if you can not access this port after the installation has
 finished, then please double-check your server's firewall settings
 to ensure the selected port is open.

Custom value or ENTER for default [8443]:
 > 8443

>>> DBVSERVER USER

Please specify a user name to be used to access Dbvserver through
 your web browser later on.

Note: this is a virtual user name, i.e. there is no corresponding
 system user account required.

The default user name is "admin".

Custom value or ENTER for default [admin]:
 > admin

>>> DBVSERVER PASSWORD

Please specify a login password for the user name you just entered.

The default password is "admin".

Custom value or ENTER for default [admin]:
 > admin

>>> DBVSERVER START AFTER INSTALLATION

Please specify whether or not Dbvserver should be started when the
 installer has finished.

The default setting is "yes".

Custom value or ENTER for default [yes]:
 > yes

>>> AUTOMATIC ERROR NOTIFICATION

In order to improve both the Dbvisit web interface and the network
 transport layer, an automatic email can be sent to Dbvisit support
 when a run-time issue is detected by Dbvserver or Dbvnet.

Note: information pertaining to Dbvserver and Dbvnet is sent only,
 and the information is solely used to improve our software.

The default setting is "yes".

Custom value or ENTER for default [yes]:
 > yes

>>> AUTOMATIC ERROR EMAIL ADDRESS

What email address should be used to send automatic error notifications
 to? Usually, they are sent to a special Dbvisit error collection address.
 However, you may use your own support email address to receive error
 notifications first, and then forward them to Dbvisit support later in
 case there is a serious issue.

Note: the Dbvisit notification address below can not be used for support
 enquiries. Manual email sent to this address will be ignored. Please open
 a support ticket on the support desk (http://www.dbvisit.com/servicedesk)
 if you are facing any difficulties.

The default email address is "bugtrack700@dbvisit.com".

Custom value or ENTER for default [bugtrack700@dbvisit.com]:
 >

-------------------------------------------------------------------------------
 Thank you. Configuration is complete. Installation will commence now.
-------------------------------------------------------------------------------

>>> Installing Standby - the Dbvisit disaster recovery software...

Installing product files...
 Updating and migrating existing DDC files in /usr/local/dbvisit...


 > Removing old DDC files with appended timestamps
 Updating and migrating existing DDC files in
 /usr/local/dbvisit/standby...


 > Migrating DDC file /usr/local/dbvisit/standby/dbv_testdb.env to
 /usr/local/dbvisit/standby/conf/dbv_testdb.env


 > Renaming old DDC file /usr/local/dbvisit/standby/dbv_testdb.env to
 /usr/local/dbvisit/standby/conf/dbv_testdb.env.v6


 > Removing old DDC files with appended timestamps
 Removing old product files...

Dbvisit Standby installation complete.

>>> Installing Dbvnet - the Dbvisit network layer...

>>> Adjusting init script templates for product dbvnet...

Please find some init script templates in the following directory:

/usr/local/dbvisit/dbvnet/conf/init.d

These templates will allow your Systems Administrator to automatically
 start Dbvserver after a database server reboot.

Templates are available for Sun Solaris, IBM AIX, and the Linux flavours
 OpenSuSE, RedHat/Centos/Fedora & Debian/Ubuntu.

>>> Starting Dbvnet daemon, please wait...

Dbvnet is up and running on the following ip address and port:

niop://172.16.1.111:7890

>>> Installing Dbvserver - the Dbvisit web interface...

>>> Adjusting init script templates for product dbvserver...

Please find some init script templates in the following directory:

/usr/local/dbvisit/dbvserver/conf/init.d

These templates will allow your Systems Administrator to automatically
 start Dbvserver after a database server reboot.

Templates are available for Sun Solaris, IBM AIX, and the Linux flavours
 OpenSuSE, RedHat/Centos/Fedora & Debian/Ubuntu.

>>> Starting Dbvserver daemon, please wait...

Dbvserver is up and running. Please point your browser to the
 following URL to log in to the Dbvisit web interface:

https://172.16.1.111:8443
 Login user name is 'admin' (password 'admin')

>>> Dbvisit product and component installation is now complete.

>>> NEXT STEPS: CONFIGURE DBVISIT STANDBY VIA COMMAND LINE INTERFACE (CLI):

cd /usr/local/dbvisit/standby
 ./dbvisit_setup

Note: Dbvisit can also be configured and run through a (GUI) web browser.
 Dbvserver (dbvserverd) must be installed and started for this.

>>> IMPORTANT - PLEASE NOTE THE FOLLOWING REQUIREMENTS BEFORE CONTINUING:

> The Dbvisit Standby, Dbvnet, and Dbvserver software must be installed
 on both the primary and standby servers.
 > For network communication between the primary and standby server
 via Dbvnet port number 7890 must not be blocked by your firewalls.
 > Dbvnet must be up and running on both the primary and standby servers
 at all times.
 > If you wish to use Dbvserver, the Dbvisit web interface, then please
 ensure port 8443 is open on your servers' firewalls, as well.

>>> Thank you for using Dbvisit software!

One key area to review from the above output are these lines indicating an upgrade from version 6 to version 7.

...
...
>>> Installing Standby - the Dbvisit disaster recovery software...
    Installing product files...

    Updating and migrating existing DDC files in /usr/local/dbvisit...


    > Removing old DDC files with appended timestamps
    Updating and migrating existing DDC files in
    /usr/local/dbvisit/standby...


    > Migrating DDC file /usr/local/dbvisit/standby/dbv_testdb.env to
    /usr/local/dbvisit/standby/conf/dbv_testdb.env


    > Renaming old DDC file /usr/local/dbvisit/standby/dbv_testdb.env to
    /usr/local/dbvisit/standby/conf/dbv_testdb.env.v6


    > Removing old DDC files with appended timestamps
    Removing old product files...
 
..
..

Note regarding the upgrade of existing DDC files:

As you can see from the above the installation process picked up that there are version 6 Dbvisit Configuration files (DDC) located in /usr/local/dbvisit/standby/dbv_testdb.env
This file is then converted to a version 7 configuration (DDC) file and moved into the /usr/local/dbvisit/standby/conf/ directory.
The original version 6 configuration file is renamed to dbv_testdb.env.v6 and moved also moved to the /usr/local/dbvisit/standby/conf directory.
Once the installation and upgrade is complete you will end up with the following files in the /usr/local/dbvisit/standby/conf directory
Note that any old backup DDC files with date timestamps as extensions (dbv_SID.dbv.yyyymmdd) will be removed from the /usr/local/dbvisit/standby directory.

At this stage you should now have the Dbvisit Standby version 7 software installed and if you upgraded from version 5.0.x or 6.0.x your DDC files would have been upgraded as part of the installation process. If you selected to auto start Dbvnet (Dbvisit Networking) and Dbvserver (GUI) you will have a number of Background processes running. Below is example output listing these processes:

oracle@dbvlin101[/home/oracle]: ps -ef|grep dbvisit |grep -v grep
oracle    6410     1  0 Aug21 ?        00:00:01 /usr/dbvisit/dbvnet/dbvnetd
oracle    6411  6410  0 Aug21 ?        00:00:00 /usr/dbvisit/dbvnet/dbvnetd
oracle    6414  6410  0 Aug21 ?        00:00:00 /usr/dbvisit/dbvnet/dbvnetd
oracle    6415  6410  0 Aug21 ?        00:00:00 /usr/dbvisit/dbvnet/dbvnetd
oracle    6416  6410  0 Aug21 ?        00:00:00 /usr/dbvisit/dbvnet/dbvnetd
oracle    6431     1  0 Aug21 ?        00:00:01 /usr/dbvisit/dbvserver/dbvserverd
oracle    6432  6431  0 Aug21 ?        00:00:00 /usr/dbvisit/dbvserver/dbvserverd
oracle    6434  6431  0 Aug21 ?        00:00:01 /usr/dbvisit/dbvserver/dbvserverd
oracle    6436  6431  0 Aug21 ?        00:00:00 /usr/dbvisit/dbvserver/dbvserverd

Step 5: Repeat Installation on Standby Server

Dbvisit Standby needs to be installed on the Primary server as well as on the Standby server.

Before you continue with the next step you need to make sure you follow Step 1 to 4 above on all the servers in the standby configuration. When doing this, it is important to make sure the Dbvnet password provided during installation is the same on all the servers where you are installing Dbvnet. This password is used for secure communication and if different passwords are used between the primary and standby servers, you will not be able to establish a connection between these servers using Dbvnet.

Step 6: Testing Dbvnet Communication

Once you have Dbvisit Standby installed on all the servers, it is important to make sure that the communication between the Primary and Standby servers are working. This can be done by making use of the Dbvnet Test utility provided with the Dbvisit Standby installation - dbvnet-test, which is located under the dbvnet sub directory. When using the default path this utility will be in /usr/dbvisit/dbvnet/dbvnet-test

To test communication between the primary and standby servers you can run the following recommended test commands:

To perform a basic status check which confirms that the primary and standby server can communicate using Dbvnet:
- dbvnet-test [-s|--status] SERVER[:PORT]
To perform a more detail check, testing network connectivity, you can run the following:
- dbvnet-test [-f|--fulltest] TMPDIR SERVER:PORT

For more detail on Dbvnet and troubleshooting please see - Dbvisit Standby Networking (Dbvnet and SSH)

In the example below, dbvlin101 is the primary server and dbvlin102 is the standby server. Dbvisit Standby was installed using default values and no additional configuration has been performed at this stage. Dbvnet and Dbvserver is running on both nodes, but only Dbvnet is required and used for these tests:

Test 1: Basic Status Check

oracle@dbvlin101[/usr/dbvisit/dbvnet]: ./dbvnet-test -s dbvlin102:7890

>>> Determining Dbvnet status on server dbvlin102:7890...


    Dbvnet on server dbvlin102:7890 is running.

Test 2: Full Test - 10MB file is copied (and verified) between primary and standby

oracle@dbvlin101[/usr/dbvisit/dbvnet]: ./dbvnet-test -f /tmp dbvlin102:7890
 
>>> Determining Dbvnet status on server dbvlin102:7890...
    Dbvnet on server dbvlin102:7890 is running.
 
>>> Running file transfer round trip on server dbvlin102:7890...
    Creating file '/tmp/dbvnet-test.tmp' containing 10 MB of data... - done.
 
  > Transferring 'dbvnet-test.tmp' to server dbvlin102:7890
    Progress: 0%...20%...40%...60%...80%...100% [11046 KB/s] - done.
 
  > Retrieving file "dbvnet-test.tmp" from server dbvlin102:7890
    Progress: 0%...20%...40%...60%...80%...100% [11209 KB/s] - done.
    Comparing checksums: all three checksums (local/remote/local) are
    identical. File transfer round trip finished successfully.

Stop and Start Dbvnet

Dbvnet can be stopped and started using the dbvnetd executable located in the dbvnet sub directory (example - /usr/dbvisit/dbvnet). Below is an example of stopping and starting the Dbvnet background processes:

oracle@dbvlin101[/usr/dbvisit/dbvnet]: ./dbvnetd stop
oracle@dbvlin101[/usr/dbvisit/dbvnet]: ps -ef|grep dbvnet
oracle   12641 12446  0 09:20 pts/1    00:00:00 grep dbvnet
oracle@dbvlin101[/usr/dbvisit/dbvnet]: ./dbvnetd start
oracle@dbvlin101[/usr/dbvisit/dbvnet]: ps -ef|grep dbvnet
oracle   12643     1  0 09:20 pts/1    00:00:00 ./dbvnetd start
oracle   12644 12643  0 09:20 pts/1    00:00:00 ./dbvnetd start
oracle   12645 12643  0 09:20 pts/1    00:00:00 ./dbvnetd start
oracle   12646 12643  0 09:20 pts/1    00:00:00 ./dbvnetd start
oracle   12647 12643  0 09:20 pts/1    00:00:00 ./dbvnetd start
oracle   12649 12446  0 09:20 pts/1    00:00:00 grep dbvnet

You should run the above tests from both the primary and standby servers to ensure communication between primary and standby servers can be established. Once this is done you can continue to the next step which is the creation of a Dbvisit Standby Database Configuration (DDC) file.

Step 7: Accessing the GUI (Dbvserver)

If you selected to install the Dbvserver (GUI) and allowed the auto start option during the installation process you should now be able to connect to the web based GUI interface.

To access this interface you can use http or https and the specified port you specified during installation. The default is https with port 8443 and you should be able to connect to the web based frontend using the following url: https://yourservername:8443

Example below is connecting to the GUI on dbvlin101 (172.16.1.111) using https and port 8443.

When asked for a username and password you need to provide the username and password specified during installation.

If you followed the above steps you should now have Dbvisit Standby installed on both your primary and standby servers.

Step 8: Updating the Dbvisit Standby Repository and Dbvisit Configuration files

When upgrading the Dbvisit Standby version from 5.3.x or 6.0.x to version 7 you will only need to update the Dbvisit Standby Repository, but not the Dbvisit Database Configuration (DDC) files, as they would have been upgrade as part of the software installation (upgrade) process.

If you are upgrading an existing version 7.0.x installation, you only need to update the Dbvisit Standby Repository. The DDC file would have been already converted to a version 7 DDC file and no steps will be required - unless explicitly mentioned in the update release notes.

Step 8.1 - Updating the Dbvisit Database Configuration (DDC) file - (Optional)

This step is optional if you want to edit parameters as part of the upgrade - otherwise this step, if already on a version 7.0.x release is not needed

This step can either be performed from the Command Line Interface (CLI) - indicated by , or the Web based (GUI) interface - indicated by _. Both options are shown below:

Using the GUI to update the DDC file

Start browser and specify the URL given. Note the port number.

The Dbvisit Standby login screen will be displayed. The default username/password is admin/admin.

To update the Dbvisit Database Configuration (DDC) file go to Home > Setup > Update Dbvisit > Update Configuration > select Database from drop-down menu and click Save Configuration.

Using CLI to update DDC

To update the DDC file from the command line use option 6 from the dbvisit_setup menu and follow the onscreen instructions.

Below is an example:

oracle@dbvlin101[/usr/local/dbvisit/standby]: ./dbvisit_setup


=========================================================

Dbvisit Standby Database Technology (7.0.01.11204)
 http://www.dbvisit.com

=========================================================

=>dbvisit_setup only needs to be run on the primary server.

Is this the primary server? <Yes/No> [Yes]:
=========================================================


 Dbvisit Standby Database Technology (7.0.01.11204)
 http://www.dbvisit.com

 Dbvisit Database setup
 Default values will be shown in []

Options:
 1) New Dbvisit Database setup (combines options 2,3,4)
 1a) New Dbvisit RAC Instance setup (combines options 2,3,4)

 2) New Dbvisit Database configuration (DDC) file setup
 3) New Dbvisit Archive Management Module (AMM) setup
 4) New Dbvisit Database repository (DDR) setup

 5) Manage Dbvisit Database repository (DDR)
 6) Update Dbvisit Database configuration (DDC) file

 7) Create Standby Database (and template)
 8) Synchronize Standby Database

 9) Uninstall Dbvisit Database repository (DDR)
 E) Exit

=========================================================
Please enter choice : 6

------------------------------------------------------------------------------
=>Updating Dbvisit Database configuration (DDC) file.
Choose database:

The following Oracle database(s) have a Dbvisit Database configuration (DDC)
file on this server:

DDC
===
1) testdb
2) Return to menu

Please enter choice : 1

Is this correct? <Yes/No> [Yes]:

------------------------------------------------------------------------------
Would you like to review all the variables? <Yes/No> [Yes]:

=====10 Generic Settings=====
1) COMPRESS=dbvisit
2) CP=/usr/bin/scp
3) DBVNET_PORT=7890
4) ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
5) ORACLE_SID=testdb
6) ORATAB=/etc/oratab
7) OWNER=oracle
8) PATH=/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/usr/sbin:/sbin
9) RSH=/usr/bin/ssh
10) SEND_HEARTBEAT_TIME24=0700
11) UNCOMPRESS=dbvisit
12) ZIP_EXTENSION=.gz

=====15 RAC Settings=====
13) RAC=No
14) RAC_TAKEOVER=Yes
15) RAC_TAKEOVER_FORCE=No
16) RAC_TAKEOVER_SID=

=====20 Primary Server Settings=====
17) DBPASSWD=******

18) DBUSER=dbvisit
19) DBVISIT_BASE=/usr/local/dbvisit
20) ENCRYPT_PASSWDS=No
21) LEAVE_COMPRESS_SOURCE=No
22) LOGSWITCH=N
23) ORACLE_SID_ASM=+ASM
24) SOURCE=dbvlin101
25) SYNCH_DBVISIT_INSTALL=Yes

=====25 Sys Logon Settings=====
26) SYS_LOGON=
27) SYS_LOGON_STRING=
28) SYS_USER=
29) _SYS_PASSWD=

=====30 Standby Server Settings=====
30) ARCHDEST=/u01/app/oracle/archive/testdb
31) DBVISIT_BASE_DR=/usr/local/dbvisit
32) DESTINATION=dbvlin102
33) LEAVE_COMPRESS_DEST=N
34) MAX_TIMES_TRIED=4

=====30 Standby Server Settings=====

35) ORACLE_HOME_DR=/u01/app/oracle/product/11.2.0/dbhome_1
36) ORACLE_SID_ASM_DEST=+ASM
37) ORACLE_SID_DEST=testdb
38) SSH_PORT=22

=====40 Mail Settings=====
39) ADMINS=oracle@dbvlin101
40) MAILCFG_FROM=oracle@dbvlin101
41) MAILCFG_FROM_DR=oracle@dbvlin102
42) MAILCFG_MAIL_CLIENT=sendmail
43) MAILCFG_SMTP_SERVER=
44) MAILCFG_SMTP_SERVER_DR=
45) SUCCESSMAIL=No
46) SUCCESSMAIL_DR=No

=====50 Primary Archive Log Management Settings=====
47) ARCHSOURCE_BACKUP_COUNT=0
48) ARCHSOURCE_MANAGEMENT=Yes
49) DAYS_TO_KEEP_ARCHSOURCE=2
50) DELETE_ARCHSOURCE=Y
51) FRA_THRESHOLD_ARCHSOURCE=90

=====50 Primary Archive Log Management Settings=====
52) NUM_ARCHSOURCE_TO_KEEP=0
53) THRESHOLD_ARCHSOURCE=90

=====60 Standby Archive Log Management Settings=====
54) ARCHDEST_MANAGEMENT=Yes
55) DAYS_TO_KEEP_ARCHDEST=2
56) DELETE_ARCHDEST=Y
57) NUM_ARCHDEST_TO_KEEP=0
58) THRESHOLD_ARCHDEST=90

Are these variables correct? <Yes/No> [Yes]: Yes

Redisplay all variables again? <Yes/No> [No]: No

------------------------------------------------------------------------------


=>Writing Dbvisit Database configuration (DDC) file.
Dbvisit Database configuration (DDC) file
/usr/local/dbvisit/standby/conf/dbv_testdb.env already exists. Are you sure you
want to override? (a backup copy will be make) <Yes/No> [Yes]:

=>Dbvisit Database configuration (DDC) file
/usr/local/dbvisit/standby/conf/dbv_testdb.env renamed up to:
/usr/local/dbvisit/standby/conf/dbv_testdb.env.201308221525.

=>Dbvisit Database configuration (DDC) file
/usr/local/dbvisit/standby/conf/dbv_testdb.env updated.
Please press <Enter> to continue...

Following the above steps the current DDC file will be upgraded.

Step 8.2 - Updating the Dbvisit Standby Repository

Oracle RAC Configurations - You only need to perform this step on one of the primary nodes.

Single Instance Configuration - This step is only performed on the primary server

Using the GUI to update the Dbvisit Standby Repository

To update the Dbvisit Database Repository (DDR) file go to Home > Setup > Update Dbvisit > Manage Dbvisit Repository > select Database from drop-down menu and click Check Dbvisit Repository.

If the DDR needs to be upgraded, select Upgrade Dbvisit Repository
Repeat upgrade of DDC and DDR for all databases on this primary server.

Using CLI to update Dbvisit Standby Repository

To update the Dbvisit Standby Repository from the command line interface run the dbvisit_setup menu option and select option 5.
The first step is to run a check if the repository does require an update. If it does, select the upgrade option, otherwise select "r" to return to the menu.
Below is an example showing you how to check if the Dbvisit Standby Repository require an update.

oracle@dbvrlin301[/usr/dbvisit/standby]: ./dbvisit_setup


=========================================================

Dbvisit Standby Database Technology (7.0.01.11204)
 http://www.dbvisit.com

=========================================================

=>dbvisit_setup only needs to be run on the primary server.

  Is this the primary server? <Yes/No> [Yes]:
=========================================================
 Dbvisit Standby Database Technology (7.0.01.11204)
 http://www.dbvisit.com

 Dbvisit Database setup
 Default values will be shown in []

Options:
 1) New Dbvisit Database setup (combines options 2,3,4)
 1a) New Dbvisit RAC Instance setup (combines options 2,3,4)

 2) New Dbvisit Database configuration (DDC) file setup
 3) New Dbvisit Archive Management Module (AMM) setup
 4) New Dbvisit Database repository (DDR) setup

 5) Manage Dbvisit Database repository (DDR)
 6) Update Dbvisit Database configuration (DDC) file

 7) Create Standby Database (and template)
 8) Synchronize Standby Database

 9) Uninstall Dbvisit Database repository (DDR)
 E) Exit

=========================================================
Please enter choice : 5
=========================================================

Maintain Dbvisit Database repository (DDR)
 Default values will be shown in []

Options:
 1) Upgrade Dbvisit Database repository (DDR)
 2) Downgrade Dbvisit Database repository (DDR)
 3) Check version of Dbvisit Database repository (DDR)

 r) Return to main menu

=========================================================
Please enter choice : 3

------------------------------------------------------------------------------
=>Checking Dbvisit Database repository (DDR) version.

Choose database:

The following Oracle database(s) have a Dbvisit Database configuration (DDC)
file on this server:

DDC
 ===
1) TSTRAC1
2) Return to menu

Please enter choice : 1

Is this correct? <Yes/No> [Yes]: Yes
Database TSTRAC1 is up.

Dbvisit Database repository (DDR) version: 7.0
Dbvisit software version: 7.0


Dbvisit Database repository (DDR) up to date. No need to upgrade.

Please press <Enter> to continue...

=========================================================

Maintain Dbvisit Database repository (DDR)
 Default values will be shown in []

Options:
 1) Upgrade Dbvisit Database repository (DDR)
 2) Downgrade Dbvisit Database repository (DDR)
 3) Check version of Dbvisit Database repository (DDR)

 r) Return to main menu

=========================================================
Please enter choice :

Step 9: Completing the upgrade

The last step in the upgrade process is to run Dbvisit Standby manually on the primary. If using Oracle RAC you should run Dbvisit Standby on ALL the primary nodes; once Dbvisit Standby has been run on the primary server, run it on the standby server. This step can be performed from either the command line or the GUI.

Through the command line interface (CLI):

To run Dbvisit Standby from the command line, execute the following command first on the primary node followed by the running it on the standby server: ./dbvisit <DDC>

Through the web based graphical user interface (GUI):

To execute Dbvisit (run it) from the GUI on the primary server, login as the admin user (default) and navigate to the “Run Interactive” screen:

Select Home -> Run -> Run Interactive
Ensure you are on the primary tab, if not select it
From the top drop down option, select the database
Select “Default (transfer archive log) option as your “Run Action”
Click on Run

To execute Dbvisit (run it) from the GUI on the standby server, login as the admin user (default) and navigate to the “Run Interactive” screen:

Select Home -> Run -> Run Interactive
Ensure you are on the standby tab, if not select it
From the top drop down option, select the database
Select “Default (apply archive log) option as your “Run Action”

Once you have completed a successful run from both the primary and standby side, you can now move on to the final step, which is to re-enable your schedules.

Step 10: Restarting your Schedules

Once you have completed the upgrade and you can run Dbvisit Standby successfully manually, you can re-enable your Dbvisit Standby schedules disabled in Step 1.

Step 11: Clean up the temporary files (the downloaded install files)

If you extracted the installer into a temporary location, example /home/oracle/7.0, you can now remove this as it is no longer required.

User Guide Dbvisit Standby 7.0

Upgrading Dbvisit Standby - Linux/Unix