Re: rman recover/restore from backup

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.

Regards,

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

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:403a1cb6$0$10334$ed9e5944_at_reading.news.pipex.net...
> "Ron" <support_at_dbainfopower.com> wrote in message
> news:lbydnQ3ONZChKKTdRVn-gw_at_comcast.com...
> >
> > > I think you should have just pleaded the 5th.
> >
> > I just merely gave you a way to do what you declared impossible multiple
> > times in multiple messages.
>
> Howard never said that TSPITR was impossible, just that *in this
particular
> instance* it was , to put it charitably, somewhat daft. I'm not sure if
DBA
> Infopower does outsourced DBA work or whatever, but I'd be a bit worried
as
> a client if the DBA in charge of my database recovered it fully from
backup
> and then rather than letting me carry on working proceded to keep me out
of
> the database whilst they performed TSPITR from that working database to a
> second database. I'm sure that you can provide reasons why one might want
to
> do that, since you suggested that it was the best course of action. I'm
also
> curious as to what point in time you would choose to recover to since it
> would appear that not only are you keeping me out of a recovered database
> for no apparent reason, but having done full recovery you are then
proposing
> to only give me a database with some data loss.
>
> Incidentally if you are curious as to when this approach (deliberately
> imposing data loss on a backup ) might be necessary there is a handy guide
> available at http://tinyurl.com/26gme you will note that the author of
this
> advice read the business requirements of the poster before offering
> technically accurate and pertinent advice.
>
> cheers
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
>
>
Received on Mon Feb 23 2004 - 13:34:34 CST