| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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?
Going by what you had advised, it is inevitable that I should do a complete database shutdown probably once a month. That way, I can have
- a complete cold backup, - clear all the archived redo logfiles, - reset the logs sequence,
New hardware are supposed to come in with bigger space but I really want to make the switch from NT to Solaris. a couple of days ago, my oracle intelligent agent just clashed with the listener and it shut down all connection to the database. There is no errors in the event view log, no abnormal stopping of the listener service, no GPF... looking thru' the alert logs now.
Just simply can't get used to the idea of running oracle on NT, like sticking a Ferrari engine on a Pontiac car frame.
Jerry Gitomer <jgitomer_at_erols.com> wrote in message news:20000501.4431200_at_noname.nodomain.nowhere...
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
Received on Mon May 01 2000 - 00:00:00 CDT
 |
 |