![]() When you successfully mount your database, the instance is aware of the locations of the data files and online redo logs but hasn’t yet opened them. If any of the control files listed in the CONTROL_FILES initialization parameter aren’t available, then you can’t mount your database. When you alter your Oracle database 12C into mount mode, the control files are read and opened for use: - control files opened ![]() When you issue a STARTUP NOMOUNT command, Oracle reads the parameter file and starts the background processes and allocates memory structures: - locations of control files are known to the instanceĪt this point, the control files haven’t been touched by any processes. When you start your database in nomount mode, the instance is aware of the location of the control files from the CONTROL_FILES initialization parameter in the spfile or init.ora file. ![]() You can view database-related information stored in the control file via the V$DATABASE view: SQL> select name, open_mode, created, current_scn from v$database Įvery Oracle database 12C must have at least one control file. ![]() SQL> select distinct type from v$controlfile_record_section
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |