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.