RE: Database backup question.

[Steve McClure]

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]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