Oracle Database shutdown in 3 phases as below:
1- Close the DB- By close all new transaction acceptance are stopped, current transaction are complete depends upon command issue.
SQL> alter database close;
Database altered.
SQL>
2- Database Dismount
SQL> alter database dismount;
Database altered.
SQL>
3- Shutdown Instance- As there is nothing running so we can abort it.
SQL> shutdown abort;
ORACLE instance shut down.
SQL>
No comments:
Post a Comment