Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: rman recover/restore from backup
On 16 Feb 2004 13:20:38 -0800, hjr_at_dizwell.com (Howard J. Rogers)
wrote:
>Joe Fischer <jfischer@__fischerhome__.org> wrote in message
>>
>> I'm sorry that I created such a fuss with my problem/question.
>> After reading through all of the posts, I deleted the new database and
>> was able to restore the control files from the RMAN backups and then
>> restore/recover everything else. So it looks like all is well, again.
>> It was not easy, but it seems to be running.
>> Thanks for the suggestions. Also sorry for not being clear on
>> what I was trying to do.
>> ------
>> Joe F.
>>
>
>Don't apologise, Joe. You were 100% clear on what you were trying to
>do, and you created no fuss at all. Such "fuss" as arose was due to
>the fact that Ron thinks he knows a lot, and doesn't -nothing actually
>to do with you or your posting at all.
>
>Glad you got it sorted, anyway.
>
>Regards
>HJR
Wow! 43 posts - not counting my own. I don't know if I
should be thrilled or embarrassed. You would have thought that I
started a religious war by stating that DB2 rocks (but that's for
another day).
Anyway, there were good comments on all sides here. 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.
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. 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.
Now let's all have a group hug and grab a beer.