Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Archive files and their Management

RE: Archive files and their Management

From: Jay Hostetter <>
Date: Fri, 18 Oct 2002 08:49:20 -0800
Message-ID: <>

  I'm not quite sure what you mean by "modify the database startup procedure." You must be in MOUNT mode to change between archive and noarchive. You don't need to change the mode each time you startup you database. Once you put a database in archivelog mode, you are in that mode until you change it - no matter how many startup/shutdowns you do.   It doesn't matter if you have a cold vs. hot backup. As long as you have database backup and all of your archivelogs, you can do a point-in-time recovery from that backup until your last archivelog.


>>> 10/18/02 12:09PM >>>
I'm up for my backup and recovery class here soon, but this conversation has brought up questions
that I think some of you wouldn't mind discussing anyway. I see where implementing archive logs
requires that you modify the database startup procedure to turn on archiving before opening the
database. At this point the DBA should do an immediate "baseline" backup (orafaq =)) which
implies a hot/online backup. I am curious how this goes with point in time cold backups. ie. DBA
does a cold backup opens the database in archive log mode. Can you apply accumulated archive
logs to a restore from cold backup ? perhaps there are issues with the control file information.....  

 -----Original Message-----
Sent: Friday, October 18, 2002 7:53 AM
To: Multiple recipients of list ORACLE-L

theoretically only the archive files after the backup started are needed. but there might be issues of a corrupted backup, and to guard against that we have a policy of keeping archive files for one week.  

you should also keep checking your backups by restoring them to a separate location periodically  


This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of D&E except to the extent that it relates to their official business.

Please see the official ORACLE-L FAQ:
Author: Jay Hostetter

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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 Fri Oct 18 2002 - 11:49:20 CDT

Original text of this message