Recently tried shutting down a database and it hung after
Shutting down archive processes
Mon Feb 24 12:17:28 2014
ARCH shutting down
ARC2: Archival stopped
It was taking long so could not thought what can be done. Because this is shutdown immediate so we should leave the database as it is and it will shutdown eventually which it did with following in alert log. It took it a quite a while but eventually stopped normally. Hence if shutdown immediate hangs leave it and it should shutdown the database. I have not investigated what could have taken so long but it stopped.
Shutting down archive processes
Mon Feb 24 12:17:28 2014
ARCH shutting down
ARC2: Archival stopped
Tue Feb 25 08:28:38 2014
All dispatchers and shared servers shutdown
Tue Feb 25 08:28:38 2014
ALTER DATABASE CLOSE NORMAL
Tue Feb 25 08:28:39 2014
SMON: disabling tx recovery
SMON: disabling cache recovery
Tue Feb 25 08:28:40 2014
Shutting down archive processes
Archiving is disabled
Tue Feb 25 08:28:45 2014
ARCH shutting down
ARC1: Archival stopped
Tue Feb 25 08:28:50 2014
ARCH shutting down
ARC0: Archival stopped
Tue Feb 25 08:28:51 2014
Thread 1 closed at log sequence 1
Successful close of redo thread 1
Tue Feb 25 08:28:51 2014
Completed: ALTER DATABASE CLOSE NORMAL
Tue Feb 25 08:28:51 2014
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
No comments:
Post a Comment