Home » RDBMS Server » Backup & Recovery » Rman recovery its urgent
Rman recovery its urgent [message #253989] Wed, 25 July 2007 07:54 Go to next message
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
Re: Rman recovery its urgent [message #253999 is a reply to message #253989] Wed, 25 July 2007 08:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
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
Re: Rman recovery its urgent [message #254001 is a reply to message #253999] Wed, 25 July 2007 08:12 Go to previous messageGo to next message
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
Re: Rman recovery its urgent [message #254010 is a reply to message #254001] Wed, 25 July 2007 08:41 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
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
Re: Rman recovery its urgent [message #254012 is a reply to message #254010] Wed, 25 July 2007 08:52 Go to previous messageGo to next message
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
Re: Rman recovery its urgent [message #254024 is a reply to message #254012] Wed, 25 July 2007 09:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please format.

Regards
Michel
Re: Rman recovery its urgent [message #254025 is a reply to message #254024] Wed, 25 July 2007 09:51 Go to previous message
aslamkhalife
Messages: 42
Registered: July 2007
Location: India
Member
Thanks

I got the solution for that Querry

Thanks a lot for guiding me
thanks once again
Previous Topic: RMAN - ORA-19513 et ORA-27206
Next Topic: How Can Get Which Backup unnesessary to Delete Using RMAN
Goto Forum:
  


Current Time: Sun Dec 11 02:00:46 CST 2016

Total time taken to generate the page: 0.10310 seconds