Home » RDBMS Server » Enterprise Manager » How to Restore Dropped Tablespace?
How to Restore Dropped Tablespace? [message #244210] Tue, 12 June 2007 00:17 Go to next message
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.


Re: How to Restore Dropped Tablespace? [message #244214 is a reply to message #244210] Tue, 12 June 2007 00:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64108
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: How to Restore Dropped Tablespace? [message #244226 is a reply to message #244210] Tue, 12 June 2007 01:40 Go to previous messageGo to next message
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"
----
Re: How to Restore Dropped Tablespace? [message #244235 is a reply to message #244226] Tue, 12 June 2007 02:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64108
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: How to Restore Dropped Tablespace? [message #244237 is a reply to message #244210] Tue, 12 June 2007 02:17 Go to previous messageGo to next message
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 ...
Re: How to Restore Dropped Tablespace? [message #244245 is a reply to message #244237] Tue, 12 June 2007 02:44 Go to previous message
Michel Cadot
Messages: 64108
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Backup and Recovery Advanced User's Guide, Chapter 8 RMAN Tablespace Point-in-Time Recovery (TSPITR)

Regards
Michel
Previous Topic: Oracle 10g admin pages non-functional
Next Topic: OEM Crashed
Goto Forum:
  


Current Time: Mon Dec 05 05:10:44 CST 2016

Total time taken to generate the page: 0.19089 seconds