Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Hot backup - when to clear those archived logfiles? Must reset logs?
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 H
ot
> 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 backup
s
> > 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 Mon May 01 2000 - 00:00:00 CDT