Creating the DDC from the Command Line

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 enviornment, you have to specify option 1a. Once you have selected this option, follow the onscreen prompts and provide the information requested.

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
=========================================================

Select option 1 to start creation of new DDC file:

Please enter choice : 1

Once you have specified option 1 follow the onscreen instructions.

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)

• Provide standby server name

• Provide name for standby database

• Confirm software Dbvisit Base directory on standby server

• Specify the Dbvisit ARCHDEST location

• Provide ASM SID for standby server, if used (+ASM)

• 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.