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

but when to purge all those archived redo logfiles? for example; supposed I start my database to run on archived log mode on sunday morning, I saw the first archived redo logfile#1 in the system, in the meantime I do hot backup of all the controlfiles and datafiles (take#1), plus init & others.

Them I do an incremental backup of the archived redo logfiles throughout the weekdays.

Then on the next sunday, I configured the system to take in a new hot backups of the datafiles and controlfiles (take#2)and saw the logfile number at 200. Does that mean I can purge off all the logfiles #1-199?

Can I have a complete recovery the week after with hot backup at Take#2 with logfiles #200 onwards?

I only have 2 volumes of 8GB harddisk spaces & 70% usage already. I cannot keep all the logfiles anymore.

Please advise.
WCK Jerry Gitomer <jgitomer_at_erols.com> wrote in message news:20000430.5075500_at_noname.nodomain.nowhere...

When running hot backups you should do the following:

Back up the archives
Back up the database
Delete the archives that have been backed up.

Many DBAs, myself included, prefer not to delete the backed up archives for a couple of days - just in case it is necessary to recover from something other than the latest backup. (This assumes that you run hot backups on a nightly basis.)

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/30/00, 12:00:51 PM, "WCK" <abramswee_at_yahoo.com> wrote regarding Hot backup - when to clear those archived logfiles?:

> 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 Sun Apr 30 2000 - 00:00:00 CDT