RE: Database backup question.

I don't understandy why you would switch to and from archivelog mode. You can establish a complete cold backup with your datafiles, control files, and online redo logs. Actually you don't need the online redo logs, but that used to be the case so I always back those up as well. Shut your DB down
(normal), and back these files up. That is a complete cold backup.

You certainly could place your database in archivelog mode, and still back it up with cold backups. In this scenario you just add the archived logs to your list of files to back up. The only valid reason I can think of for switching between modes would be to avoid excessive archival resulting from very large processes. If you have room to archive logs you should consider leaving your DB in archivelog mode. Your odds of having a satisfying recovery scenario are greatly improved that way.

Steve McClure
  -----Original Message-----
  From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Meomeo Nguyen   Sent: Thursday, May 23, 2002 4:34 PM
  To: Multiple recipients of list ORACLE-L   Subject: Database backup question.

  Hi All,

  I need to perform a consistent backup for my whole database every Friday by using operating system utilities. My database has been currently operating in NOARCHIVELOG mode, so the only files need to be backed up are datafiles, control files, the initialization parameter file and other oracle product initialization files (Based on Oracle8.1.6 Backup and Recovery Guide). Since the files in this type of backup are all consistent and do not need recovery, so the online logs are not needed. Since online redo logs is very crucial for recovery, so my question is do I need to back up the online redo log files as I choose to perform cold backup type for my entire database weekly? Here is step by step what I did to back up the whole database:

  after the database was closed cleanly and all the above mentioned files had been backed up into the tape. I had to restart the database and mount but not open, then switched between NOARCHIVELOG mode to ARCHIVELOG mode in order to archive the online redo log files. Finally, I copied all archived redo log files into the tape while the database was open and operated in ARCHIVELOG mode. when it was all done, I then switched the database back to NOARCHIVELOG mode. Just wondered whether my procedure to perform a whole consistent database backup is correct? Am I safe to this point? Your help is greatly appreciated it. Your help is greatly appreciated.

  Thanks in advance,

  Trang

--
  Do You Yahoo!?
  LAUNCH - Your Yahoo! Music Experience


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve McClure
  INET: smcclure_at_usscript.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).