Describe different stages of starting up instances?
Describe different stages of starting up instances? When Oracle Database starts an instance, it reads the server parameter file or initialization parameter file to determine the values of initialization parameter.
- Restricted Mode of instance Startup:
- Forced Startup in Abnormal Situations
- Starting Up an Oracle DB Instance: NOMOUNT:
- Start Up an Oracle database instance: MOUNT
- Mounting a database includes the following tasks.
- Associating a database with a previously started instance.
- Locating and opening the control file specified in the parameter file.
- Reading the control files to obtain the names and statuses of the data files and online redo log files.
- To perform specific maintenance operations, start an instance and munt a database.
- Renaming data files.
- Performing full database recovery.
- Starting Up an Oracle database instance: Open:
- Opening the data files.
- Opening the online redo log files.
You can start an instance in restricted mode. This restricts connections to only those users who have been granted The RESTRICTED SESSSION system privilege.
In unusual circumstances, a previous instance might not have been shut down cleanly. To resolve this problem, you must terminate all remnant Oracle Database processes of the previous instances before starting the new instance.
An instance is typically started only in NOMOUNT mode during database creation, during re-creation of control file. Starting an instance includes the following tasks. Searching of a particular name.
A normal database operation means that an instance is started and the database is mounted and opened. Opening the database instance in the following tasks.