Re: Hot backup - when to clear those archived logfiles?

From: Terry <banicki_at_home.com>
Date: 2000/05/03
Message-ID: <390F99AD.FC2FFC01@home.com>#1/1

What we do,

-full online backup to disk every night
-followed by a log switch.
-copy the archive logs, backups, init and pwd file to tape every night files.
-then we delete the archive logs that are two days old

That insures that the archive log are written to two tapes. This keeps a copy of all the files need to do a recovery on the hard disk. If we need to go back farther, we have to hit the tapes. Do you have a tape drive?
7x24? What's the cost of an outage? For an hour? For 8 Hours? For a Day?

WCK wrote:

> I have to switch a current 7.3 Oracle database that runs on NT from cold
> backup to hot backup for 24x7. I read all I can about the hot backups
> techniques but I am still confused as to when I can clear all the archived
> logfiles; after a complete db shutdown, or after a hot backup of all the
> datafiles?
>
> And to have a complete database recovery, should I restore the most recent
> hot backuped datafiles and those logfiles after that or do I have to put in
> allllll the logfiles from the beginning?
>
> I have limited harddisk spaces left so I can't spare alot to keep a whole
> storage of archived logfiles. Any help are highly appreciated.
>
> CK
Received on Wed May 03 2000 - 00:00:00 CDT