OraFAQ Forum: Enterprise Manager » How to Restore Dropped Tablespace?

Home » RDBMS Server » Enterprise Manager » How to Restore Dropped Tablespace?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to Restore Dropped Tablespace? [message #244210]

Tue, 12 June 2007 00:17

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

I have backup of full databases. Now I dropped two tablespaces. How I can restore and recover it these two tablespaces without whole database shutdown.

I tried
---
restore database until time to_......
recover database until time to_.......
-----
then show msg datafile 7 already restore. I need two tablespaces and include it the two datafiles are datafile 6 and datfile 2.

Whenever I give command like
-----restore datafile 6 until time "to_date('2007-06-12 04:47:19', 'YYYY-MM-DD HH24:MI:SS')";
------
then RMAN-03002: failure of restore command at 06/12/2007 11:11:40
RMAN-20201: datafile not found in the recovery catalog
RMAN-06010: error while looking up datafile: 6

If I use
--
restore tablespace data02 until time "to_date('2007-06-12 04:47:19', 'YYYY-MM-DD HH24:MI:SS')";
---
then also
RMAN-20202: tablespace not found in the recovery catalog

Now please give me suggestion how I can perform this two tablespace backed up to prior time with Oracle Enterprise manager
through object level recovery as well as making database shut down.

Report message to a moderator

Re: How to Restore Dropped Tablespace? [message #244214 is a reply to message #244210]

Tue, 12 June 2007 00:49

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can't restore your tablespaces in a time which different from the database time.

You have to restore the whole database (or at least the SYSTEM, UNDO and your tablespaces) in another place and recover it just before the drop, export the objects inside these tablespaces.
Then you recreate (empty) the tablespaces in your original db and reimport the objects.

Regards
Michel

Report message to a moderator

Re: How to Restore Dropped Tablespace? [message #244226 is a reply to message #244210]

Tue, 12 June 2007 01:40

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Can you please give me step by step solution?

Whenever I want to restore from EM using "Perform Object Level Recovery" then the tablespace name is not shown.

Now I created a blank tablespace and then wanted restore data imported into it. But at last it show me msg
----
RMAN-20202: tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "DATA02"
----

Report message to a moderator

Re: How to Restore Dropped Tablespace? [message #244235 is a reply to message #244226]

Tue, 12 June 2007 02:03

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I don't know and use EM.
If is a EM specific question, I move this topic to EM forum.

Regards
Michel

Report message to a moderator

Re: How to Restore Dropped Tablespace? [message #244237 is a reply to message #244210]

Tue, 12 June 2007 02:17

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Ok Michel If I dont use EM then how I step by step can recover my two tablespaces through rman command line ...

Report message to a moderator

Re: How to Restore Dropped Tablespace? [message #244245 is a reply to message #244237]

Tue, 12 June 2007 02:44

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Backup and Recovery Advanced User's Guide, Chapter 8 RMAN Tablespace Point-in-Time Recovery (TSPITR)

Regards
Michel

Report message to a moderator

Previous Topic:	Oracle 10g admin pages non-functional
Next Topic:	OEM Crashed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 03 23:12:06 CDT 2025