Home » RDBMS Server » Backup & Recovery » recorvery DBF file (solaris 10,oracle 11g )
recorvery DBF file [message #549625] Mon, 02 April 2012 09:38 Go to next message
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 #549627 is a reply to message #549625] Mon, 02 April 2012 09:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>I locate dbf file from backup media.
you do not restore a single data file.

Tell us more about what you have & what happened?
Re: recorvery DBF file [message #549628 is a reply to message #549625] Mon, 02 April 2012 09:41 Go to previous messageGo to next message
John Watson
Messages: 8922
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 messageGo to next message
John Watson
Messages: 8922
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 #549633 is a reply to message #549630] Mon, 02 April 2012 10:12 Go to previous messageGo to next message
koff10
Messages: 58
Registered: December 2006
Location: france
Member
How to restore the "entire database to a new location ?
It's noarchivelog and cold backup database.

[EDITED by LF: removed unnecessary quote of the whole previous message]

[Updated on: Mon, 21 May 2012 15:40] by Moderator

Report message to a moderator

Re: recorvery DBF file [message #549635 is a reply to message #549633] Mon, 02 April 2012 10:21 Go to previous messageGo to next message
John Watson
Messages: 8922
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 #555055 is a reply to message #549635] Mon, 21 May 2012 02:41 Go to previous messageGo to next message
forafzal
Messages: 3
Registered: April 2012
Junior Member
you can recover a schema without a backup.
in your scenario only last export using exp command is valid or last cold backup
Re: recorvery DBF file [message #555067 is a reply to message #555055] Mon, 21 May 2012 03:33 Go to previous message
Michel Cadot
Messages: 68624
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

Previous Topic: Restore Control File from Backup
Next Topic: RMAN Backups
Goto Forum:
  


Current Time: Thu Mar 28 09:45:04 CDT 2024