04-08-2015 03:23 PM
Hi All,
An RMAN Backup is happening without generating any child streams. The backup use to happen sucessfully, but since past few days its not happening.
The logs from the DBA Side are:
ORA-19506: failed to create sequential file, name="5iq3qqn2_1_1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSACreateObject: Failed with error:
Server Status: Communication with the server has not been initiated or the server status has not been retrieved from the serve
channel ch00 disabled, job failed on it will be run on another channel
released channel: ch00
released channel: ch01
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ch01 channel at 04/07/2015 23:38:14
ORA-19506: failed to create sequential file, name="5jq3qqn2_1_1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSACreateObject: Failed with error:
Server Status: Communication with the server has not been initiated or the server status has not been retrieved from the serve
RMAN> 2>
Recovery Manager complete.
Script /ora11203/oracle/RMAN/scripts/full_hot_rman_pb2.sh
==== ended in error on Tue Apr 7 23:38:14 IST 2015 ====
------------------------------------------
ORACLE RMAN BACKUP STATUS
------------------------------------------
Netbackup Server : hydt5440-nbms
Netbackup Client : IHYDSUNE2900-03_NBI
Database Name : PB2
Policy Name : DMZ-RMAN_PB2-TRIWEEKLY
Back Type : INCREMENTAL LEVEL=0
RMAN TAG Name : TAG PB2_full_7_Apr_2015
Start Date : 7 Apr 2015 23:37:12
End Date : 7 Apr 2015 23:38:14
Status : ended in error
In the detail status, no errors are appearing. I tried increasing the verbosity and generating logs in dbclient on the client but no logs got generated.
Master server: solaris 10.
Netbackup version: 7.5.0.6
Media Server: solaris 10
Netbackup version: 7.0
Kindly suggest any steps or any logs which I can use to troubleshoot the issue.
Thanks
Solved! Go to Solution.
04-09-2015 12:52 AM
Please use hostname with bptestbpcd, not IP address.
If nothing is getting written in dbclient, double-check that the oracle library link to NBU libobk is still in place.
Also check that dbclient folder has 777 permissions.
Check bprd log on the master server (if you need to create the folder, remember to restart NBU to enable the log).
Check in bprd if request is received from client IP address.
04-08-2015 04:32 PM
Please check if the client can communicate with master server.
Sometimes Master Sever name is defined not by bp.conf but NB_ORA_SERV environment in backup script. In such case, check connectivity from the client using host name specified in NB_ORA_SERV. Launch jbpSA, log on, change master server name and check if connection is refused or not.
04-08-2015 06:43 PM
Hi Yasuhisa,
The bame in NB_ORA_SERV is same as that in bp.conf.
communication from client to master:
root@IHYDSUNE2900-03 # ./bpclntcmd -pn
expecting response from server HYDT5440-NBMS
IHYDSUNE2900-03_NBI IHYDSUNE2900-03_NBI 172.16.104.115 35316
Master to client:
root@hydt5440-nbms # bptestbpcd -client 172.16.104.115 -verbose
1 1 1
10.16.13.163:49447 -> 172.16.104.115:13724
10.16.13.163:49449 -> 172.16.104.115:13724
PEER_NAME = HYDT5440-NBMS
HOST_NAME = IHYDSUNE2900-03_NBI
CLIENT_NAME = IHYDSUNE2900-03_NBI
VERSION = 0x07000000
PLATFORM = solaris10
PATCH_VERSION = 7.0.0.0
SERVER_PATCH_VERSION = -1.-1.-1.-1
MASTER_SERVER = HYDT5440-NBMS
EMM_SERVER = HYDT5440-NBMS
NB_MACHINE_TYPE = CLIENT
10.16.13.163:49459 -> 172.16.104.115:13724
04-09-2015 12:52 AM
Please use hostname with bptestbpcd, not IP address.
If nothing is getting written in dbclient, double-check that the oracle library link to NBU libobk is still in place.
Also check that dbclient folder has 777 permissions.
Check bprd log on the master server (if you need to create the folder, remember to restart NBU to enable the log).
Check in bprd if request is received from client IP address.