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: Ron <support_at_dbainfopower.com>
Date: Fri, 20 Feb 2004 00:32:05 -0800
Message-ID: <-KGdncM7hf_oWajd4p2dnA@comcast.com>

Hello Joe,

 Sorry for all the mess. I was trying to stop from the beginning.

 I think this is more related to personality of Mr. Howard that to the technical question.

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"Joe Fischer" <jfischer@__fischerhome__.org> wrote in message news:e7ja3013jeo7dm2t6tc9td5u7qgc8bucpk_at_4ax.com...
> 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.
> -------
> Remove underscores from e-mail address.
Received on Fri Feb 20 2004 - 02:32:05 CST

Original text of this message

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