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

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