Re: Database BackUp

In article <6694t2$f7a$1_at_Nntp1.mcs.net>, Declan O'Reilly <declan_at_mcs.com> writes:

>Subject: Re: Database BackUp
>From: Declan O'Reilly <declan_at_mcs.com>
>Date: Fri, 05 Dec 1997 09:02:35 -0600
>
>Does this mean if I loose a redo file before it fills up (ie copied to
>the Archived Directory), I would loose any data that is in the redo
>file. So does it make sense to force the current redo file to be
>Archived (is this possible ? ) before the nightly backup.
>
>Paul
>
>

You got it! Before you do a backup (Hot, Cold, whatever), you can force a switch logfile. That writes whatever is in the redo logs to archive logs in the directory you've specified for archive log files. I guess for a cold backup that's not really necessary since you're doing an image backup of your entire system. An incremental back up is simply the backup of archive log files since your last full (cold) backup. When you have to do a database recovery, you lay down all the database files comprising your database and all the archive log files. Oracle will apply all those changes so that you're recovered to a point in time.

It's also a good idea to keep your redo log files and archive log files on separate disks from your database data files. If you do have a crash, you'll at least have those archive log files available somewhere.

--Bob. Received on Fri Dec 26 1997 - 00:00:00 CST