Oracle instance Startup Process and file operations, when SystemCheckpointSCNDatafileCheckpointSCNStartSCN, Oracle database can be normal
Oracle instance startup and file operations, when System Checkpoint SCN = Datafile Checkpoint SCN = Start SCN, Oracle database can be normal
Oracle instance Startup Process and file operations
Initialize an instance
Then mount the database
Then load and open the database
Initialize instance startup nomount
First, oracle goes back to pfile and spfile to initialize the instance, allocate sga, background processes, and track logs.
Then alter database mount
Start the instance, open the control file, connect the instance to the database using the parameters in the control file, and check whether the database log file exists.
Then alter database open
Open various data files
The SMON System Monitor process checks the information of various files based on the SCN information recorded in the control file.
When System Checkpoint SCN = Datafile Checkpoint SCN = Start SCN, the Oracle database can be started normally without any media recovery. If there is a difference between the three, media recovery is required.
**************************************** *******
Note: About SCN view about SCN
Related reading:
Knowledge points of Oracle instances and services
,