)
Due to this when I try to put it archivelog mode after shutdown abort I
get a message saying that the database can't be put into archivelog mode
because recovery is needed.
TIA
--
Sajid Iqbal
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sajid Iqbal
INET
try to shutdown the database using shutdown immediate, it just sits
there for ages.. (left it for 30 mins).
I've cancelled this and done a shutdown abort. (tried normal shutdown
after that, same)
Due to this when I try to put it archivelog mode after shutdown abort I
get a message saying
Sajid,
The db must be cleanly shutdown (normal or immediate)
in order to change the archivelog mode.
A shutdown immediate may not shutdown immediately for
several reasons, most commonly:
1. There is an uncommitted transaction that needs
to roll back.
2. SMON is deallocating temp segments