Home » RDBMS Server » Backup & Recovery » Restore schema (Oracle 10.2.0.3)
Restore schema [message #522523] Sun, 11 September 2011 13:17 Go to next message
Its_me_ved
Messages: 979
Registered: October 2009
Location: India
Senior Member
Is there a way to restore the schema and its associated objects once it is dropped?

1. The flash back database feature is not ON in the database where schema was dropped.
2. The data files/ table space has not been dropped
3. There was no export taken for the schema.


Regards,
Ved
Re: Restore schema [message #522524 is a reply to message #522523] Sun, 11 September 2011 13:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68050
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to restore and recover the database in another place (at least the system and schema tablespaces), export the schema and reimport it in the original database.

Regards
Michel
Re: Restore schema [message #522525 is a reply to message #522524] Sun, 11 September 2011 13:31 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8922
Registered: November 2002
Location: California, USA
Senior Member
I have never been a DBA, so this may or may not help, but the documentation seems to say that you can use "tablespace point-in-time recovery" to "Recover one independent schema ...".

http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/backrec.htm#i1012545
Re: Restore schema [message #522637 is a reply to message #522525] Tue, 13 September 2011 00:52 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Hi,
Are there a way to restore a schema only?
Re: Restore schema [message #522646 is a reply to message #522637] Tue, 13 September 2011 01:20 Go to previous message
Michel Cadot
Messages: 68050
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Sun, 11 September 2011 20:22
You have to restore and recover the database in another place (at least the system and schema tablespaces), export the schema and reimport it in the original database.

Regards
Michel

Previous Topic: block change tracking file
Next Topic: Has my database ever been restored ?
Goto Forum:
  


Current Time: Mon Dec 06 23:30:04 CST 2021