Re: Shutdown and archivelog mode

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Mon, 03 Sep 2001 05:20:25 -0700
Message-ID: <F001.00380D89.20010903045019@fatcity.com>

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:

There is an uncommitted transaction that needs to roll back.
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 <siqbal_at_vianetworks.co.uk> 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: abardeen1_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

Received on Mon Sep 03 2001 - 07:20:25 CDT