Home » RDBMS Server » Backup & Recovery » how to recover tablespace non system tablespace (merged)
how to recover tablespace non system tablespace (merged) [message #317740] Fri, 02 May 2008 23:24 Go to next message
reyazan
Messages: 53
Registered: February 2005
Member
i am using oralcle 9i enterprice server with redhat linux 4.
i have accedently drop a non system tablespace by command

drop tablespace name

how to recover a tablespace
pls reply
how to recover tablespace non system tablespace [message #317741 is a reply to message #317740] Fri, 02 May 2008 23:26 Go to previous messageGo to next message
reyazan
Messages: 53
Registered: February 2005
Member
i am using oralcle 9i enterprice server with redhat linux 4.
i have accedently drop a non system tablespace by command

drop tablespace name

how to recover a tablespace
pls reply
Re: how to recover tablespace non system tablespace [message #317744 is a reply to message #317741] Sat, 03 May 2008 00:06 Go to previous messageGo to next message
NandKumar
Messages: 92
Registered: June 2007
Location: v$hyderabad
Member
Do you have backup of that tablespace?

You may need to do a tablespace point in time recovery. Search Oracle RMAN documentation.

Re: how to recover tablespace non system tablespace [message #317750 is a reply to message #317741] Sat, 03 May 2008 01:14 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Either you don't care about transactions after the "drop tablespace" execution 
and you restore to the point in time just before this statement.

Either you care about them and you have to:
- in another place:
  * restore the database on another place just before the drop
  * export all tablespace objects
- in the original database
  * create a new tablespace
  * import the exported objects

Regards
Michel

[Updated on: Sat, 03 May 2008 01:26]

Report message to a moderator

Previous Topic: problem in rename datafiles after migration from ASM to non-ASM
Next Topic: ORA-19506: failed to create sequential file, name="arch_UDHSDPRD_653791067_1454_1", parms=
Goto Forum:
  


Current Time: Sun Dec 04 00:44:36 CST 2016

Total time taken to generate the page: 0.06031 seconds