Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Database backup question.

Database backup question.

From: Meomeo Nguyen <>
Date: Thu, 23 May 2002 15:33:54 -0800
Message-ID: <>

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,


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

Please see the official ORACLE-L FAQ:

Author: Meomeo Nguyen
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: (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 Thu May 23 2002 - 18:33:54 CDT

Original text of this message