Step 3 - Create Standby Database
If a standby database is already created, then this step can be ignored. Dbvisit Standby can work with existing standby databases. Dbvisit Standby will automatically register the existing standby database. This step is to create a new standby database and involves automatically taking a backup of the primary database. The primary database will not be shutdown during this process. This step can be done through a command line interface (CLI) OR a GUI web-based interface (GUI).
Choose either CLI or GUI to configure DBvisit Standby- NOT BOTH
Create standby database by CLI
1. Start the Dbvisit Standby command console from the Start Menu > Programs > Dbvisit > Dbvisit Standby Command Console.
2. Confirm that this is the primary server.
=>dbvisit_setup only needs to be run on the primary server.
Is this the primary server? <Yes/No> [Yes]:
3. Choose option 7:
=========================================================
Dbvisit Standby Database technology
http://www.dbvisit.com/
Dbvisit Database setup
Default values will be shown in []
Options:
1) New Database setup (combines options 2,3,4)
1a) New 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
9) Uninstall Dbvisit Database repository (DDR)
E) Exit
=========================================================
Please enter choice : 7
4. You are asked to choose for which primary database you want to create a standby database. Choose the required DDC and follow the on-screen instructions:
------------------------------------------------------------------------------
=>Creating Standby Database.
Primary database will NOT be shutdown.
For which primary database do you want to create a standby database?
The following Oracle database(s) have a Dbvisit Database configuration (DDC)
file on this server:
DDC
===
1) w120n
2) dbvomf10
3) Return to menu
Please enter choice :Please enter choice : 1
5. Once the standby database has been completed, choose option E to exit.
Create standby database by GUI
1. Click on the Create New Standby Database under the Home -> Setup menu.
2. Select Database from drop-down menu
3. If not using ASM for the standby database, select No and press Continue.
4. A precondition is executing to ensure the standby server environment is correct. This process may take a while to complete.
5. Select the options below as required.
6. Continue with process until creation of standby database is complete.
7. Creation of standby database only needs to be run on the primary server. Not on the standby server.