Re: Backup redo log files...or not?

"Ethan Post" <Blah_at_Blah.com> wrote in message news:<ZlgY6.59851$%a.2984954_at_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

There is no need to backup the online redo logs as part of a normal backup procedure. To the best of my memory there are no questions on the OCP Backup and Recovery Examination that would require you to select an answer contrary to this fact.

• Mark D Powell --