Re: rman recover/restore from backup

Hello Howard,

  Here is the user request.

>>>>>>

"After creating a new partition for the data files, I ran dbca to create new database files.

  I would like to get the users tablespace stuff out of the backups and put it into the new database that was created by dbca. ..

Is there not some way to basically take the .bck files, extract the users tablespace and put it into the existing database? "
>>>>>>>

  Please, please, lets stop this.

  I corrected you, so please, accept this.

Regards,

  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:402ee38b$0$4249$afc38c87_at_news.optusnet.com.au...
>
> "Ron" <support_at_dbainfopower.com> wrote in message
> news:vuudndByk5zpf7PdRVn-hw_at_comcast.com...
> >
> > Hello Howard,
> >
> > Being able to get USERS tablespace to the new database is exactly what
> > user requested.
>
> No, he requested advice on how to recover a tablespace when he has full
RMAN
> backups, some incrementals, but not the latest ones because they were open
> at the time of failure. TSPITR has no relevance to the problem he actually
> described.
>
> If he wants to move USERS across to the new database when he's got it back
> up and running, then that's up to him. But it wouldn't be a TSPITR at that
> point.
>
> > The advice you offered to him was to dump his database and start
reading
> > documentation.
> >
> > How nice of you!
>
> I try.
> HJR
>
>
Received on Sat Feb 14 2004 - 21:28:27 CST