ORA-19698 error in the recovery of an rman heterogeneous machine

Source: Internet
Author: User
Tags backup

Experimental environment:

Operating system: Oracle Linux Server release 5.7 bit

Database version: Oracle 10g release 10.2.0.4.0-64bit Production

Case Description:

To test and verify the validity of the backup, you need to restore the backup set of the database on server A to Server B, the ORACLE_SID and DB name of the same name have been created on Server B, and the corresponding data file directory environment is exactly the same

Step 1:startup Nomount

Step 2:restore SPFile

Step 3:restore Controlfile

Step 4:startup Mount;

Step 5:restore Database

Step 6:recover Database

Because the DBID was not forgotten when the Rman restore was performed, the result is recover database times ORA-19698:/u01/oradata/scm2/redo01.log is from different database:id= 4146921064, db_name=scm2

rman> Recover database;

Starting recover at 14-may-14

Using channel Ora_disk_1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR message STACK follows ===============

RMAN-00571: ===========================================================

Rman-03002:failure of recover command at 05/14/2014 10:15:30

ORA-19698:/u01/oradata/scm2/redo01.log is from different database:id=4146921064, db_name=scm2

At this point, you need to delete the redo log file, the result in Sqlplus delete redo log file, encountered the following series of problems. In fact, it is much easier to delete redo log files directly using the RM command.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.