ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 遭遇10gR2 rman nfs bug

遭遇10gR2 rman nfs bug

原创 Linux操作系统 作者:paulyibinyi 时间:2010-06-06 23:26:18 0 删除 编辑

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

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

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

Starting restore at 06-JUN-10
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-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/7199859/viewspace-664523/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    907
  • 访问量
    6894430