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?

The training materials actually state that although backing up the online redo logs when you have performed closed, consistent backups is not strictly necessary, it may speed up the recovery process if you do.

Personally, I always do back them up, since recovery then consists of a 'copy *.*' command, followed by a startup.

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

Good question! For the exams, follow the training material... and on the whole, the training material says closed backups should (but do not need to) involve the redo logs.

Regards
HJR
> Thanks,
> Ethan Post
>
>
>
Received on Mon Jun 25 2001 - 07:02:03 CDT