oracle 10gR2 rman nfs对数据库进行备份恢复时的bug

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:38

oracle 10gR2 rman nfs对数据库进行备份恢复时的bug

环境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的就要注意。

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】