| Can not recover file [message #602629] |
Fri, 06 December 2013 02:08  |
 |
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 #602646 is a reply to message #602639] |
Fri, 06 December 2013 04:48  |
John Watson
Messages: 8964
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
