Page Comparison

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

1. Oracle software must be installed on the standby server.
2. Enough free space on the standby server must be available for the standby database.
3. The Oracle background (cdump, udump, bdump etc. ) and admin directories are created.These directories can be created by Dbvisit if you choose the option to create missing filesystem directories automatically.

Dbvisit Standby allows the following options for creating the standby database:

a) Regular file system standby database with

i) Same structure as primary database or
ii) Different structure as primary database.

b) ASM standby database (for Oracle version 10.2 and higher) with

i) Same structure as primary database or
ii) Different structure as primary database.

Dbvisit Standby - standby database creation methods

The following methods are available to create the standby database:

1. Direct transfer to the standby server (on the fly creation) over the network.
2. Using a temporary location to create a complete backup of the primary database and then transferring the complete backup from the temporary location on the primary server to the standby server over the network.
3. Transportable Media which uses a temporary location to create a complete backup of the primary database and manually transferring the complete backup to the standby server using TRANSPORATBLE MEDIA. Transportable media is an external device such as a USB drive that is first plugged into the primary server and then manually transferred to the standby site and plugged into the standby server to complete the process.

Option 1 should be chosen for smaller databases.
Option 2 should be chosen for larger databases.
Option 3 should be chosen for very large databases or slow networks.
Option 2 and 3 will require adequate space on the primary server to make a (compressed) copy of the database files.

Standby database spfile/pfile

Creation of standby database using CLI or GUI

The creation of the standby database can be done either through the command line interface (CLI) or the web based graphical user interface (GUI). The CLI commands are indicated with a _{Image Removed} and the web based or GUI commands are indicated with a _{Image Removed}

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

Create standby database by CLI

1. Start the Dbvisit Standby command console from the Start Menu > Programs > Dbvisit > Dbvisit Standby Command Console. 

Image Added

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.

Image Added

2. Select Database from drop-down menu

3. If not using ASM for the standby database, select No and press Continue.

Image Added

4. A precondition is executing to ensure the standby server environment is correct. This process may take a while to complete.

Image Added

5. Select the options below as required.

Image Added

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.