免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 10937 | 回复: 4

[Veritas NBU] oracle rac rman异机恢复失败-spfile [复制链接]

论坛徽章:
0
发表于 2015-06-03 17:07 |显示全部楼层
我的环境是这样的:
Master Server:7.5,windows
源数据库:Media Server ,版本7.5 ,AIX,Oracle 11.2.0.4 Rac
目标数据库:NBU Client , 版本7.5, AIX,Oracle 11.2.0.4 Rac

我在恢复spfile的时候,会有如下报错。如果只做本机的备份恢复都是没问题的。我看到有说设置FORCE_RESTORE_MEDIA_SERVER参数,但是我的master server是windows的,没有bp.conf文件。求高人解答,是不是还要设置什么参数,拜谢~~~



2015/6/3 9:07:55 - begin Restore
2015/6/3 9:07:57 - 1 images required
2015/6/3 9:07:57 - media DD0086 required
2015/6/3 9:07:58 - restoring image other01_1433261866
2015/6/3 9:08:01 - requesting resource DD0086
2015/6/3 9:08:02 - restored image other01_1433261866 - (cannot connect on socket(25)); restore time 00:00:04
2015/6/3 9:08:02 - granted resource DD0086
2015/6/3 9:08:02 - granted resource IBM.ULTRIUM-TD3.008
2015/6/3 9:13:55 - Error bpbrm(pid=6947256) bpcd on dctm01 exited with status 48: client hostname could not be found
2015/6/3 9:13:56 - Info bpbrm(pid=6947256) telling media manager to start restore on client   
2015/6/3 9:13:56 - Info bpbrm(pid=6947256) spawning a brm child process      
2015/6/3 9:13:56 - Info bpbrm(pid=6947256) listening for client connection        
2015/6/3 9:13:56 - Info bpbrm(pid=6947256) child pid: 10289390         
2015/6/3 9:13:56 - Error bpbrm(pid=10289390) bpcd on dctm01 exited with status 48: client hostname could not be found
2015/6/3 9:13:56 - Info bpbrm(pid=6947256) sending message to media manager: STOP RESTORE other01_1433261866   
2015/6/3 9:13:56 - Error bpbrm(pid=10289390) listen for client protocol error - couldn't write necessary information on /usr/openv/netbackup/logs/user_ops/dbext/logs/15990856.0.1433293818
2015/6/3 9:13:56 - Warning bptm(pid=13566180) failure logging message to client dctm01 in log /usr/openv/netbackup/logs/user_ops/dbext/logs/15990856.0.1433293818:  can't connect to client (5
2015/6/3 9:13:58 - Info bpbrm(pid=6947256) media manager for backup id other01_1433261866 exited with status 150: termination requested by administrator
2015/6/3 9:08:06 - end Restore; elapsed time: 00:00:11
2015/6/3 9:13:55 - Error bpbrm(pid=6947256) bpcd on dctm01 exited with status 48: client hostname could not be found
2015/6/3 9:13:56 - Info bpbrm(pid=6947256) telling media manager to start restore on client   
2015/6/3 9:13:56 - Info bpbrm(pid=6947256) spawning a brm child process      
2015/6/3 9:13:56 - Info bpbrm(pid=6947256) listening for client connection        
2015/6/3 9:13:56 - Info bpbrm(pid=6947256) child pid: 10289390         
2015/6/3 9:13:56 - Error bpbrm(pid=10289390) bpcd on dctm01 exited with status 48: client hostname could not be found
2015/6/3 9:13:56 - Info bpbrm(pid=6947256) sending message to media manager: STOP RESTORE other01_1433261866   
2015/6/3 9:13:56 - Error bpbrm(pid=10289390) listen for client protocol error - couldn't write necessary information on /usr/openv/netbackup/logs/user_ops/dbext/logs/15990856.0.1433293818
2015/6/3 9:13:56 - Warning bptm(pid=13566180) failure logging message to client dctm01 in log /usr/openv/netbackup/logs/user_ops/dbext/logs/15990856.0.1433293818:  can't connect to client (5
2015/6/3 9:13:58 - Info bpbrm(pid=6947256) media manager for backup id other01_1433261866 exited with status 150: termination requested by administrator
Restore error(2850)

===================================

allocated channel: ch00
channel ch00: SID=44 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release 7.5 (2012020807)

sent command to channel: ch00

Starting restore at 2015-06-03 11:26:55

channel ch00: restoring spfile from AUTOBACKUP bk_6896_1_881367818
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 06/03/2015 11:27:11
ORA-19870: error while restoring backup piece bk_6896_1_881367818
ORA-19507: failed to retrieve sequential file, handle="bk_6896_1_881367818", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
   Failed to open backup file for restore.

论坛徽章:
0
发表于 2015-06-05 23:10 |显示全部楼层
1- log里面有这些内容:'status 48: client hostname could not be found'  ' can't connect to client '
所以,确定所有机器之间主机名解析是正常的. 确定mater/media/client之间nbu通信是正常的

2- 在master上面建一个允许异机恢复的文件 :
<install_path>\NetBackup\db\altnames\No.Restrictions

论坛徽章:
0
发表于 2015-06-08 15:26 |显示全部楼层
多谢。host里面都加过了,解析也没问题,允许异机恢复的文件也创建了,可是还是不行...回复 2# 笑脸松鼠


   

论坛徽章:
2
数据库技术版块每日发帖之星
日期:2015-06-19 22:20:00IT运维版块每日发帖之星
日期:2016-06-30 06:20:00
发表于 2015-06-16 08:40 |显示全部楼层
恢复环境是单节点  还是RAC?
要是恢复单节点  你可能要修改一堆的配置

论坛徽章:
0
发表于 2015-06-16 08:58 |显示全部楼层
也是RAC~回复 4# rand1985


   
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

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

清除 Cookies - ChinaUnix - Archiver - WAP - TOP