Home » RDBMS Server » Backup & Recovery » Can not recover file (11.2.0.3, RHEL5)
Can not recover file [message #602629] Fri, 06 December 2013 02:08 Go to next message
cmavroid
Messages: 2
Registered: December 2011
Location: Greece
Junior Member
Dear all,

We try to recover a file from a lost ASM diskgroup but while
execute below command, it fails with below message (trying to find lost diskgroup)

any suggestions??
RMAN> run
{
set newname for datafile 00001 to '+DATA2/system.266.803846367';
RESTORE datafile 0001 ;
SWITCH DATAFILE ALL;
}2> 3> 4> 5> 6>

executing command: SET NEWNAME

Starting restore at 04-DEC-13
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATA2/system.266.803846367
channel ORA_DISK_1: reading from backup piece /backups/databases/QEWTEST/dbf_level0_520_1_821119826


channel ORA_DISK_1: ORA-19870: error while restoring backup piece /backups/databases/QEWTEST/dbf_level0_520_1_821119826
ORA-19504: failed to create file "+DATA"
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15001: diskgroup "DATA" does not exist or is not mounted
Re: Can not recover file [message #602631 is a reply to message #602629] Fri, 06 December 2013 02:11 Go to previous messageGo to next message
John Watson
Messages: 4081
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and please read How to use [code] tags and make your code easier to read


You say +DATA at one point, and +DATA2 at another. which is it?
Re: Can not recover file [message #602639 is a reply to message #602631] Fri, 06 December 2013 03:59 Go to previous messageGo to next message
cmavroid
Messages: 2
Registered: December 2011
Location: Greece
Junior Member
Thank you for the welcome i will read guides asap

+DATA2 is the new diskgroup we want to restore. +DATA is lost..
Re: Can not recover file [message #602646 is a reply to message #602639] Fri, 06 December 2013 04:48 Go to previous message
John Watson
Messages: 4081
Registered: January 2010
Location: Global Village
Senior Member
I think your problem is that you are trying to specify a full filename in your SET NEWNAME command, and you can't do that: ASM will always want to assign the the file number and the incarnation number itself, which may change every time you move or restore a file. This is why you should always use file aliases, which are stable. Try this:
{set newname for datafile 1 to '+DATA2';
restore datafile 1;}
Then in SQL*Plus, rename the file to whatever filename was generated by ASM during the restore.
Previous Topic: ORA-1688: unable to extend table in SYSAUX tablespace
Next Topic: Error in logging in
Goto Forum:
  


Current Time: Thu Apr 17 09:21:11 CDT 2014

Total time taken to generate the page: 0.18181 seconds