Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Backup redo log files...or not?

Backup redo log files...or not?

From: Ethan Post <Blah_at_Blah.com>
Date: Thu, 21 Jun 2001 06:19:37 GMT
Message-ID: <ZlgY6.59851$%a.2984954@news1.rdc1.sdca.home.com>

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.

  1. What is the correct answer?
  2. What is the correct answer if it appears on the exam?

Thanks,
Ethan Post Received on Thu Jun 21 2001 - 01:19:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US