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:
- Install a new Dbvisit Database Repository
- Upgrade Dbvisit Database repository
- Downgrade Dbvisit Database repository
- 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
Option Description --ddc Specify 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 =============================================================