全部博文(39)
分类: Oracle
2012-11-11 16:35:24
尝试recover数据库时遇到如下错误:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/11/2012 16:26:56
RMAN-20506: no backup of archivelog found
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 25963 lowscn 133798156821 found to restore
反复查看v$datafile和v$datafile_header视图,发现所有数据文件的checkpoint scn都比
133798156821大很多,这个scn是一个月前的;再查看通过catalog注册的archivelog,其scn
区间是我想要的。
最后尝试在sql*plus中recover,抛出当前控制文件是standby controlfile的错误,这才
找到真正的原因。
PS: rman报的错,有时真不能信。