Re: Tablespace dropped - Recovery Scenario ?

  • From: Prem <premjhere@xxxxxxxxx>
  • To: Eric Buddelmeijer <Eric.Buddelmeijer@xxxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 25 May 2005 18:21:06 +0530

Thanks Eric.

let me confirm :  nothing can be done on PROD as such.
                        and the only possible way is as i mentioned in
                        my first mail . isn't it ?
Regards,
Prem.

On 5/25/05, Eric Buddelmeijer <Eric.Buddelmeijer@xxxxxxxxxx> wrote:
> Been there, done that. :-(
> You can use transportable tablespaces as long as you restore the second
> server to the same OS in 9i. (rman probably won't work with another os fo=
r
> this purpose as well). And you only have to restore the deleted tablespac=
es,
> system ts and undo ts. TTS is a lot faster than export/import most of the
> time.
--
//www.freelists.org/webpage/oracle-l

Other related posts: