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.
Received on Thu Nov 16 2000 - 09:24:32 CST