Prerequisites for creating the standby database are:
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.
If the ASM storage is used and the version is lower than 11g, the Graceful Switchover option is not available. This feature is only available when the ASM (Grid Infrastructure) is 11g and above. If you are using Regular Filesystem based storage, the Graceful Switchover option is available. |
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. |
The following methods are available to create the standby database:
This option is available only if following two conditions are met,
Option 1 should be chosen for small databases. |
The CSD process is by default making use of RMAN (when direct transfer is not used). To be more specific COMPRESSED BACKUPSET is used for the backups. In certain scenarios it might be required to adjust the backup option to not use compressed backups or to rather use image copies. This can be done by setting the RMAN_DBF_BACKUP_TYPE parameter in the primary server DDC file. This parameter can be set to specify if a backupset, compressed backupset or image copies are to be used during the CSD operation:
Valid Options for the RMAN_DBF_BACKUP_TYPE parameter are:
RMAN_DBF_BACKUP_TYPE=AS BACKUPSET RMAN_DBF_BACKUP_TYPE=AS COMPRESSED BACKUPSET RMAN_DBF_BACKUP_TYPE=AS COPY |
Standby Database Parameter File (Spfile/Pfile)
The spfile.ora (pfile.ora for Oracle database version less than 9) is created for the standby database using the parameter file (pfile or spfile) from the primary database. Oracle database parameters for the standby database can be customised during the Dbvisit Standby Create Standby Database (CDS) process.
If an existing pfile or spfile is already present on the standby server for the new standby database, it will be overwritten. |
The Create Standby Database (CSD) wizard will guide the process for customizing of the 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, this can be used to create the standby database. No further questions will be asked.