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 file | Standby FS file | A valid existing filesystem location must be specified for the standby FS file |
Primary OMF file | Standby OMF file | Creation 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 fredo | Standby FS fredo | A valid existing filesystem location must be specified for the standby FS redo |
Primary OMF redo | Standby OMF redo | Creation 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 file | Standby OMF file | Creation 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 file | Standby FS file | A valid existing filesystem location must be specified for the standby FS file |
Redo logs | ||
Primary FQSN redo | Standby OMF redo | Creation 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 redo | Standby FS redo | A valid existing filesystem location must be used for the standby FS redo |
Primary FS => Standby ASM | ||
Datafiles and tempfiles | ||
Primary FS file | Standby FQSN file | A valid ASM diskgroup name must be specified. File will be created under ASM_diskgroup/db_unique_name/datafile|tempfile |
Primary OMF file | Standby FQSN file | A valid ASM diskgroup name must be specified. File will be created under ASM_diskgroup/db_unique_name/datafile|tempfile |
Redo logs | ||
Primary FS redo | Standby ALIAS fredo | A valid ASM diskgroup name must be specified. File will be created under ASM_diskgroup/db_unique_name/onlinelog |
Primary OMF redo | Standby FQSN redo | A 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 file | Standby FQSN file | A valid ASM diskgroup name must be specified. File will be created under ASM_diskgroup/db_unique_name/datafile|tempfile |
Primary ALIAS file | Standby FQSN file | A valid ASM diskgroup name must be specified. File will be created under ASM_diskgroup/db_unique_name/datafile|tempfile |
Redo logs | ||
Primary FQSN fredo | Standby ALIAS fredo | A valid ASM diskgroup name must be specified. File will be created under ASM_diskgroup/db_unique_name/onlinelog |
Primary ALIAS redo | Standby FQSN redo | A valid ASM diskgroup name must be specified. File will be created under ASM_diskgroup/db_unique_name/onlinelog |