Re: Disaster Recovery HELP!!

Hi Glen,

Yeah, I know you want it all in one place, but since it doesn't *need* to be in one place, 'cos Oracle will work all that out for you... oh well, you know what I was trying to say, and I know what you are trying to do!

howardjr_at_www.com would be great, thank you.

Take care,
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:8v0u75$egr$1_at_nnrp1.deja.com...


> In article <3a136b7a_at_news.iprimus.com.au>,

>   "Howard J. Rogers" <howardjr_at_www.com> wrote:

> > 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).

> I'd be happy to send you a copy, although I'm wondering why you would

> want a script that does something you deem totally unnecessary, perhaps

> for education purposes only?

>

> My point in doing this was to have EVERYTHING I needed to do a restore

> in one place, ie. my backup destination on another drive on a different

> machine. I believe that the script I wrote does just that.

>

> Your feedback (and others)is always welcome...

>

> ps. where do you want the scripts sent?

>

>

> > 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.

> >

> >

>

>

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

> Before you buy.