Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: redo log maintenance

Re: redo log maintenance

From: Tanel Poder <>
Date: Thu, 26 Jun 2003 18:43:08 -0700
Message-ID: <>


You won't be affecting any current redolog negatively, you simply get an error, but the normal work continues as usual...


style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">

  href="mailto:[EMAIL PROTECTED]">Multiple recipients of list ORACLE-L   

  Sent: Friday, June 27, 2003 12:49
  Subject: RE: redo log maintenance   

  just say that the docs are erroring on the safe side.  The reason is that   if you try to do any of these tasks with the database open you could be   affecting (negatively) an active log file.  While I agree with both of   you that you can make these mods while the DB is open doing so while the DB is   quite is the best time.
  Dick GouletSenior Oracle DBAOracle Certified 8i DBA   

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Gogala, Mladen   [mailto:[EMAIL PROTECTED]Sent: Thursday, June 26, 2003 5:25   PMTo: Multiple recipients of list ORACLE-LSubject: RE:   redo log maintenance
  is plain wrong. I've been adding, dropping and switching logfiles ever since   the version 6 and
  have never needed to shut down the database for it.    
  Mladen Gogala <FONT face=Arial
  size=2>Oracle DBA Phone:(203)
  459-6855 Email:[EMAIL PROTECTED]   

    <FONT face=Tahoma
    size=2>-----Original Message-----From: Koivu, Lisa     [mailto:[EMAIL PROTECTED]Sent: Thursday, June 26,     2003 5:00 PMTo: Multiple recipients of list     ORACLE-LSubject: redo log maintenance     I'm reading through the 9.2 admin guide (yawn)     and it says that the database must be mounted but not open to add, drop or     rename redo logs.  I have done this many times with the database up and     running, with no problems.  Why would it say this in the doco, or is     the doco just plain wrong (again)?  It doesn't let you do anything to     redo logs that aren't archived or are currently being used, what's the     harm?
    I don't get all the emails from the list - in     fact I get none most of the time.  So please be sure to include my     personal email address when responding.     Thanks
    Lisa Koivu <FONT face=Tahoma
    size=2>Oracle Database Monkey Fairfield     Resorts, Inc.
    Orlando Office: 407-248-4277 <FONT
    face=Tahoma size=2>Ft. Lauderdale Office: 954-935-4117      Fax:   
    954-935-3639 Cell:   
    "The sender
    believes that this E-Mail and any attachments were free of any virus, worm,     Trojan horse, and/or malicious code when sent. This message and its     attachments could have been infected during transmission.  By reading     the message and opening any attachments, the recipient accepts full     responsibility for taking proactive and remedial action about viruses and     other defects. The sender's business entity is not liable for any loss or     damage arising in any way from this message or its     attachments."-- Please see the official ORACLE-L FAQ: -- Author: Koivu, Lisa INET:     [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 San Diego, California -- Mailing list and web hosting     services

Received on Thu Jun 26 2003 - 20:43:08 CDT

Original text of this message