Oracle redirect restore of Oracle ASM database to different Oracle Server (Non ASM) fails with the error "0xe0000340 - The Database script returned an error".
Article ID: 100005406
Updated On:
Description
Error Message
RMAN output reports the following error;
ORA-19870: error reading backup piece BE_02m47n3f_1_1
ORA-19504: failed to create file "+DG_DATA"
ORA-17502: ksfdcre:4 Failed to create file +DG_DATA
ORA-15001: diskgroup "DG_DATA" does not exist or is not mounted
ORA-15077: could not locate ASM instance serving a required diskgroup
Cause
This issue occurs as the Server Initiatied restore job runs a script that looks for ASM disk group on the target server.
Resolution
Workaround:
Use RMAN based DBA-Initiated restore to restore the database.
1. Connect to RMAN on the target server.
2. Refer the RMAN output of the failed restore job and modify the script to change the restore command.
3. Change the script and use "SET NEWNAME" command and specify path\location on the target server.
4. To restore DATAFILE the command would be "SET NEWNAME FOR DATAFILE" followed by file number and the path where the file is to be restored. For more information related to the "SET NEWNAME" command refer the following documents from Oracle.
download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#i1006629
download.oracle.com/docs/cd/B14117_01/server.101/b10734/rcmdupdb.htm
Note:- Restore of ASM database to an Oracle Server (Non ASM) is currently not supported.
Issue/Introduction
Additional Information
