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: Mon, 23 Feb 2004 16:55:00 -0800
Message-ID: <EuudndbsCrbTAqfdRVn-sQ@comcast.com>


"right, well what is now stopping him from simply recovering his original database?".

PRODUCTION database DOWNTIME should be as minimal as possible.

USER created NEW database and never told in his original message that it can be trashed as will.

Later user mentioned that it was REAL development database, with the REAL users - which is considered internal PRODUCTION database.

 And PRODUCTION database DOWNTIME should be as minimal as possible.

 Hope this is very clear.

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

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:14a1f766.0402231527.6d2d1b93_at_posting.google.com...
> "Ron" <support_at_dbainfopower.com> wrote in message
news:<v8Wdne2VW-GryafdRVn-vA_at_comcast.com>...
> > Hello Niall,
> >
> > I think you misunderstood the previous post - it was related to
ability
> > to restore objects from rman backuppieces without existing repository or
> > controlfile.
> >
>
> But you have misunderstood why I asked you the question in the first
> place. The metalink article you mentioned says that the *first* thing
> you must do is to extract your control file from an RMAN backup. Yes,
> it also goes on to explain how you can extract USERS from an RMAN
> backup. That's not in dispute, merely irrelevant.
>
> OK, Ron, I'll level with you: it was a trap. To the question "how does
> he extract USERS from his RMAN backups" you were supposed to answer
> (and did) "by first getting his control file out of the RMAN backups".
> As soon as you acknowledge that is the first step, you must then
> answer the question: "right, well what is now stopping him from simply
> recovering his original database?".
>
> And that's the point.
> HJR
Received on Mon Feb 23 2004 - 18:55:00 CST

Original text of this message

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