Standby database files renaming rules

Owned by KrupeshD (Deactivated)
Last updated: Nov 30, 2012Version comment
1 min read

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.


Refer to the table below to find out how Dbvisit Standby creates standby datafiles, tempfiles and redo logs.

Excel: spreadsheet preview is finally here!

You can now display this file as a spreadsheet, instead of a PDF. Re-upload Workbook1.xlsx to display the new preview. You can access the file here.