Re: rman recover/restore from backup

"Joe Fischer" <jfischer@__fischerhome__.org> wrote in message news:e7ja3013jeo7dm2t6tc9td5u7qgc8bucpk_at_4ax.com...

> Wow! 43 posts - not counting my own. I don't know if I
> should be thrilled or embarrassed.

Neither, because it has nothing to do with you or your question. It's what happens on any newsgroup, whatever the thread, when someone wants to show how "clever" they are by supplying crappy answers -and then refuses to acknowledge the crappiness of their answer.

>You would have thought that I
> started a religious war by stating that DB2 rocks (but that's for
> another day).

It was Ron that started this, firstly by not understanding your post properly and secondly by thinking he could show how clever he was and how stupid I was not to have mentioned a recovery technique which had no applicability to your situation.

> Anyway, there were good comments on all sides here.

"all sides" is a tad generous in this case, I think.

> My data
> partition got trashed. From what I read from the Oracle docs,
> disaster recovery is not possible without autobackups of the control
> files. That was pointed out here.

Not by me it wasn't. As I said in a reply to you, autobackup just means that the control file is backed up even when file 1 is not included in the backup job. But control files are always included, whether autobackup is on or not, if file 1 is touched by the backup job. And you said in your original post that you performed full and incremental backups, so it was obvious you did have control files somewhere.

> I naively created a new db and thought I could copy the user
> stuff into it. This is a development db so if a few things got lost
> it was no big deal.

Be careful with words like "This". You mean, I think, the original, trashed database was a development db, so data loss was bearable. Not that the newly-created db was a development db. Ron will want to believe the second interpretation.

>Somebody should have said (and in so many words
> they did) "Hey nimrod, that's a bassackwards way to recover your data.
> Keep poking around in your backups - the control files are there,
> they're just shy about announcing themselves." Well, that's true.
> I don't know why Oracle is so obtuse about finding your
> control files and putting things back together again.

Whilst I sort of agree with you, bear in mind that you aren't ever supposed to lose *all* your control files. That's why multiplexing was invented!

> Now let's all have a group hug and grab a beer.

I'll happily hug anyone, when they finally acknowledge mistakes of the magnitude that have been made here. A certain regular on this group can attest to that, over a small matter concerning the system rollback segment. Ron could attest to it too if he tried a bit harder. Like, at all.

Regards
HJR Received on Thu Feb 19 2004 - 18:46:09 CST