Managing DDR using Batch Mode

Owned by Ankit Arora (Unlicensed)
Last updated: Jan 16, 2015
3 min read

This section will provide an overview on how you can perform batch processing options to manage Dbvisit Database Repository (DDR). You can perform the following operations for specific database:

  1. Install a new Dbvisit Database Repository 
  2. Upgrade Dbvisit Database repository 
  3. Downgrade Dbvisit Database repository 
  4. Uninstall Dbvisit Database repository

 

Important

  • Batch command only performed on the primary server.
  • Need to provide the DDC file for which you want to run the batch process. 

 

In this Example:

  • Dbvisit Standby version used: 7.0.32
  • Operating System - Oracle Linux 5.8
  • Primary Server: dbvrlin803
  • DDC Name: testdb

On Primary Server:

  • Install New Dbvisit Database Repository 

    • Make sure No previous repository exists on database. If exists the please uninstall it before proceeding.
    • You will need to apply the license, once repository is created
    OptionDescription
    --ddcSpecify the DDC file to install repository, in this case testdb DDC file is specified
    --def_tbs
    		Specify the default tablespace to install repository, in this case USERS is specified
    --tmp_tbs
    		Specify the temp tablespace to install repository, in this case TEMP is specified
    oracle@dbvlin803[/usr/dbvisit/standby]: ./dbvisit_setup --ddr --action install --ddc testdb --def_tbs USERS  --tmp_tbs TEMP
=============================================================
dbvisit_setup started in BATCH mode at 20150116 16:14
csd            =
ddc            = testdb
restart        =
template       =
output_dir     =
web            =
ddr            = 1
INTERFACE_MODE = BATCH
=============================================================
./dbvisit_setup --ddr --action install --ddc testdb --def_tbs USERS --tmp_tbs TEMP

User dbvisit7 created.

Grants to user dbvisit7 completed.

Dbvisit Database repository (DDR) for dbvisit7 created.
=============================================================
dbvisit_setup completed in BATCH mode at 20150116 16:14
=============================================================

  • Upgrade Dbvisit Database repository

    oracle@dbvlin803[/usr/dbvisit/standby]: ./dbvisit_setup --ddr --action upgrade --ddc testdb
=============================================================
dbvisit_setup started in BATCH mode at 20150116 16:24
csd            =
ddc            = testdb
restart        =
template       =
output_dir     =
web            =
ddr            = 1
INTERFACE_MODE = BATCH
=============================================================
./dbvisit_setup --ddr --action upgrade --ddc testdb

Dbvisit Database repository (DDR) version: 7.0

Dbvisit software version: 7.1
=============================================================
dbvisit_setup completed in BATCH mode at 20150116 16:24
=============================================================

  • Downgrade Dbvisit Database repository 

    oracle@dbvlin803[/usr/dbvisit/standby]: ./dbvisit_setup --ddr --action downgrade --ddc testdb
=============================================================
dbvisit_setup started in BATCH mode at 20150116 16:25
csd            =
ddc            = testdb
restart        =
template       =
output_dir     =
web            =
ddr            = 1
INTERFACE_MODE = BATCH
=============================================================
./dbvisit_setup --ddr --action downgrade --ddc testdb

Dbvisit Database repository (DDR) version: 7.1

Dbvisit software version: 7.0
=============================================================
dbvisit_setup completed in BATCH mode at 20150116 16:25
=============================================================

  • Uninstall Dbvisit Database Repository

    oracle@dbvlin803[/usr/dbvisit/standby]: ./dbvisit_setup --ddr --action uninstall --ddc testdb
=============================================================
dbvisit_setup started in BATCH mode at 20150116 16:13
csd            =
ddc            = testdb
restart        =
template       =
output_dir     =
web            =
ddr            = 1
INTERFACE_MODE = BATCH
=============================================================
./dbvisit_setup --ddr --action uninstall --ddc testdb

Dropping user dbvisit7... this may take a while

User dbvisit7 dropped.
=============================================================
dbvisit_setup completed in BATCH mode at 20150116 16:13
=============================================================