Backup Exec server-initiated restore does not support Oracle redirect restore of ASM database to an Oracle server (non ASM)

book

Article ID: 100032538

calendar_today

Updated On:

Description

Error Message


On Backup Exec 2012 and prior versions:
Backup Exec server-initiated restore fails with error "0xe0000340 - The Database script returned an error"
Please see article 000012361


On Backup Exec 2014 and later versions:
Backup Exec server-initiated restore succeeds without any error but Oracle database cannot be opened and reports a data file error. Data file error example:
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '+DATA/orcl/datafile/system.256.878531449'
 
This is because only the control files have been restored.

 

Cause

This is because the underlying file structure of an ASM configured Oracle database and a non ASM Oracle database is different.

Resolution

Use RMAN to create a 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:

Issue/Introduction

Backup Exec server-initiated restore does not support Oracle redirect restore of ASM database to an Oracle server (non ASM).
The same limitation applies for a redirect restore of a non ASM Oracle database to an ASM Oracle database.

Additional Information

ETrack: 3782587
Powered by Wolken Software