xiaolongwu1987 2017-02-16 11:37 采纳率: 0%
浏览 1486

Rman为什么会尝试应用今天全库备份之前的归档呢?不是应该应用全库备份之后产生的归档吗?

我用Rman做了全库备份和归档日志备份,以下是备份:
arc_936057575_53_3762.arc 归档
arc_936068367_55_3763.arc
arc_936079186_60_3764.arc
arc_936089969_62_3765.arc
full_DAWH_20170216_1prsmkom_1_1 全库
full_DAWH_20170216_1qrsmkon_1_1
o1_mf_s_936068379_db998vw3_.bkp controlfile和spfile备份
o1_mf_s_936073797_db9gl5pw_.bkp
o1_mf_s_936079201_db9mv286_.bkp
o1_mf_s_936089985_db9yd1xo_.bkp
这是我今天中午为止这一天内产生的备份。
恢复的时候,先restore,然后recover的时候,
从下面会看出rman在找昨天的3761~3627的归档日志,而今天产生的3762~3765的归档却不应用。
3761~3627这段归档,是昨天的归档, 今天16号的归档只有3762~3765。
那么问题来了,restore了今天的全备,为什么recover的时候会去找做了全备之前的归档呢?

如果是因为controlfile太老了,那不是应该应用正确的归档把controlfile更新吗?怎么不应用正确的归档呢?

RMAN> recover database;

Starting recover at 16-FEB-17
using channel ORA_DISK_1

starting media recovery

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/DAWH/oradata/DAWH/system01.dbf'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/16/2017 17:53:20
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 3761 and starting SCN of 1320314801 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 3760 and starting SCN of 1320288564 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 3759 and starting SCN of 1320259166 found to restore
.........................................................
RMAN-06025: no backup of archived log for thread 1 with sequence 3672 and starting SCN of 1315631128 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 3671 and starting SCN of 1315503024 found to restore
..................................................
RMAN-06025: no backup of archived log for thread 1 with sequence 3629 and starting SCN of 1312028064 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 3628 and starting SCN of 1311948459 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 3627 and starting SCN of 1311875444 found to restore
RMAN-00567: Recovery Manager could not print some error messages

  • 写回答

2条回答 默认 最新

  • xiaolongwu1987 2017-02-16 11:45
    关注

    同问啊!!!!!!!

    评论

报告相同问题?

悬赏问题

  • ¥15 delta降尺度计算的一些细节,有偿
  • ¥15 Arduino红外遥控代码有问题
  • ¥15 数值计算离散正交多项式
  • ¥30 数值计算均差系数编程
  • ¥15 redis-full-check比较 两个集群的数据出错
  • ¥15 Matlab编程问题
  • ¥15 训练的多模态特征融合模型准确度很低怎么办
  • ¥15 kylin启动报错log4j类冲突
  • ¥15 超声波模块测距控制点灯,灯的闪烁很不稳定,经过调试发现测的距离偏大
  • ¥15 import arcpy出现importing _arcgisscripting 找不到相关程序