Highlighted

Error Backup RAC Oracle

Hi Support Team,

We met error 6 during backup RAC Oracle using RMAN script.

Here is brief topology based on /etc/hosts file in client servers.

### NetBackup Master ###
10.23.71.35 CNBBKPBILLSVR
10.23.71.36 CBTCNBMASBIL01
10.23.71.37 CBTCNBMASBIL02

### NetBackup Media Server ###
# Communication
# 10.23.153.26 cbtcnbmediasvr06
# Backup
10.23.153.78 cbtcnbmediasvr06 cbtcnbmediasvr06-eth2

### NetBackup Client ###
#public
10.23.96.11 CBTGRDBLDB01.intra.excelcom.co.id CBTGRDBLDB01
10.23.96.13 CBTGRDBLDB02.intra.excelcom.co.id CBTGRDBLDB02
10.23.96.15 CBTGRDBLDB03.intra.excelcom.co.id CBTGRDBLDB03
10.23.96.17 CBTGRDBLDB04.intra.excelcom.co.id CBTGRDBLDB04
#backup
10.23.98.11 CBTGRDBLDB01_bkp
10.23.98.12 CBTGRDBLDB02_bkp
10.23.98.14 CBTGRDBLDB03_bkp
10.23.98.14 CBTGRDBLDB04_bkp

CBTGRDBLDB01
PROD : 10.23.96.11
BACKUP : 10.23.98.11
[root@CBTGRDBLDB01 etc]# route -n
Kernel IP routing table
Destination Gateway Genmask Flags Metric Ref Use Iface
0.0.0.0 10.23.96.1 0.0.0.0 UG 0 0 0 bond0
10.23.91.0 10.23.98.1 255.255.255.0 UG 0 0 0 bond2
10.23.96.0 0.0.0.0 255.255.255.0 U 0 0 0 bond0
10.23.97.0 0.0.0.0 255.255.255.0 U 0 0 0 bond1
10.23.98.0 0.0.0.0 255.255.255.0 U 0 0 0 bond2
10.23.99.0 0.0.0.0 255.255.255.0 U 0 0 0 bond3
10.23.153.64 10.23.98.1 255.255.255.224 UG 0 0 0 bond2
169.254.0.0 0.0.0.0 255.255.0.0 U 0 0 0 bond1
192.168.122.0 0.0.0.0 255.255.255.0 U 0 0 0 virbr0
[root@CBTGRDBLDB01 arch]# cat /usr/openv/netbackup/bp.conf
SERVER = CNBBKPBILLSVR
SERVER = CBTCNBMASBIL01
SERVER = CBTCNBMASBIL02
SERVER = cbtcnbmediasvr06
HOST_NAME = CBTGRDBLDB01_bkp
CLIENT_NAME = CBTGRDBLDB01_bkp
CONNECT_OPTIONS = localhost 1 0 2
CLIENT_READ_TIMEOUT = 10800

CBTGRDBLDB02
PROD : 10.23.96.13
BACKUP : 10.23.98.12
[root@CBTGRDBLDB02 ibmuser]# route -n
Kernel IP routing table
Destination Gateway Genmask Flags Metric Ref Use Iface
0.0.0.0 10.23.96.1 0.0.0.0 UG 0 0 0 bond0
10.23.91.0 10.23.98.1 255.255.255.0 UG 0 0 0 bond2
10.23.96.0 0.0.0.0 255.255.255.0 U 0 0 0 bond0
10.23.97.0 0.0.0.0 255.255.255.0 U 0 0 0 bond1
10.23.98.0 0.0.0.0 255.255.255.0 U 0 0 0 bond2
10.23.99.0 0.0.0.0 255.255.255.0 U 0 0 0 bond3
10.23.153.64 10.23.98.1 255.255.255.224 UG 0 0 0 bond2
169.254.0.0 0.0.0.0 255.255.0.0 U 0 0 0 bond1
192.168.122.0 0.0.0.0 255.255.255.0 U 0 0 0 virbr0
[root@CBTGRDBLDB02 dbclient]# cat /usr/openv/netbackup/bp.conf
SERVER = CNBBKPBILLSVR
SERVER = CBTCNBMASBIL01
SERVER = CBTCNBMASBIL02
SERVER = cbtcnbmediasvr06
HOST_NAME = CBTGRDBLDB02_bkp
CLIENT_NAME = CBTGRDBLDB02_bkp
CONNECT_OPTIONS = localhost 1 0 2
CLIENT_READ_TIMEOUT = 10800

Here is routing tabel and /etc/hosts file on Master Server
[root@CBTCNBMASBIL01 ibmuser]# route -n
Kernel IP routing table
Destination Gateway Genmask Flags Metric Ref Use Iface
10.23.75.0 0.0.0.0 255.255.255.0 U 0 0 0 eth0
10.23.98.0 10.23.71.35 255.255.255.0 UG 0 0 0 bond0
10.23.71.0 0.0.0.0 255.255.255.0 U 0 0 0 bond0
169.254.0.0 0.0.0.0 255.255.0.0 U 1002 0 0 eth0
169.254.0.0 0.0.0.0 255.255.0.0 U 1012 0 0 bond0
0.0.0.0 10.23.71.1 0.0.0.0 UG 0 0 0 bond0
[root@CBTCNBMASBIL01 ibmuser]# cat /etc/hosts | grep -i 'CBTGRDBLDB'
10.23.96.11 CBTGRDBLDB01.intra.excelcom.co.id CBTGRDBLDB01 CBTGRDBLDB01_bkp
10.23.96.13 CBTGRDBLDB02.intra.excelcom.co.id CBTGRDBLDB02 CBTGRDBLDB02_bkp
10.23.96.15 CBTGRDBLDB03.intra.excelcom.co.id CBTGRDBLDB03 CBTGRDBLDB03_bkp
10.23.96.17 CBTGRDBLDB04.intra.excelcom.co.id CBTGRDBLDB04 CBTGRDBLDB04_bkp


Network 10.23.96.0/24 on client is able to communicate to IP 10.23.71.35 (Master Server) and 10.23.153.26 (Communication IP of Media Server).

Network 10.23.98.0/24 on client is just able to communicate to IP 10.23.153.78 (Backup IP of Media Server) and there is no route to network 10.23.71.x.Please advice.

Please advice.

Thank you.

 

Tags (2)
3 Replies

Re: Error Backup RAC Oracle

I can see a couple of issues that need to be addressed. This mostly looks like a network routing issue at this stage rather than strictly a NetBackup one.

1. From the DB servers the only route  back to the master server is via the default route, this would make the connection come from the 10.23.96.X interface - I suspect you need a network route via the 10.23.98.0/24 network so that all backup traffic flows via that interface. This is why you are unable to connect to the master via the 10.23.98.X network.

2. On the master server the primary interfaces and *_bkp interfaces are using the same IP from the host file, but you indicate that the *_bkp names have a different IP in the 10.23.98 network. 

Hope this helps

Re: Error Backup RAC Oracle

Hi davidmoline,

Should it be routed between 10.23.98.x (backup network) and 10.23.71.35? Is backup IP need communicate to master server?

Thank you .

Re: Error Backup RAC Oracle

I can't answer that, but if you do want the backup interface on the DB server to communicate to the master server, then you will need to route.