Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: Tablespace dropped - Recovery Scenario ?

RE: Re[2]: Tablespace dropped - Recovery Scenario ?

From: Eric Buddelmeijer <Eric.Buddelmeijer_at_elegant.nl>
Date: Wed, 25 May 2005 17:22:58 +0200
Message-Id: <20050525152302.SNHC19194.amsfep17-int.chello.nl@wst116>


Not been there, not done that.
I have been practising with recovery in another instance and then using tts to get them in the original database. Rman and TS PITR is precisely what I could not use and because of that have not had the change to try that. I hope others can help you there.
If you want my guess, I think TS PITR can be used because rman will know about your dropped tablespaces.

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 15:12
Aan: Eric Buddelmeijer
CC: ORACLE-L
Onderwerp: Re[2]: Tablespace dropped - Recovery Scenario ?

Hi Eric ,=20

since the tablespaces are dropped , the information about it will be =20 removed from the control file also . so , TSPITR is also ruled out on PROD as such . Please correct me if i'm wrong.

Thanks & Regards,
Prem.

On 5/25/05, Eric Buddelmeijer <Eric.Buddelmeijer_at_elegant.nl> wrote:
> 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
> gat=

her
> 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
> ha=

ve
> another database. Before trying that in a production environment.

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 25 2005 - 11:27:50 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US