Re: Disaster Recovery HELP!!

I am interested, so I would like copies. I often get asked for scripts by students (so I hope you won't mind me doshing them out to all and sundry if they are appropriate).

And I've seen this log switch thing done loads of times, but in my view it's still a complete waste of time. The only time you need worry about not having that last drop of redo is if you're expecting all members of the current log to suddenly go walkabout. So I'm not knocking it, but it seems a bit over the top to me. In my view, the thing that protects online redo logs is not transfering their contents into archives using this mechanism, but having them properly mirrored in the first place.

Incidentally, if you do it, your backup is no more 'up to the minute' than if you didn't do it, in the sense that come recovery time, you'll still need to apply that redo stream -and it's really rather irrelevant whether that bit of the stream is contained within an online redo log file, or an archived one. If it's in both, Oracle will use the on-line version anyway. Recovery time won't be affected one way or the other.

Regards
HJR

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


"Glen A. Stromquist" <glenstr_at_my-deja.com> wrote in message
news:8uv86v$4m4$1_at_nnrp1.deja.com...


> <snipped>

> >In particular, you'll

> > discover that there's a very good reason why backup exec won't take an

> > online copy of the Online Redo Logs -because it would be pointless to

 do so.


> > The files would be internally inconsistent, and what mechanism have

 we got


> > to make them consistent??  Nada is the short answer.

>

> It is pointless to take a copy of the online redo logs, but what you

> can do is have your  hot backup script do an alter system switch

> logfile after the last datafile has been backed up and put back online,

> then take a copy of these logfiles that were generated while the

> hotbackup script was running as part of your hot backup. This gives you

> a true "up to the minute" hot backup.

>

> I have a simple set of 3 SQL*PLUS scripts I wrote for an NT hotbackup

> that does exactly this, if you are interested I'll send you a copy.

>

> > ----------------------------------------------------------------------

 -----


> > Opinions expressed are my own, and not those of Oracle Corporation

> > Oracle DBA Resources:

 http://www.geocities.com/howardjr2000


> > ----------------------------------------------------------------------

 -----


> >

> > "George" <corcorang_at_my-deja.com> wrote in message

> > news:8ule0r$9vk$1_at_nnrp1.deja.com...

> > > Ok I think i have managed to open the database and reset the logs.

> > > This is what happened i started recovery and when it got to the

 archive


> > > log that i didn't have, i restored an online log file that just

> > > happened to get backed up.  The recover took the log and finished

> > > recovery and open sesame it worked.  Now backupexec oracle client

> > > doesn't backup online log files and i was just lucky the grp2 log

 was


> > > on another disk that i backed up.  I now downed the server stopped

 all


> > > services and took a cold backup of the entire server so I think i

 will


> > > be ok.  I don't think i trust this hot backup stuff.  Thanks for all

> > > the advice.

> > >

> > >

> > > Sent via Deja.com http://www.deja.com/

> > > Before you buy.

> >

> >

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.