Re: rman recover/restore from backup

Hi again Richard as well,

  Enjoying your posts probably as much as you mine ;-).

  If you'll read user's post again you can very clearly (unless you don't want to) read that users asking (TWICE) for a way of moving tablespace to the new database.

  TSPIRT is the exact, ORACLE recommended way to do this - want to argue? (then refer to Oracle docs first)

  Mr. Howard advised user to dump his new database and read docs on recovery. Yes - user was able to recover database following Mr. Howard's advice. No questions about that. He would have the same success bringing tablespace back using TSPIRT, if he would follow my advice.

  In a process of recovery however, he probably wiped out newly created database.

   Being a real (not paper) Oracle DBA answer that - is this what you would do or advise anyone to do in production environment for a production database? Where you think your users or manager's patience and professional trust ends?

     If this is not your toy desktop database - Time to recovery is critical. Database recovered (or recreated as in this case) - schemas recreated, data loaded and applications and users connects and start working. Dare to touch it again?

   My advice was attempt to help real DBA to resolve real life problem, not to exercise Oracle lab recovery exercise

  Sorry you totally missed that.

  So much for your irony. Hope you enjoyed it.

Regards,

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

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:JR0Zb.66604$Wa.61759_at_news-server.bigpond.net.au...
> "Ron" <support_at_dbainfopower.com> wrote in message
> news:P6udnZcoxsT0oqndRVn-gQ_at_comcast.com...
> >
> > As usual - unreasonable personal accusations and facts twisting.
> >
> > Mr Howard probably hopes that no one would read original post.
>
> Hi again Ron,
>
> I've really enjoyed catching up with your antics on this thread, very very
> amusing. Thanks heaps.
>
> I've actually *read* the original post, read the various pieces of
"advice"
> and I've come to a rather convincing conclusion. That you my friend have
> *no* idea. None. Zero. Zip. Nada.
>
> Lets look at the facts.
>
> 1) OP describes a scenario whereby he has a perfectly reasonable backup
less
> control files
>
> 2) OP can therefore recreate his control files and fully recover his
> database with RMAN
>
> 3) OP is clearly inexperienced and has gone down the wrong path by
> unnecessarily creating a second DB into which he wishes to "copy across"
his
> required data from the first, fully recoverable database.
>
> 4) Howard gives OP sound advice on how to recover his *original* database
> *completely* without the need for a second database, without the need for
a
> point in time recovery, without the need of losing any data.
>
> 5) You recommend pursuing the *second* database technique and *partially*
> recovering a *specific* tablespace. In your rush to read up the recovery
> manuals and discovering that there's a TSPITR option, you've clearly
focused
> too much on the *Tablespace* portion and not enough on the *Point In Time*
> bit.
>
> 6) Your advice is therefore clearly not appropriate, a bad option and
> results in a infinitely inferior solution as the OP requires a second
> database (unnecessarily), loss of all data outside of tablespaces
recovered
> (unnecessarily), loss of all data after the specified point of time in the
> selected tablespaces (unnecessarily)
>
> 7) The OP thankfully follows Howard's advice and *fully* recovers his
> original database, thankfully without following any of your suggestions
>
> 8) You take all the credit
>
> 9) You attack Howard as being "reckless" with"disregard for all safe-guard
> rules" !!
>
> I think that about sums this thread up. Like I said, it's hilarious !!
>
> >
> > Mr Howard. is welcome for continue. For me - enough.
>
> Howard, please do continue and Ron, please please please please follow
> through with this as many others I'm sure think it's enough as well. Ron,
> you have proven yourself undoubtable, I can't remember anyone who's
> embarrassed themselves more.
>
> Will DBA Infopower recover, (unlike the OP's database) from your
> contributions, I doubt it. What DBA Infopower requires is a DBAPITR,
> sometime just prior to you joining them.
>
> Has it really been 15 years, gee how time flies ....
>
> Richard
>
>
Received on Thu Feb 19 2004 - 12:56:00 CST