Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Tablespace dropped - Recovery Scenario ?
Hi Prem,
You can also try a tablespace point in time recovery. I personally would not do that until I had some scripts that would do that for me before I would do it in a production environment. Tested and all. From your question, I gather you do not have those scripts. So if I where you, I would do it in a separate environment. You can even test the TTS procedure there if you have another database. Before trying that in a production environment.
Kind regards,
Eric.
-----Oorspronkelijk bericht-----
Van: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
Namens Prem
Verzonden: woensdag 25 mei 2005 14:51
Aan: Eric Buddelmeijer; ORACLE-L
Onderwerp: Re: Tablespace dropped - Recovery Scenario ?
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,
On 5/25/05, Eric Buddelmeijer <Eric.Buddelmeijer_at_elegant.nl> 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.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed May 25 2005 - 09:11:23 CDT
![]() |
![]() |