/
Create Standby Database (step 3) – Windows

Create Standby Database (step 3) – Windows

Jul 23, 2012

If the new standby database has FRA enabled, please remove all files from FRA/<unique_db_name> folder on the standby server, prior to creating the database. This is to avoid resetting the standby database incarnation triggered by the presence of old database files in FRA.

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

The spfile.ora (pfile.ora for Oracle database version less than 9) is created for the standby database using init.ora or spfile.ora file from the primary database. Oracle database parameters for the standby database can be customised. If an existing init.ora or spfile.ora file is already present on the standby server, it will be overwritten. The Create Standby Database wizard will guide the process and for customizing of Oracle standby database during the creation process. The settings can be saved as a template for future use. If a standby database template has been created previously, then this can be used to create the standby database. No further questions will be asked.

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

 and the web based or GUI commands are indicated with a 

For more information about creation of standby database, please see Creating Standby Databases automatically with Dbvisit Standby.