Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: rman recover/restore from backup

Re: rman recover/restore from backup

From: Joel Garry <joel-garry_at_home.com>
Date: 20 Feb 2004 17:16:16 -0800
Message-ID: <91884734.0402201716.46dfe7ec@posting.google.com>


"Ron" <support_at_dbainfopower.com> wrote in message news:<XdmdnZPGG84KXqjdRVn-sw_at_comcast.com>...
> Hello Norm,
>
> I can spend couple hours of my time and send results to the group. No
> problem at all. (Anyone can do this even without prior experience - metalink
> filled up with the step by step notes on tspitr).
>
> What I afraid is that this would only add gas to the flames. If major
> thread participants (those who you mentioned) think opposite, I'll be glad
> to do this. If I'll fail - I'll apologize and will expect same from them.

From the original tspitr page you linked to, a list of the things tspitr is good for correcting:

None of those are even close to what the OP had.

You just didn't understand what it was the OP didn't understand. Those misapprehensions of the OP are the clues that hjr was able to correctly read and correct in his first post.

One of the most important aspects of being a production DBA or support DBA is to asses the situation correctly. This includes spotting incorrect usage of words or concepts when given the problem symptoms. If someone asks the proper way to deice a carburetor with an acetylene torch, the proper answer is "Don't do that." There are ways to deice a carburetor, but they usually involve a small airplane and a carb-heat control. There are uses for the torch too. If the person has a diesel VW Rabbit, you _know_ he is asking the wrong question. The right answer might be "cut the Rabbit into small pieces."

So go ahead and do your demo. Give it a new Subject line. Like a rabbit or certain former presidential candidate, We're All Ears.

>
> Regards,
>
> Ron
> DBA Infopower
> http://www.dbainfopower.com
> Standard disclaimer:
> http://www.dbainfopower.com/dbaip_advice_disclaimer.html
>
>
>
>
>
>
>
> "Norman Dunbar" <norman.dunbar_at_lfs.co.uk> wrote in message
> news:3078e2fe.0402191028.50bce0ec_at_posting.google.com...
> > Eee, by 'eck. I go away for a couple of monthsand when I come back
> > (briefly) there's all sorts of carnage going on.
> >
> > I'm with Richard on this one - it's been a hell of a thread and I love
> > it.
> >
> > It's a hard world behind the firewall. No news, b*gg*r all email most
> > of the time, and an 'interesting' situation of DBAing at this place.
> > :o)
> >
> > No offence Sybrand - I'd hate to fall out with you - but I especially
> > loved the bit where you gave advice on civil behaviour. Nice one :o)
> >
> >
> > Anyway, here's my £0.02 as it were :
> >
> > "Ron" <support_at_dbainfopower.com> wrote in message
> news:<GIudnVoTtMuB7a_d4p2dnA_at_comcast.com>...
> > > Hello Daniel,
> > >
> > > Please, not like that ;-)
> > > Can you please expand on may lack on English skills?
> > > Should I send you my English literature scores to washington.edu?
> >
> > If ever someone was setting themselves up for a huge fall, this is it.
> > I look forward to see what happens next.
> >
> > There is of course another way to sort out the 'minor' differences
> > here, Ron, how about recreating a setup where you craete a test
> > database (full of useful data) and bollox it in exactly the same way
> > as the OP did, or in a similar way. Then, create a new one using dbca
> > as the OP did, and recover it using your point in time recovery
> > advice.
> >
> > Spool the exercise to a file and let us see it here. If it works, and
> > I very much doubt that it will, I'm almost 100% certain that Howard
> > will retract all he said about your advice, Sybrand will apologise
> > profusely and Richard will also gladly refute what he said.
> >
> > I have to admit that I *am* 100% sure that it will not work, or at
> > least not recover the database back to exactly the same pont in time
> > as Howard's advice did.
> >
> > Given the situation here, I'd have taken Howard's advice any day. But
> > then, I take advice from people I know have practiced (should that be
> > practised - I can't remeber?) and experimented with the procedures
> > they advise on. I've seen the results (and the hard work) that go into
> > Howard's advice in the past - have a quick Google and see for yourself
> > - so I know I can trust him and what he says.
> >
> > I have also seen him publicly apologise when he gave incorrect or
> > insufficient advice too. Something you might want to consider
> > sometime.
> >
> > If my english isn't up to scratch then don't attempt to correct me, I
> > don't care because I'm not English and English is not my first
> > language - I'm Scottish :o)
> >
> > (And on that note, I'm anticipating a huge defeat at the weekend when
> > we play England in the 6 Nations Rugby. Just like last night at the
> > hands of the Welsh in the footie. We are totally cr4p at the moment in
> > everything, except curling I suppose - we won the Olympics at that!)
> >
> >
> > Yours in anticipation,
> >
> > Norm.
> >
> > (Hopefully, I'll get to read some of the replies. This Googling is a
> > major PITA.)

But it works. kindasorta. Imagine if it went away.

> >
> > And by the way, those who know me will also know that the email
> > address is a spam trap - it no longer exists.

Isn't that handy? :-)

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/uniontrib/fri/business/news_1b20sony.html
Received on Fri Feb 20 2004 - 19:16:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US