Shutting down database instance
SQL> SHUTDOWN NORMAL or simply 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.
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.
No comments:
Post a Comment