DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Thursday, March 24, 2016

Shutdown options in a oracle database

Please find the below shutdown options

                                                   PS            CU            TC              SC               NU

Shutdown abort                           N               N              N                N                 N

Shutdown immediate                  Y               Y              N                 N                 N

Shutdown transactional               Y              Y              Y                  N                 N

Shutdown normal                         Y              Y              Y                 Y                  N



PS     --  PROPER SHUTDOWN

CU    --   CHECKPOINT UPDATE

TC     --  TRANSACTION COMPLETE

SC     --  SESSION CLOSED

NU    --  NEW USER


Shutdown abort : (Instance Failure)
---------------------

 ---  Nothing will happen among the above.


Shutdown immediate
----------------------------

Only do PS and CU. Not allow TC,SC,NU


Shutdown transactional
-----------------------------

Only do PS,CU and TC (Only Current transaction will get complete which is happening in the db)

Not allow SC,NU


Shutdown normal
-----------------------

All the above will happen except NU (will not allow).


In Realtime we are using shutdown immediate where Proper shutdown and Checkpoint will update(ie SCN)

No comments: