Home » RDBMS Server » Backup & Recovery » Restoring database from full export backup (Oracle 10.2.0.3 on Solaris 8)
Restoring database from full export backup [message #376000] Mon, 15 December 2008 11:11 Go to next message
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
Re: Restoring database from full export backup [message #376002 is a reply to message #376000] Mon, 15 December 2008 11:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
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 Go to previous messageGo to next message
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.
Re: Restoring database from full export backup [message #376004 is a reply to message #376003] Mon, 15 December 2008 11:22 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
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 Go to previous message
orausern
Messages: 826
Registered: December 2005
Senior Member
Thank you Mahesh,Michel! this helps me a lot.
Previous Topic: A question about cold backup
Next Topic: deleting the flashback recovery area and the files
Goto Forum:
  


Current Time: Wed Nov 13 07:03:54 CST 2024