recorvery DBF file [message #549625] |
Mon, 02 April 2012 09:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
koff10
Messages: 58 Registered: December 2006 Location: france
|
Member |
|
|
Hi all,
I'm trying to restore an oracle schema on noarchivelog database.
I locate dbf file from backup media.
Do I need to shutdown the database before and use another control files ?
How do I proceed ?
thanks for help
koff
|
|
|
|
Re: recorvery DBF file [message #549628 is a reply to message #549625] |
Mon, 02 April 2012 09:41 ![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) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
In an Oracle database, a "schema" is the set of logical objects that are owned by a user. Are you using schema in this sense? Or are you using it in what I think is the SQL Server context, where a schema is a set of physical files?
|
|
|
Re: recorvery DBF file [message #549630 is a reply to message #549628] |
Mon, 02 April 2012 09:50 ![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) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Havong re-read, I think I understand: you want to "restore" one schema, ie, the user and all his objects?
You can't extract that from a datafile backup. I would think that your only option would be to restore the entire database to a new location, then export the schema and then import it into your live database.
|
|
|
|
Re: recorvery DBF file [message #549635 is a reply to message #549633] |
Mon, 02 April 2012 10:21 ![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) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
That would depend on how you made the backup.
If with RMAN, follow the usual routine for duplicating a database to a new location, as described in the docs.
If it is a user managed backup, restore it to the new location; edit the parameter file so that the instance can find the controlfile; startup mount; rename all the datafiles so that the controlfile can find them; open resetlogs.
Easy.
|
|
|
|
Re: recorvery DBF file [message #555067 is a reply to message #555055] |
Mon, 21 May 2012 03:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You cannot RECOVER from an export dump, you can just restore as it was at the time of this export.
In addition, OP did never say he has an export dump just a cold backup.
Regards
Michel
[Updated on: Mon, 21 May 2012 03:35] Report message to a moderator
|
|
|