Re: Which Archive-Logs are to delete?

The guy is doing hot backups, and the one rule to remember about hot backups is that you do *NOT* backup your online redo logs. They are internally inconsistent, and there's no mechanism for getitng redo logs into a consistent state. Plus, given that you backup the archives, there is zero point in backing up the on-line ones.

I wouldn't comment on this, except that I've seen examples of people completely kacking up a database by restoring the online redo logs -and thus over-writing perfectly good ones with unreadable rubbish -and thereby losing data in the process.

But since you offered 'offline' backup scripts, I'm sure you knew all this: it's just that it's not what the original poster is actually doing.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

"Wolfgang Kremser" <wolfgang.kremser_at_colt.at> wrote in message
news:WweE5.8$tZ4.121_at_stuart.coltnet.at...


> Hi

>

> you have to backup more than the datafiles, you have to backup the

> controlfiles and online redo-logs too

>

>

> greetings Wolfgang

>

> PS: i'll search for my offline.backupscripts and post it here if anyone

> wants to see them :)

>

>

> Frank an der Heiden <fh_at_energotec.de> wrote in message

> news:8rmnms$php$1_at_oxygen.technet.net...

> > "Dave A" <dave_and_vanna_at_hotmail.com> schrieb im Newsbeitrag

> > news:sts9gu5u55ni47_at_corp.supernews.com...

> > > Are you backing up all your datafiles?  If you are leaving one or more

 out


> > > that would explain why Oracle wants to go back further than your last

 backup


> > >

> > > --

> > > Dave A

> > >

> >

> > Yes, I do a backup for all Datafiles.

> >

> > Frank

> > >

> >

> >

> >

>

>