1. Support
  2. Knowledge base
  3. 100031288

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

Article: 100031288
Last Published: 2015-10-15
Ratings: 1 0
Product(s): Backup Exec

Problem

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.

 

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"
 

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

  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.

 

 

Was this content helpful?

Article Languages