Oracle database restore fails with The Database script returned an error

Problem

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 Message

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.
 

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)