Starting up & Shutting down Oracle Database Instance Posted by MOHAMMED ABDUL HAMEED on 5:26 AM

Starting up :

SQL> STARTUP NOMOUNT
This state is used for creating new database or creating new control file. At this state, Oracle allocates SGA and starts background processes.

SQL> STARTUP MOUNT
This state is used for performing specific maintenance operations like renaming data files, enabling/disabling archive log mode, adding/dropping/renaming redo log files, recovering database etc. Control file is read at this stage but the data files are not open.

SQL> STARTUP OPEN or simply SQL>STARTUP
Database is available for normal operations.

Shutting down :

SQL> SHUTDOWN NORMAL or SQL> SHUTDOWN
Waits for all database users to disconnect then closes database.

SQL> SHUTDOWN IMMEDIATE
Terminates all user connections, rolls back uncommitted transactions, closes database.

SQL> SHUTDOWN TRANSACTIONAL
Waits for all transactions to commit or roll back, then closes database.

SQL> SHUTDOWN ABORT
Immediately closes database leaving it in inconsistent state. SMON automatically performs instance recovery during next startup.