免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
12下一页
最近访问板块 发新帖
查看: 2998 | 回复: 11
打印 上一主题 下一主题

nbu7恢复怪象:前面好的,现在不能恢复且只是11g,10g又没问题 [复制链接]

论坛徽章:
0
跳转到指定楼层
1 [收藏(0)] [报告]
发表于 2011-12-10 15:32 |只看该作者 |倒序浏览
channel d1: restoring control file
released channel: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 12/10/2011 11:41:39
ORA-19870: error while restoring backup piece /c-1255836038-20111209-02
ORA-19507: failed to retrieve sequential file, handle="/c-1255836038-20111209-02", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Backup file </c-1255836038-20111209-02> not found in NetBackup catalog

如果说有什么调整的话,就是其中一天的增量改成了差异,但10g始终好的,查11g恢复时dbclient日志发现如下区别
以前好的时候:
。。。
02:30:32.764 [23084] <2> vnet_vnetd_daemon_socket: ../../libvlibs/vnet_vnetd.c.479: VN_REQUEST_DAEMON_SOCKET
: 2 0x00000002
02:30:32.764 [23084] <2> vnet_vnetd_daemon_socket: ../../libvlibs/vnet_vnetd.c.493: ipc_string: /tmp/vnet-23
104323109819401252000000002-KZgdy0
02:30:32.845 [23084] <2> int_ReadData: INF - reading buffer # 1 of size 262144
02:30:33.755 [23084] <2> int_ReadData: INF - Got end-of-file

02:30:33.755 [23084] <8> int_ReadData: WRN - Failed to set client read timeout.
02:30:34.271 [23084] <2> int_CloseImage: INF - Restore - closing </c-1255836038-20111205-02>
02:30:53.431 [23084] <4> sbtend: INF - --- END of SESSION ---

现在是:
。。。
02:30:06.786 [29503] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2068: service: bprd
02:30:06.827 [29503] <2> logconnections: BPRD CONNECT FROM 127.0.0.1.10896 TO 127.0.0.1.13724
02:30:06.953 [29503] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2054: VN_REQUEST_SERVICE_SOC
KET: 6 0x00000006
02:30:06.953 [29503] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2068: service: bprd
02:30:06.994 [29503] <2> logconnections: BPRD CONNECT FROM 127.0.0.1.63284 TO 127.0.0.1.13724
02:30:07.119 [29503] <4> VxBSAQueryObject: INF - No match was found for query
02:30:07.119 [29503] <2> int_FindBackupImage: INF - /c-1255836038-20111209-02 not found
02:30:07.119 [29503] <16> int_StartJob: ERR - Backup file </c-1255836038-20111209-02> not found in NetBackup
catalog

可见差了这一行:
vnet_vnetd_daemon_socket: ../../libvlibs/vnet_vnetd.c.493: ipc_string: /tmp/vnet-23104323109819401252000000002-KZgdy0

论坛徽章:
1
CU十二周年纪念徽章
日期:2013-10-24 15:41:34
2 [报告]
发表于 2011-12-10 22:45 |只看该作者
是同一台主机吗?

把/etc/hosts中127.0.0.1的哪行去了再试一试。

论坛徽章:
0
3 [报告]
发表于 2011-12-11 07:17 |只看该作者
本帖最后由 msee 于 2011-12-11 07:18 编辑

哦,好的时候前面是这样的

02:30:18.146 [23084] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2054: VN_REQUEST_SERVICE_SOCKET: 6 0x0000
0006
02:30:18.146 [23084] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2068: service: bprd
02:30:18.187 [23084] <2> logconnections: BPRD CONNECT FROM 127.0.0.1.33551 TO 127.0.0.1.13724
02:30:18.189 [23084] <2> int_logDateRange: INF - Start Time = 12/04/11 12:00:00
02:30:18.189 [23084] <2> int_logDateRange: INF - End Time = 12/06/11 12:00:00
02:30:18.190 [23084] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2054: VN_REQUEST_SERVICE_SOCKET: 6 0x0000
0006
02:30:18.190 [23084] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2068: service: bprd
02:30:18.231 [23084] <2> logconnections: BPRD CONNECT FROM 127.0.0.1.58443 TO 127.0.0.1.13724
02:30:18.365 [23084] <2> int_logDateRange: INF - Start Time = 12/04/11 12:00:00
02:30:18.365 [23084] <2> int_logDateRange: INF - End Time = 12/06/11 12:00:00
02:30:18.366 [23084] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2054: VN_REQUEST_SERVICE_SOCKET: 6 0x0000
0006
02:30:18.366 [23084] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2068: service: bprd
02:30:18.407 [23084] <2> logconnections: BPRD CONNECT FROM 127.0.0.1.10384 TO 127.0.0.1.13724
02:30:18.565 [23084] <2> xbsa_ProgressLogSetup: INF - No progress log: Job will proceed without progress logging
02:30:18.596 [23084] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2054: VN_REQUEST_SERVICE_SOCKET: 6 0x0000
0006
02:30:18.596 [23084] <2> vnet_vnetd_service_socket: ../../libvlibs/vnet_vnetd.c.2068: service: bprd
02:30:18.636 [23084] <2> logconnections: BPRD CONNECT FROM 127.0.0.1.60825 TO 127.0.0.1.13724
02:30:32.763 [23084] <2> vnet_connect_to_vnetd_extra: ../../libvlibs/vnet_vnetd.c.188: msg: VNETD CONNECT FROM 127.0.0.1.
45159 TO 127.0.0.1.13724 fd = 12
02:30:32.764 [23084] <2> vnet_vnetd_daemon_socket: ../../libvlibs/vnet_vnetd.c.479: VN_REQUEST_DAEMON_SOCKET: 2 0x0000000
2
02:30:32.764 [23084] <2> vnet_vnetd_daemon_socket: ../../libvlibs/vnet_vnetd.c.493: ipc_string: /tmp/vnet-231043231098194
01252000000002-KZgdy0
02:30:32.845 [23084] <2> int_ReadData: INF - reading buffer # 1 of size 262144
02:30:33.755 [23084] <2> int_ReadData: INF - Got end-of-file

是同一台主机,hosts都没动过

论坛徽章:
1
CU十二周年纪念徽章
日期:2013-10-24 15:41:34
4 [报告]
发表于 2011-12-11 20:09 |只看该作者
少的哪行前面的尖括号里面的数字是什么?

论坛徽章:
0
5 [报告]
发表于 2011-12-11 20:57 |只看该作者
有这一行的 ipc_string: /tmp/vnet-
前面都是<2>  看3楼

论坛徽章:
0
6 [报告]
发表于 2011-12-11 20:59 |只看该作者
12.7之前还是好的,12。7之后就不行了,而且啊现在恢复12.7之前的竟然也不行了,同样的问题,10g却始终正常

论坛徽章:
1
CU十二周年纪念徽章
日期:2013-10-24 15:41:34
7 [报告]
发表于 2011-12-12 16:03 |只看该作者
很奇怪,什么都没改就出问题了。

最好是将verbose =5设置好,并打开bphdb,dbclient

论坛徽章:
0
8 [报告]
发表于 2011-12-12 19:29 |只看该作者
不知为何 bprd 中显示
02:30:07.654 [23099] <2> fileslist:    group = asmadmin
而以前正确的应是
02:30:01.484 [1963] <2> fileslist:    group = oinstall

无奈删了用户重建总算好了,12.7曾经改1天的增量备份为差异备份,不知是否与此相关,抑或BUG ?!

论坛徽章:
0
9 [报告]
发表于 2011-12-12 22:32 |只看该作者
恢复的时候加个
SEND 'BKUP_IMAGE_PERM=ANY';

论坛徽章:
1
CU十二周年纪念徽章
日期:2013-10-24 15:41:34
10 [报告]
发表于 2011-12-13 10:33 |只看该作者
不知为何 bprd 中显示
02:30:07.654 [23099]  fileslist:    group = asmadmin
而以前正确的应是
02:30: ...
msee 发表于 2011-12-12 19:29



    这个没有问题。不要理会前面是<2>,<4>的信息。
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP