Restoring database from full export backup [message #376000] |
Mon, 15 December 2008 11:11 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #376004 is a reply to message #376003] |
Mon, 15 December 2008 11:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/42800.jpg) |
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](images/smiley_icons/icon_smile.gif)
[Updated on: Mon, 15 December 2008 11:23] Report message to a moderator
|
|
|
|