Thursday, April 3, 2014

Oracle Database Startup Modes



No Mount Mode
Open and Read the Parameter file
Create\Append the Alert Log file
Memory Structures are allocated
Background process is started
Instance is started

Administrative Tasks in No Mount mode
Ø  To create Database
Ø  To recreate Control file

Mount Mode
Open and Read the Parameter file
Create\Append the Alert Log file
Memory Structures are allocated
Background process is started
Instance is started.
Open the Control file and read, check for physical existence of file.
Mount the Database. Data file\Redo Log files

Administrative Tasks in Mount mode
Ø  To perform system datafile recovery
Ø  To perform full database complete recovery
Ø  To perform incomplete recovery
Ø  To rename system datafile or redo log file
Ø  To place database to archive log mode to noarchive log mode
Ø  Other administrative tasks

Open Mode
Open and Read the Parameter file
Create\Append the Alert Log file
Memory Structures are allocated
Background process is started
Instance is started.
Open the Control file and read, check for physical existence of file.
Mount the Database. Data file\Redo Log files
Sync status of the Database
Database will be open

Administrative Tasks in Mount mode
To make database avaialble for users
To perform transactions

No comments:

Post a Comment