Re: rman recover/restore from backup

"Ron" <support_at_dbainfopower.com> wrote in message news:<6POdnZF_DPsRKaTdRVn-vA_at_comcast.com>...
> Hello Norm,
>
> I just got back after two 15 hour days of work (nice weekend, I guess), so
> sorry for the delay.
>
> Below are the steps involved in the logs included. Hope everything is
> clear and simple.
>
> And Hope you are right and people you mentioned would be nice and brave to
> recognize that other things and methods exist outside of their world.
>
> Regards,
>
> Ron

[Giant Snip]

Finally you post something which is tested, verified and works. That is enormous progress on your part, and is extremely welcome. It would be churlish of me to say anything else. In this game, you take your breaks where you can find them.

The only slight fly in the ointment is that practically none of what you posted was needed by the original poster (not just my opinion, but confirmed by the original poster himself). So this remains something of a display of wizardry for wizardry's sake, and not an actual answer to a stated business need.

That aside, someone who really does need to do this stuff at some point in the future may well be extremely grateful for the detail you have provided.

If I was to be picky, however, I might note that your RMAN backup of database 1 is only a level 0 incremental, without any subsequent level 1,2, 3 or 4 incrementals (as our original poster had).

And it still remains moot why, having got database 1's archives and control file back, you don't just do an RMAN recovery of that database directly. Why go on to create an auxillary database when the original database itself can be recovered just fine from that point? That is the nub of this entire discussion, of course, and why our original poster eventually found that he had no need of TSPITR. It all goes unnecessarily complex at your step 6.

But whatever. Let me be the first to acknowledge that, unlike your advice on alert logs in external tables, and unlike your ill-informed comments about Richard Foote v. Don Burleson, what you have posted here shows effort and skill. About time, some might say. And the fact that the effort and skill has no relevance to the original post is, I suppose, neither here nor there, in the great scheme of things.

At the end of the day, Ron, no-one here (at least, not me) will ever refuse to "recognize that other things and methods exist outside of their world". This isn't a question about what other methods might or might not exist, and never has been. It's about whether *your* method was applicable to the original poster, and whether my not mentioning it was "reckless". The fact remains, unfortunately (for you) perhaps, that the original poster got his database back without using your 'method', which should tell you something.

And on that basis, I think this thread should end.

HJR Received on Mon Feb 23 2004 - 16:26:35 CST