Re: rman recover/restore from backup

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

And by the way, those who know me will also know that the email address is a spam trap - it no longer exists. Received on Thu Feb 19 2004 - 12:28:17 CST