/
Managing DDR using Batch Mode

Managing DDR using Batch Mode

Jan 16, 2015

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 

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