CONTROLFILES initialization parameter use alias filenames of control files. - Oracle Control Files

Discussion

• Nirja Shah   -Posted on 28 Aug 15
  - Oracle Database references database files by their alias filenames, but only if you create the database files with aliases.
  
  - If you create database files without aliases and then add aliases later, the database references the files by their fully qualified filenames.
  
  - The following are examples of how the database uses alias filenames:
  
  - Alias filenames appear in V$ views. For example, if you create a tablespace and use an alias filename for the data file, the V$DATAFILE view shows the alias filename.
  
  - When a control file points to data files and online redo log files, it can use alias filenames.
  
  - The CONTROL_FILES initialization parameter can use the alias filenames of the control files. Database Configuration Assistant (DBCA) creates control files with alias filenames.

➨ Post your comment / Share knowledge