在rman中执行备份恢复,我们从restore database之后一步步探索,我接着执行了如下语句:
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 04/22/2012 20:28:21
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
当然我们会按照提示接着执行:
RMAN> alter database open resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 04/22/2012 20:28:35
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/system01.dbf'
伤心的是又会报如上的错误。解决方法:在执行完restore database之后我们要做的是:
RMAN>recover database;
RMAN> alter database open resetlogs;这样就恢复数据库完毕了,当然resetlogs后不要忘记重新做一次数据库备份。
因为restore 还原,是将文件从备份集还原到相应位置,
recover 恢复,将还原的文件同步。
所以仅仅执行restore时会报错数据文件没有完全从旧的备份中进行还原。
以上个人总结如果有误或者不足,希望大家指出