| Align |
|---|
This step can be skipped, if a standby database is already present. Dbvisit Standby can work with existing standby databases. To integrate Dbvisit Standby with an existing standby database, skip this section and go to section Dbvisit Standby commands (running or executing Dbvisit Standby). Dbvisit Standby does not distinguish between an existing standby database and a standby database created through Dbvisit Standby.Dbvisit Standby can automatically create the standby database. The standby database will reside on the standby server and is an exact binary copy of the primary database.The standby database only needs to be created once. After the standby database is created, Dbvisit Standby will automatically ensure the standby database is kept up to date with the primary database.Dbvisit Standby normally uses the network to transfer the primary database to the standby server to create the standby database. For slow networks or very large databases, use the transportable media creation method to create the standby database. The primary database will not be shutdown during standby database creation. Dbvisit Standby uses RMAN in most cases to make a backup of the primary database.
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 b) ASM standby database (for Oracle version 10.2 and higher) with i) Same structure as primary database or |
Dbvisit Standby - standby database creation methods
The following methods are available to create the standby database:
...
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
| Align |
|---|
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 
Create standby database on the fly using CLI
The example below shows how to create standby database on the fly (by direct transfer to the standby server). Creating a standby database is performed on the primary server (primary node).
For a complete overview of creating the standby database, please see Start the Dbvisit Standby command console from the Start Menu > Programs > Dbvisit > Standby.
...
14. Dbvisit Standby can now be run on completion of the standby database creation. To run Dbvisit Standby go to section Dbvisit Standby commands (running or executing Dbvisit Standby).
Create standby database using GUI
The example below shows how to create an ASM standby database using a temporary location to create the initial backup. Creating a standby database is performed on the primary server (primary node).
For a complete overview of creating the standby database, please see Creating Standby Databases automatically with Dbvisit Standby
1. 
Home > Setup > Create New Standby Database > select Database from drop-down menu
2. We are using ASM for the standby database, select Yes and press Continue.
...