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
A restore job of an Oracle database fails with the above error during a disaster recovery of the Oracle database. (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"
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.