OraFAQ Forum: Backup & Recovery » how to recover tablespace non system tablespace (merged)

Home » RDBMS Server » Backup & Recovery » how to recover tablespace non system tablespace (merged)

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

how to recover tablespace non system tablespace (merged) [message #317740]

Fri, 02 May 2008 23:24

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

Report message to a moderator

how to recover tablespace non system tablespace [message #317741 is a reply to message #317740]

Fri, 02 May 2008 23:26

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

Report message to a moderator

Re: how to recover tablespace non system tablespace [message #317744 is a reply to message #317741]

Sat, 03 May 2008 00:06

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.

Report message to a moderator

Re: how to recover tablespace non system tablespace [message #317750 is a reply to message #317741]

Sat, 03 May 2008 01:14

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 15 00:08:21 CST 2025