taotaopkm 发表于 2015-06-03 17:07

oracle rac rman异机恢复失败-spfile

我的环境是这样的:
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文件。求高人解答,是不是还要设置什么参数,拜谢~~~:em28:



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 (58)
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 (58)
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.

笑脸松鼠 发表于 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

taotaopkm 发表于 2015-06-08 15:26

多谢。host里面都加过了,解析也没问题,允许异机恢复的文件也创建了,可是还是不行...回复 2# 笑脸松鼠


   

rand1985 发表于 2015-06-16 08:40

恢复环境是单节点还是RAC?
要是恢复单节点你可能要修改一堆的配置:lol

taotaopkm 发表于 2015-06-16 08:58

也是RAC~回复 4# rand1985


   
页: [1]
查看完整版本: oracle rac rman异机恢复失败-spfile