Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Backup redo log files...or not?
I'm doing a bit of cramming for the B&R exam and I made the mistake of checking the documentation, it seems to contrast somewhat with the Training materials. From the docs for 8.1.7
"Avoiding the Backup of Online Redo Logs"
"Although it may seem that you should back up online redo logs along with
the datafiles and control file, this technique is dangerous. You should not
back up online redo logs for the following reasons: .."
Point 3 is...
"If your database is in NOARCHIVELOG mode, then the only type of backups
that you should perform are closed, consistent, whole database backups. The
files in this type of backup are all consistent and do not need recovery, so
the online logs are not needed. "
The training material very clearly say to backup the redo log files. I know HJR has covered this in the past but I don't have time to dig through the archives at the moment.
Thanks,
Ethan Post
Received on Thu Jun 21 2001 - 01:19:37 CDT