| recorvery DBF file [message #549625] |
Mon, 02 April 2012 09:38  |
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  |
John Watson
Messages: 8964
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 |
John Watson
Messages: 8964
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 |
John Watson
Messages: 8964
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 |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
