Standby Database File Renaming

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

 

  • 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