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

In addition to that, izzit correct that I should do I resetlog on the database after a hot backup of all the datafiles so that at least I know where the first archived redo logfile begins after the hot backup, and then I can safely move away all those older logfiles that have other range of numbers to external storage?

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