ITPub博客

首页 > 数据库 > Oracle > 遭遇10gR2 rman nfs bug

遭遇10gR2 rman nfs bug

原创 Oracle 作者:fanhongjie 时间:2010-09-08 15:59:31 0 删除 编辑

转自:http://space.itpub.net/7199859/viewspace-664523

环境oracle 10.2.0.4+aix 5.3 备份集放在nfs下,共享网络存储

[@more@]

在给客户用rman搭建应急环境,恢复控制文件时报以下错误:

RMAN> restore controlfile from '/orabak/15_set/control_186_1_720930534';

Starting restore at 06-JUN

using channel ORA_DISK_1

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

RMAN-03002: failure of restore command at 06/06/2010 22:02:16

RMAN-06172: no autobackup found or specified handle is not a valid copy or piece

/orabak是共享网络存储的文件系统名

经过测试,把备份集拷贝到本地存储盘时,恢复成功

RMAN> restore controlfile from '/oracle/control_186_1_720930534';

Starting restore at 06-JUN-10
using channel ORA_DISK_1

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output filename=/dev/rcrm_cont01lv
output filename=/dev/rcrm_cont02lv
output filename=/dev/rcrm_cont03lv
Finished restore at 06-JUN-10

所以怀疑nfs有问题

恢复数据文件时,报ORA-27054错误

channel t1: reading from backup piece /orabak/15_set/full_172_1_720323979
ORA-19870: error reading backup piece /orabak/15_settle/full_172_1_720323979
ORA-19505: failed to identify file "/orabak/15_set/full_172_1_720323979"
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options Additional information: 6 failover to previous backup

最后查metalink文档387700.1 说有可能是bug,设置event就可解决

其中有三种方法:设置event是其中之一

alter system set event='10298 trace name context forever,level 32' scope=spfile;

重新启动数据库后生效.

然后再恢复控制文件和数据文件都成功。

最后搜了下网络,很多人都遇到过这个问题,在10gR2版本下很常见,看来大家要是用rman nfs restore的就要注意。

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/73920/viewspace-1038067/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-05-22

  • 博文量
    111
  • 访问量
    685243