Home » RDBMS Server » Backup & Recovery » recover dbf
recover dbf [message #409302] Mon, 22 June 2009 01:32 Go to next message
maher534510
Messages: 25
Registered: September 2008
Location: jordan
Junior Member
my database corrupted and i was uninstall it
but i was save my datafile in another location
now i install new database and i want to recover my datafiles
Re: recover dbf [message #409313 is a reply to message #409302] Mon, 22 June 2009 02:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just open it.

Regards
Michel
Re: recover dbf [message #409316 is a reply to message #409302] Mon, 22 June 2009 02:18 Go to previous messageGo to next message
maher534510
Messages: 25
Registered: September 2008
Location: jordan
Junior Member
how ?????????
Re: recover dbf [message #409325 is a reply to message #409316] Mon, 22 June 2009 03:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sqlplus / as sysdba
startup

Regards
Michel
Re: recover dbf [message #409329 is a reply to message #409302] Mon, 22 June 2009 03:25 Go to previous messageGo to next message
maher534510
Messages: 25
Registered: September 2008
Location: jordan
Junior Member
my old oradata (dbf) in partition d:
now my new database in c:
i want to recover dbf in partition d:\ to c:
recover my old data files
Re: recover dbf [message #409335 is a reply to message #409329] Mon, 22 June 2009 03:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Startup mount, change names with alter database, then open.

Regards
Michel
Re: recover dbf [message #409339 is a reply to message #409302] Mon, 22 June 2009 03:42 Go to previous messageGo to next message
maher534510
Messages: 25
Registered: September 2008
Location: jordan
Junior Member
i'm developer not dba please give me the steps ???
i don't know what you are talking about i think this is dba subjects ?
Re: recover dbf [message #409350 is a reply to message #409339] Mon, 22 June 2009 04:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recovery is THE dba task.
It is not simple, you have to refer to your DBA to do this.

Regards
Michel
Re: recover dbf [message #409453 is a reply to message #409350] Mon, 22 June 2009 15:36 Go to previous messageGo to next message
igalshan
Messages: 1
Registered: June 2009
Location: San Jose
Junior Member
alter system switch logfile;
alter database backup controlfile to trace;

Change the line containing the database name

CREATE CONTROLFILE SET DATABASE "DBNAME" RESETLOGS NOARCHIVELOG

[Updated on: Tue, 23 June 2009 00:51] by Moderator

Report message to a moderator

Re: recover dbf [message #409454 is a reply to message #409453] Mon, 22 June 2009 15:41 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
alter system switch logfile;
alter database backup controlfile to trace;

Change the line containing the database name

CREATE CONTROLFILE SET DATABASE "DBNAME" RESETLOGS NOARCHIVELOG




The above steps necessary? check Mr Mic comments.

Thanks

[Updated on: Tue, 23 June 2009 00:51] by Moderator

Report message to a moderator

Re: recover dbf [message #409472 is a reply to message #409453] Mon, 22 June 2009 19:04 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
igalshan wrote on Mon, 22 June 2009 16:36
alter system switch logfile;
alter database backup controlfile to trace;

Change the line containing the database name

CREATE CONTROLFILE SET DATABASE "DBNAME" RESETLOGS NOARCHIVELOG

What on earth does this have to do with the price of rice ??

igalshan wrote on Mon, 22 June 2009 16:36

[Site link removed]

Guess it was a shameless plug to put your website in the post.

[Updated on: Tue, 23 June 2009 00:52] by Moderator

Report message to a moderator

Previous Topic: Unable to perform recovery from RMAN backup
Next Topic: recovery in stndby
Goto Forum:
  


Current Time: Thu Dec 08 14:28:53 CST 2016

Total time taken to generate the page: 0.13065 seconds