Oracle database restore fails with an error "RMAN-03002: failure of recover command"

book

Article ID: 100031288

calendar_today

Updated On:

Description

Error Message

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"
 

Resolution

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):

  2. At a command prompt, type the following command: SQLplus / as SYSDBA
    type shutdown immediate;
    type startup nomount;

  3. Empty the contents of the directory (under the oradata directory) containing the data files and online redo logs of the newly created database.

  4. Re-try the control file restore operation.

 

 

Issue/Introduction

An Oracle database restore fails with an 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.
Powered by Wolken Software