Initial Dbvisit Standby Configuration

In this section we will cover the creation of a new Dbvisit Standby Configuration, also known as creating a Dbvisit Database Configuration (DDC) file.

Once you have done a clean installation of Dbvisit Standby, the first step is to create a configuration file or DDC, which will contain information about your environment as well as your Primary and Standby database settings. 

For each Primary and Standby database pair there will be one DDC file.  The file is created and maintained from the Primary server.  The DDC file on the standby server is a mirrored copy of the one on the primary server and any changes to this file will be overwritten. 

 

Important

DDC files should be created on the primary nodes (One DDC file per RAC node if RAC is used) - this is where the master copy of the DDC files are located and maintained.  

A copy of the DDC file will be transferred and maintained on the standby server by Dbvisit Standby.  

You should not manually create or modify the DDC file on the standby server.  

All DDC creation and changes should be made from the primary servers.

 

The default location of the DDC file is in the “conf” directory located under the “standby” sub directory. 

If your Dbvisit Base directory is /usr/dbvisit, then you will find the DDC files in the /usr/dbvisit/standby/conf directory. 

The DDC files have the following format:  dbv_<DDC>.env, where DDC is in most cases the ORACLE_SID of your database, but this value can be different. 

Example names:

  • dbv_testdb.env               : testdb is a single instance database environment
  • dbv_PROD1.env             : PROD1 is the 1st instance in a 2 node RAC environment
  • dbv_PROD2.env             : PROD2 is the 2nd instance in a 2 node RAC environment

The DDC file can be created from either the CLI or the GUI, but it should be done from the primary server.  If you are using Oracle RAC  you have to follow the same steps on all the Nodes in the Oracle RAC configuration.

This section will cover the creation of the DDC file via the Command Line and via the GUI below.

Information Regarding Oracle RAC configurations

When installing Dbvisit Standby on Oracle RAC environments, please review this section, if you are using Single instance configurations please continue with the next section below.

For Oracle RAC installations please see - Configure Oracle RAC Primary with Oracle RAC Standby 

 

Important - if RAC is used

Note: For Oracle RAC environments you will need to create a DDC file on all nodes.  To do this you have to run the setup on all the RAC nodes.

During the configuration you will be asked if it is the 1st node you are configuring, state yes, that will then ensure the Repository is created as part of the first node setup.

When creating the second node's DDC file, you can specify No to this question as the repository would have been already created from node 1.

If the standby is RAC, we can only create a single instance (multithread) db with our process. Once CSD (create standby database) successfully completes, you will have to convert the standby to RAC manually.

 

When installing Dbvisit Standby on Oracle RAC on a UNIX based environment we recommend that you add an entry into each nodes /etc/oratab file for the corresponding instance.  

Example if the Oracle RAC database is called DEV and you have instance DEV1 running on node 1 and instance DEV2 running on node 2 then you can add an entry for DEV1 into Node one /etc/oratab file and and entry for DEV2 into the /etc/oratab file of Node 2.

Example (the example below is showing for a RAC database called DEV using Oracle 11.2)

 

Node 1:

+ASM1:/u01/app/11.2.0/grid:N
DEV:/u01/app/oracle/product/11.2.0/db_1:N           
DEV1:/u01/app/oracle/product/11.2.0/db_1:N 

 

Node 2:

+ASM2:/u01/app/11.2.0/grid:N
DEV:/u01/app/oracle/product/11.2.0/db_1:N           
DEV2:/u01/app/oracle/product/11.2.0/db_1:N 

 

Standby Node, assuming it is single instance and you are calling the standby database DEV (same as primary), the standby /etc/oratab file might look like this:

+ASM:/u01/app/11.2.0/grid:N
DEV:/u01/app/oracle/product/11.2.0/db_1:N           

 

Now when running the Dbvisit Setup you will get a question (if using command line) similar to the following, which will show you the Instance entry.  Select 1 "DEV1" and continue with the setup.  You should then end up with a DDC file named "dbv_DEV1.env".

 

....
=>ORATAB
Dbvisit can use the oratab file to find all the databases on this server.
If you would like Dbvisit to do this, please enter the location of the oratab file.
Specifying the oratab file is not mandatory.

Oratab file is [/etc/oratab]:
=>Oratab will be: /etc/oratab

Is this correct? <Yes/No> [Yes]:
The following Oracle instance(s) have been found on this server:

    SID      ORACLE_HOME
    ===      ===========
1)  DEV1     /u01/app/oracle/product/11.2.0/db_1
2)  DEV      /u01/app/oracle/product/11.2.0/db_1
3)  Enter own ORACLE_SID and ORACLE_HOME

Please enter choice : 1
....

 

The end result will be that you end up with two DDC files, on node 1 you will have a DDC file for instance 1 (dbv_DEV1.env) and for node 2 you will have a DDC file for instance 2 (dbv_DEV2.env).  Both of them will have the standby database name as the same, in this case DEV (same as the primary).  

Creating the DDC from the Command Line  (Single and RAC Configurations)

To create a Dbvisit Database Configuration (DDC) file from the command line you need to run the “dbvisit_setup” command. 

From the menu, select option 1 for Single Instance environments and if you are creating a DDC file for an Oracle RAC environment, you have to specify option 1a

Once you have selected this option, follow the onscreen prompts and provide the information requested.

Note: If not using ASM for database storage, accept the default value of +ASM when asked for ASM details.  Dbvisit Standby will automatically pick up ASM is not used and will ignore this value.

Below is an example of starting the DDC file creation:

 

oracle@dbvlin501[/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]: 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 : 1  <--- Select option 1 to start creation of new DDC file

 

Once you have specified option 1 follow the onscreen instructions, if using RAC, you must specify option 1a 

The following questions will be asked (summary below)

  • License Agreement
  • Do you want the quick setup (recommended)
  • Confirm PATH variable
  • Confirm /etc/oratab location
  • Select Database to be configured in a standby configuration
  • Confirm operating system account – oracle
  • Confirm Dbvnet port to be used (7890)
  • Specify if compression should be used
  • Confirm server name
  • Confirm repository user (dbvisit7) and password
  • Provide ASM SID if used (+ASM if using Single instance and +ASM1 or +ASM2 etc if using RAC - specify the ASM instance that is running on this server)
  • Provide standby server name
  • Provide name for standby database
  • Confirm software Dbvisit Base directory on standby server
  • Specify the Dbvisit ARCHDEST location

    Please note that the Dbvisit Standby ARCHDEST location must exist on both primary (if using RAC - on all primary nodes) and standby server. It must be located on normal filesystem, not ASM. This location is not the same as the Oracle Database archive destinations, but is specific to Dbvisit Standby.

    The Dbvisit Standby ARCHDEST should not be located in the primary or standby database FRA (Fast/Flash Recovery Area).

    It is also important to make sure that you do not have the Dbvisit ARCHDEST set to the same as what you database archive log destination is. The ARCHDEST is specific to Dbvisit Standby and is not the same as the Oracle database archive log destinations.

    The Dbvisit Standby ARCHDEST can not be specified as an ASM location.

  • Provide ASM SID for standby server, if used (+ASM for single instance environments, but if the standby is located on a RAC environment make sure to specify the RAC ASM instance on that node, example +ASM1 or +ASM2 etc.)
  • Provide email settings for email notifications
  • Confirm if the Archivelog Management Module (AMM) should be used on primary and standby
  • Review settings and provide a name for your DDC (ORACLE_SID in most cases)
  • DDC file is created in ../dbvisit/standby/conf/
  • The Dbvisit Repository is created in the primary database

 

The next step following the creation of the DDC file is to create a standby database, or if one already exists, run Dbvisit Standby as normal, first from the primary (which will then copy the DDC file to the standby location), followed by running it on the standby server.

When using RAC

Important: For Oracle RAC environments, repeat the above step on all the nodes, and make sure you select option 1a from the menu.

The DDC file that will be created have the following format:  dbv_<DDC>.env, where DDC is in most cases the ORACLE_SID of your database instance on the node where the DDC is configured (but this value can be different if you want to name it something else, but using the SID name is recommended)

Examples:

When configuring a RAC setup, you will run the setup and select option 1a follow the onscreen instructions. In an Oracle RAC setup where the database is named PROD with instance PROD1 and PROD2 on the two nodes, you should end up with a DDC file per node as follow:

  • dbv_PROD1.env             : PROD1 is the 1st instance running on node 1 of a 2 node RAC environment
  • dbv_PROD2.env             : PROD2 is the 2nd instance running on node 2 of a 2 node RAC environment

 

 

Creating the DDC from the GUI

To create the Dbvisit Database Configuration file from the GUI interface you need to login to the web-based interface as the admin (default) user. 

Once logged in select the “SETUP” button from the main screen. 

 You will then enter the Dbvisit Setup menu as seen below:

 

Once you have entered the "New Dbvisit Setup" section, you will be displayed with the screen blow.  From this screen select the database you would like to configure Dbvisit Standby for (Create a DDC file for).

  1. Dbvisit Standby will attempt to identify the databases running on the server.  On Unix it will look for the Oracle "oratab" file, which should indicate all databases configured on the server and on Windows based systems, the information will be obtained from the Windows registry.

    It is important that for Oracle RAC environments you have an entry in the "oratab" file for the instance running on this server.  Example, if the primary RAC database is called PROD and instance PROD1 is running on this node that you have an entry for PROD1 in the "oratab" file.  On the second node, you will then have PROD2 in the oratab file.  Make sure in the Dbvisit Configuration, that you select the name for the instance running on that node, example on node 1 select PROD1 and node 2 select PROD2.

  2. You do not have to specify the Oracle SID.  This is optional and will be obtained from the "oratab" file or "registry" if Windows is used.  If your database is not listed in step 1 (drop down list), but is running, you can then manually add the Oracle SID.
  3. The Oracle Home will be obtained automatically and does not require andy value.   But if the database was not listed in step 1 (drop down list), then you should specify the Oracle Home used for this database.
  4. This field will show the location of the /etc/oratab and in most cases does not require any changes.

Once you have selected the database in the step 1 above, a question will be asked confirming this is the primary server, confirm with Yes and then click continue.

Click on Yes to confirm this is the primary.

You have to run the New Setup on the primary server only. (If you are using Oracle RAC, you need to run this configuration on ALL the RAC nodes)

 

You will now be presented with the Main screen for a new Setup from where you will have to follow 7 steps (TABS) to complete the new configuration (creation of a DDC file)

 

STEP 1: Primary Server

This screen will take you through 7 tabs to create the Dbvisit Standby Database Configuration file.  

Similar questions as mentioned for the CLI, will be asked as you move through these “tabs”. 

Once you have completed all the information required in these 7 tabs, the DDC file as well as Dbvisit Database Repository (DDR) will be created.


 

  1. Specify the Dbvisit Standby Configuration (DDC) name.  We recommend using the Database Name, and if using RAC use the INSTANCE Name from the server where you are running this configuration.  Example, if you are running the configuration on Node 1 in a RAC configuration for RAC database PROD and on this node the database Instance name is PROD1, then we recommend you use PROD1 as the DDC name.  In the above example the DDC name is called the same as the database "proddb" (single instance on this server).
  2. Specify the ASM Instance name on this server.  If ASM is not used, ignore this field and leave the default value of +ASM.  If you are using ASM, specify the ASM instance name running on this server.  Example if this is a single instance environment (Non RAC), then the default ASM instance name will be +ASM.  But if you are using RAC, the ASM instance name will be for example +ASM1 on node 1 and +ASM2 on node to.  
  3. Specify the Dbvnet Port.  The default port number 7890 is recommended.  You need to make sure this port is open and not blocked by firewalls on the primary and standby servers.
  4. Dbvisit Standby is making use of a small database repository.  The default schema (database username) is "dbvisit7"
  5. Specify the password for the repository owner (dbvisit7)
  6. Specify if the password should be encrypted in the DDC file or not.  Default recommended value is Yes.
  7. Click on Next to continue.

 

STEP 2: Standby Server


Please note that the Dbvisit Standby ARCHDEST location must exist on both primary and standby server. It must be located on normal filesystem, not ASM. This location is not the same as the Database archive destinations, but is specific to Dbvisit Standby.

  1. Specify the Standby Database Server Name
  2. Specify the DBVISIT_BASE location on the Standby Server (It is recommended that this location be the same on the Primary and Standby Server)
  3. Specify SSH Port (Not Required)  The SSH Port is ignored on Windows Based systems.  On Linux SSH can still be used, only if the DBVNET_PORT is not specified.  The recommended option is to ignore this value (leave it at 22) and make use of Dbvnet.
  4. Specify the Oracle SID for the Standby Database.  It is recommended to make use of the same name as what the primary database is called.  Example if your primary database is called PROD, then you can call the Standby database PROD as well.  In the above example the primary database is called "proddb" and the standby  Oracle SID is specified the same - proddb.
  5. The Oracle Home value is optional.  It is recommended that you add the standby database to the "oratab" file if configured on Unix.
  6. Specify the ASM Instance name on the Standby server.  Ignore this value if you are not using ASM.  
  7. IMPORTANT.  This parameter must be set and this directory must exist on both the primary node(s) and the standby node.  This location is used by Dbvisit Standby to store archive logs on the standby server from where they are applied to the Standby database.  Note that this location is not the same as the Oracle Database archive destination (FRA/ Recovery Area).  This location is also referred to as the Dbvisit Standby ARCHDEST.

 

STEP 3: RAC

  1. Specify if this is a RAC configuration (in the above example I am using a Single Instance - Non RAC configuration.  If this was Oracle RAC, then specify "yes"
  2. Specify if this is the 1st RAC node in the configuration.  This is required as Dbvisit Standby will create a repository and will only do this from the 1st RAC node.
  3. To enable RAC Takeover (recommended), specify Yes.  This RAC node can take over the Dbvisit Processing of another node if that other node is down (unavailable)
  4. Specify if RAC Takeover should be forced, meaning this node will process the other RAC Node's archive logs (always), even if it is available. 
  5. Specify the other RAC instance for which you want to take over processing (if that node is down, or if RAC Takeover Force is specified)
  6. Click on next to continue to the next Step (TAB).

 

STEP 4:  MAIL

 

STEP 5:  Primary AMM (Dbvisit Standby Archive Log Management Module)

 

STEP 6:  Standby AMM (Dbvisit Standby Archive Log Management Module)

 

STEP 7:  Finish 

  1. You can now move on to either create the standby database if it does not exist, or you can run Dbvisit Standby as normal if a standby database is already in place.

 

 

Important - if RAC is used

Note: For Oracle RAC environments you will need to perform this step on all nodes.  Just make sure you create the repository only from one of the Nodes. 

Under the RAC Tab, make sure you only specify “yes” to the question “Please specify if this is the first RAC node in the Dbvisit Standby configuration or not.”

On the first node where you run the configuration.  On all other RAC nodes make sure this value is set to “No”.