qhd2004

41 积分	0 好友	15 主题

发消息

rman恢复时RMAN-06025错误

1^#

发表于 2012-6-21 11:31:48 | 查看: 9776| 回复: 6

rman做level0、level1备份后做恢复时遇到RMAN-06025:错误

自己模拟rman备份、恢复，出现RMAN-06025:，开始以为是权限有问题，权限解决后问题依旧，刘大有时间帮忙下，多谢！

备份过程、脚本、备份日志、恢复过程都在附件中

环境
os：Red Hat Enterprise Linux Server release 5.4
db：11.2.0.1.0

两节点rac

rman-06025.rar

4.49 KB, 下载次数: 1128

分享0

收藏0 回复只看该作者道具举报

Maclean Liu(刘相兵

2^#

发表于 2012-6-21 11:45:39

action plan:

贴出以下命令的输出

crosscheck archivelog sequence 321 thread 2;
crosscheck  archivelog sequence 409 thread 1;
crosscheck  backup of  archivelog sequence 321 thread 2;
crosscheck backup of  archivelog sequence 409 thread 1;

回复只看该作者道具举报

qhd2004

3^#

发表于 2012-6-21 11:48:24

RMAN> crosscheck archivelog sequence 321 thread 2;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=194 instance=sykdb1 device type=DISK
validation failed for archived log
archived log file name=/arch/sykdb/2_321_778361898.dbf RECID=608 STAMP=786470926
Crosschecked 1 objects

RMAN> crosscheck archivelog sequence 409 thread 1;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=194 instance=sykdb1 device type=DISK
validation failed for archived log
archived log file name=/arch/sykdb/1_409_778361898.dbf RECID=607 STAMP=786470923
Crosschecked 1 objects

RMAN> crosscheck backup of archivelog sequence 321 thread 2;

using channel ORA_DISK_1
specification does not match any backup in the repository

RMAN> crosscheck backup of archivelog sequence 409 thread 1;

using channel ORA_DISK_1
specification does not match any backup in the repository

RMAN>

回复只看该作者道具举报

Maclean Liu(刘相兵

4^#

发表于 2012-6-21 11:53:23

validation failed for archived log

2_321_778361898.dbf 1_409_778361898.dbf 这2个归档文件你都没有恢复出来，也没有这些归档的备份

回复只看该作者道具举报

qhd2004

5^#

发表于 2012-6-21 11:55:39

我再重新测试下。
多谢！

回复只看该作者道具举报

qhd2004

6^#

发表于 2012-6-25 12:05:37

测试下，还是有归档没备份。
RMAN-03002: failure of recover command at 06/25/2012 11:59:58
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 2 with sequence 90 and starting SCN of 6977958 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 248 and starting SCN of 6977975 found to restore

RMAN> crosscheck archivelog sequence 90 thread 2;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=194 instance=sykdb2 device type=DISK
validation failed for archived log
archived log file name=/arch/sykdb/2_90_778361898.dbf RECID=215 STAMP=786887075
Crosschecked 1 objects

RMAN> crosscheck archivelog sequence 248 thread 1;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=194 instance=sykdb2 device type=DISK
validation failed for archived log
archived log file name=/arch/sykdb/1_248_778361898.dbf RECID=216 STAMP=786887077
Crosschecked 1 objects

RMAN> crosscheck backup of archivelog sequence 90 thread 2;

using channel ORA_DISK_1
specification does not match any backup in the repository

RMAN> crosscheck backup of archivelog sequence 248 thread 1;

using channel ORA_DISK_1
specification does not match any backup in the repository

RMAN>

rman备份脚本问题还是rman配置问题？？？

回复只看该作者道具举报

tonytang

7^#

发表于 2012-6-27 13:40:14

备份之前有没有执行一下 alter system archive log current;这个语句啊？

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册