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 and there are
a very large # of them to deallocate (usually due to
the default extent sizes for the temporary tablespace
being too low). See metalink note 61997.1 for an
excellent discussion on this.
HTH,
-- Anita
--- Sajid Iqbal <[EMAIL PROTECTED]> wrote:
> Hi
>
> Using Oracle 8.1.6.3 on solaris 2.7.
>
> I am trying to put my database in archivelog mode.
>
> When I 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 that the database can't be put
> into archivelog mode
> because recovery is needed.
>
> TIA
>
> --
> Sajid Iqbal
__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
