| recover dbf [message #409302] |
Mon, 22 June 2009 01:32  |
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 #409329 is a reply to message #409302] |
Mon, 22 June 2009 03:25  |
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 #409339 is a reply to message #409302] |
Mon, 22 June 2009 03:42 |
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 #409453 is a reply to message #409350] |
Mon, 22 June 2009 15:36 |
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 |
babuknb
Messages: 1736
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 |
 |
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
