rac 10g 恢复到单机常见问题

RMAN> sql 'alter database mount';

sql statement: alter database mount

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

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

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

RMAN-03009: failure of sql command on default channel at 06/05/2015 18:15:14

RMAN-11003: failure during parse/execution of SQL statement: alter database mount

ORA-00201: control file version 10.2.0.5.0 incompatible with ORACLE version 10.2.0.0.0

ORA-00202: control file: '/u01/app/oracle/oradata/hisdb/control01.ctl'

恢复控制文件后强数据库启动到mount状态报错。

问题原因：修改生产环境参数文件的时候将*.compatible='10.2.0.5.0'参数删除了。实际启动的数据库compatible版本为10.2.0.1

解决方法：重新编辑pfile文件，将*.compatible='10.2.0.5.0'加进去

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

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

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

RMAN-03002: failure of switch command at 06/05/2015 22:02:40

ORA-19563:  header validation failed for file

问题原因：由于恢复的数据库目录和原数据库目录不同，使用set命令进行重置，出现文件名相同的情况

解决方法：检查要改名的数据文件，排除重名的文件。

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

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

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

RMAN-03002: failure of alter db command at 06/06/2015 11:26:02

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/u01/app/oracle/oradata/hisdb/datafile/system01.dbf'

问题原因：由于数据库恢复的时候出现异常，重新恢复的时候恢复到的时间点不一致，造成seq不相同。

解决方法：恢复的时候指定恢复时间点。