Standby Database File Renaming

Dbvisit Standby uses a range of techniques to rename database files in the standby control file: 

  • Use Oracle database parameters db_file_name_convert and log_file_name_convert
  • Use RMAN command "set newname"
  • Ensure creation of OMF files is enabled in the standby database, to create OMF and FQSN files automatically

 

Standby Database File Renaming Rules

 

Dbvisit Standby creates a standby pfile init<ORACLE_SID_DEST>.ora in a default operating system location for Oracle databases version below 9. Oracle creates a standby spfile spfile<ORACLE_SID_DEST>.ora in a default operating system location for Oracle databases versions 9 and higher, when creating a filesystem standby database. For an ASM standby database, the user may alternatively specify a valid ASM location to create an spfile spfile<ORACLE_SID_DEST>.ora. The value of the control_files Oracle database parameter determines control files to be created for the standby database:

  • The user can provide full name for FS or ALIAS control files
  • To create OMF or FQSN control files, the parameter control_files should be left empty, or in case of the ASM standby, only the name of ASM diskgroup(s) should be specified. Creation of OMF files should be enabled on the standby by setting parameters db_create_file_dest and/or db_create_online_log_dest_n and/or db_recovery_file_dest
  • If the parameter control_files is not set, and creation of OMF files is not enabled on the standby, standby control files will be created in a default operating system location.

 

Primary FS => Standby FS
Datafiles and tempfiles
Primary FS fileStandby FS fileA valid existing filesystem location must be specified for the standby FS file
Primary OMF fileStandby OMF fileCreation of OMF files must be enabled on the standby by setting parameter db_create_file_dest. Datafiles and tempfiles will be created in this location.
Redo logs
Primary FS fredoStandby FS fredoA valid existing filesystem location must be specified for the standby FS redo
Primary OMF redoStandby OMF redoCreation of OMF files must be enabled on the standby by setting parameters db_create_file_dest and/or db_create_online_log_dest_n and/or db_recovery_file_dest. Redo logs will be created in these locations.


Primary ASM => Standby FS

Datafiles and tempfiles
Primary FQSN fileStandby OMF fileCreation of OMF files must be enabled on the standby by setting parameter db_create_file_dest. Datafiles and tempfiles will be created in this location.
Primary ALIAS fileStandby FS fileA valid existing filesystem location must be specified for the standby FS file
Redo logs
Primary FQSN redoStandby OMF redoCreation of OMF files must be enabled on the standby by setting parameters db_create_file_dest and/ordb_create_online_log_dest_n and/or db_recovery_file_dest. Redo logs will be created in these locations.
if CSD_FORCE_ASM_REDO_CONVERT set to Y in the DDC file (default N) then a FS redo will be created. This setting can be used for some environments that do not allow mounting of the standby database when its control file contains ASM names for redo and an ASM instance is not running.
 
Primary ALIAS redoStandby FS redoA valid existing filesystem location must be used for the standby FS redo


Primary FS => Standby ASM

Datafiles and tempfiles
Primary FS fileStandby FQSN fileA valid ASM diskgroup name must be specified. File will be created under ASM_diskgroup/db_unique_name/datafile|tempfile
Primary OMF fileStandby FQSN fileA valid ASM diskgroup name must be specified. File will be created under ASM_diskgroup/db_unique_name/datafile|tempfile
Redo logs
Primary FS redoStandby ALIAS fredoA valid ASM diskgroup name must be specified. File will be created under ASM_diskgroup/db_unique_name/onlinelog
Primary OMF redoStandby FQSN redoA valid ASM diskgroup name must be specified. File will be created under ASM_diskgroup/db_unique_name/onlinelog


Primary ASM => Standby ASM

Datafiles and tempfiles
Primary FQSN fileStandby FQSN fileA valid ASM diskgroup name must be specified. File will be created under ASM_diskgroup/db_unique_name/datafile|tempfile
Primary ALIAS fileStandby FQSN fileA valid ASM diskgroup name must be specified. File will be created under ASM_diskgroup/db_unique_name/datafile|tempfile
Redo logs
Primary FQSN fredoStandby ALIAS fredoA valid ASM diskgroup name must be specified. File will be created under ASM_diskgroup/db_unique_name/onlinelog
Primary ALIAS redoStandby FQSN redoA valid ASM diskgroup name must be specified. File will be created under ASM_diskgroup/db_unique_name/onlinelog