OraFAQ Forum: Backup & Recovery » Restoring database from full export backup

Home » RDBMS Server » Backup & Recovery » Restoring database from full export backup (Oracle 10.2.0.3 on Solaris 8)

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

Restoring database from full export backup [message #376000]

Mon, 15 December 2008 11:11

orausern
Messages: 826
Registered: December 2005

Senior Member

Hi ,

I have a question about the procedure to restore a db if there in only full export backup (and control file backup). What are the steps to be followed in this scenario?

Thanks
Nirav

Report message to a moderator

Re: Restoring database from full export backup [message #376002 is a reply to message #376000]

Mon, 15 December 2008 11:14

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can't restore from an export. This is the reason and export is NOT a backup.

Regards
Michel

[Updated on: Mon, 15 December 2008 11:14]

Report message to a moderator

Re: Restoring database from full export backup [message #376003 is a reply to message #376002]

Mon, 15 December 2008 11:16

orausern
Messages: 826
Registered: December 2005

Senior Member

yes but suppose all we have is just full db export and a control file backup to trace then what can be done get back the database- to the extent possible.

Report message to a moderator

Re: Restoring database from full export backup [message #376004 is a reply to message #376003]

Mon, 15 December 2008 11:22

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

You create a new, empty database and just import (i prefer schema-by-schema).
Traced controlfile is not of much importance (may be you can recreate the tablespace/control file/redologs with same name/location/size).
Same information can be obtained from the exported dump itself(well, not about control files/redologs).
You can get list of tablespace/users and their tablespace affiliations/grants etc.

I would rather have a copy of init.ora and my SLA Smile

[Updated on: Mon, 15 December 2008 11:23]

Report message to a moderator

Re: Restoring database from full export backup [message #376006 is a reply to message #376004]

Mon, 15 December 2008 11:26

orausern
Messages: 826
Registered: December 2005

Senior Member

Thank you Mahesh,Michel! this helps me a lot.

Report message to a moderator

Previous Topic:	A question about cold backup
Next Topic:	deleting the flashback recovery area and the files

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 04 20:32:57 CDT 2024