Oracle database restore fails with The Database script returned an error

Article:TECH56105  |  Created: 2007-01-11  |  Updated: 2014-05-14  |  Article URL http://www.symantec.com/docs/TECH56105
Article Type
Technical Solution

Product(s)

Issue



An Oracle database restore fails with the error "0xe0000340 - The Database script returned an error. Refer to the Database script output section in job logs for more details" when performing an Oracle Database disaster recovery

 


Error



A restore job of an Oracle database fails with the above error during a disaster recovery of the Oracle database. (Figure 1)
 
Figure 1
 
 
 
 
 

 
Additionally, the restore job log reports the following error:
 
"RMAN-03002: failure of recover command at 12:00:55
 
ORA-19698: F:\ORACLE\PRODUCT\10.1.0\ORADATA\TESTDB1\REDO01.LOG is from different database: id=4011070094, db_name=TESTDB1"
 

Solution



If the error "ORA-19698: %s is from different database: id=string, db_name=string" is seen during an Oracle disaster recovery operation, perform the following:
 
1. Bring the database to nomount state (Steps mentioned below):

At a command prompt, type the following command: SQLplus / as SYSDBA

type shutdown immediate;

type startup nomount;
 
2. Empty the contents of the directory (under the oradata directory) containing the data files and online redo logs of the newly created database.
 
3. Re-try the control file restore operation.
 

Supplemental Materials

SourceETrack
Value1170994
Description

Oracle: Database disaster recovery (restore) jobs are failing.


SourceError Code
Value0xe0000340
Description

The Database script returned an error. Refer to the Database script output section in job logs for more details



Legacy ID



294882


Article URL http://www.symantec.com/docs/TECH56105


Terms of use for this information are found in Legal Notices