OraFAQ Forum: Backup & Recovery » Rman recovery its urgent

Home » RDBMS Server » Backup & Recovery » Rman recovery its urgent

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

Rman recovery its urgent [message #253989]

Wed, 25 July 2007 07:54

aslamkhalife
Messages: 42
Registered: July 2007
Location: India

Member

Hi
I am getting error wrong file type while i am recovering the database

i got this error from V$RECOVER_FILE

please help me for this querry its very urgent

Report message to a moderator

Re: Rman recovery its urgent [message #253999 is a reply to message #253989]

Wed, 25 July 2007 08:05

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

Senior Member
Account Moderator

It is above all urgent that you give the necessary information like the version, the errors, the statements you execute and so on.

By the way, telling something is urgent in a forum is a good way to prevent me from helping.

Regards
Michel

Report message to a moderator

Re: Rman recovery its urgent [message #254001 is a reply to message #253999]

Wed, 25 July 2007 08:12

aslamkhalife
Messages: 42
Registered: July 2007
Location: India

Member

Sorry for inconvience

I was restoring the backup from rman
RMAN> restore backup;

at the end of process i encounter a error "WRONG FILE TYPE"

Version 10g Release 2

please guide for this its really urgent

and Sorry once again if any thing more let me know please

Report message to a moderator

Re: Rman recovery its urgent [message #254010 is a reply to message #254001]

Wed, 25 July 2007 08:41

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

Senior Member
Account Moderator

What about just copy and paste your screen or log instead of telling us what's inside?
Please read and follow How to format your posts

Regards
Michel

Report message to a moderator

Re: Rman recovery its urgent [message #254012 is a reply to message #254010]

Wed, 25 July 2007 08:52

aslamkhalife
Messages: 42
Registered: July 2007
Location: India

Member

I wont be able to copy paste the information

because I lost it that screen

I made the script as follow

run
{
set newname for datafile 1 to 'F:\oradata\prod\ASDPROD01.DBF';
set newname for datafile 2 to 'F:\oradata\prod\ASQPROD01.DBF';
set newname for datafile 3 to 'F:\oradata\prod\ASWPROD01.DBF';
set newname for datafile 4 to 'F:\oradata\prod\ASEPROD01.DBF';
set newname for datafile 5 to 'F:\oradata\prod\ASRPROD01.DBF';
set newname for datafile 6 to 'F:\oradata\prod\ASTPROD01.DBF';
set newname for datafile 7 to 'F:\oradata\prod\ASYPROD01.DBF';
recover database;
switch datafile all;
}
after this when i am trying to restore i am getting error
"RESTORE DATAFILE 2"

and i checked in
v$recover_file

i got "WRONG FILE TYPE"

please guide

Report message to a moderator