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

Jerry Gitomer wrote:
>
> Incorrect, if you like to live dangerously and delete all of the old
> archives you want to do a switch log just before you start the hot
> backup. Remember that the redo logs created during the backup will
> have to be applied if you need to recover. Therefore you shouldn't
> delete the redo logs and archives created while running the hot
> backup.
>
> Why do you want to cut things so close? It requires you to
> micromanage your backups and be there to determine what to keep and
> what to delete. Assuming you are running nightly backups you are
> better off writing a script that runs the backup and then deletes any
> archives that are more than one day old.
>
> >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
>
> On 5/1/00, 12:51:12 AM, "WCK" <JackDaniel_at_Im_in_IT_yeah!.com> wrote
> regarding 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

Actually, you do the switch logfile **after** you have backed up all the tablespaces. This is because while the tablespaces are in 'begin backup' mode, transactions affecting those tablespaces are written to the online redo logs.

-- 

Ron Reidy
Oracle DBA
Reidy Consulting, L.L.C.