OraFAQ Forum: Backup & Recovery

Home » RDBMS Server » Backup & Recovery » recover dbf

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: recover dbf [message #409313 is a reply to message #409302]

Mon, 22 June 2009 02:12

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Just open it.

Regards
Michel

Report message to a moderator

Re: recover dbf [message #409316 is a reply to message #409302]

Mon, 22 June 2009 02:18

maher534510
Messages: 25
Registered: September 2008
Location: jordan

Junior Member

how ?????????

Report message to a moderator

Re: recover dbf [message #409325 is a reply to message #409316]

Mon, 22 June 2009 03:00

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

sqlplus / as sysdba
startup

Regards
Michel

Report message to a moderator

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

Report message to a moderator

Re: recover dbf [message #409335 is a reply to message #409329]

Mon, 22 June 2009 03:33

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Startup mount, change names with alter database, then open.

Regards
Michel

Report message to a moderator

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 ?

Report message to a moderator

Re: recover dbf [message #409350 is a reply to message #409339]

Mon, 22 June 2009 04:31

Michel Cadot
Messages: 68645
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

Report message to a moderator

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

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 08:22:42 CDT 2024