How to shut down a database?
There are several types in which we can shut down the
database as mentioned below.  
| 
Types of shutting down database | 
effect/consistency of  database | 
Preferred or not | 
| 
SHUTDOWN NORMAL   | 
Db will shut down only after all users got logged off. Database will
  be consistent after shut down | 
Preferred but will take much time to get down | 
| 
SHUTDOWN IMMEDIATE | 
Db will shut down once PMON commits or roll backs the transactions.
  DB will be consistent here too | 
preferred and good way to follow | 
| 
SHUTDOWN TRANSACTIONAL | 
DB will wait only after all transactions are completed. . DB will be
  consistent here too | 
preferred but will take little more  time compared to SHUTDOWN IMMEDIATE | 
| 
SHUTDOWN ABORT | 
Db will shut down with emergence and transactions are neither
  committed nor rolled back. Db becomes inconsistent after shut down. | 
Generally not preferred as it is used in case of emergency only | 
 
 
No comments:
Post a Comment