In this tutorial we learn about how to shutdown oracle database on linux. There are different stages of shutdown of oracle database. There are also different mode for shutdown oracle database. All DBA should know about all the mode of shutdown for oracle database.
Different stages of shutdown of Oracle database
There are three stages of shutdown of oracle database.all stages are described below.
Database closed: This is the first stage for shutdown of oracle database.some take occured during this phase.
1. All data moves from memory to datafiles on disk.
2. During this stages all datafiles and control file closes.
Database dismount:- This is the second stages of shutdown of oracle database. During this stages some tasks also occured.
1. During this stage oracle database disassociated from oracle instance.
2. During this stage oracle closes control file of oracle database.but oracle instance does not stop during this phase.
Oracle instance shutdown:- this is the last stage of shutdown of oracle database.some tasks also occured during this phase.
1. During this stage SGA is disallocated and all the background processes are stopped and oracle instance is shutting down during this stage.
Different modes of shutting down of oracle database
There are four different modes of shutting down of oracle database.these are below.
1. Shutdown immediate:--
In shutdown immediate in oracle mode all connected user sessions will be disconnected. All current transactions will be terminated. Oracle creates checkpoint and closes all data files.
2. Shutdown transactional:--
In this mode current transactions are being processed until end . Oracle does not accept new transaction.after end the current transactions checkpoint creates and closes all datafiles.
3. Shutdown normal:--
In this mode all connected user sessions are active until disconnected by user.all current transactions and new transactions processes until end. After that oracle creates checkpoint and close datafiles and shutdown the oracle instance.
4. Shutdown abort:--
In this mode oracle shuts down instance forcefully without create checkpoint.
In this article we learned about the shutdown of Oracle database.stay tune.
0 comments:
Post a Comment