load_balance参数引起的oracle备份失败
日志输出
ORA-19506: failed to create sequential file, name=“63u26090_1_1”, parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, 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 server.
channel ORA_SBT_TAPE_1 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on ORA_SBT_TAPE_2 channel at 05/22/2019 10:00:14
ORA-19506: failed to create sequential file, name=“64u26090_1_1”, parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, 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 server.
经排查,解析一切都正常,oracle的连接串tnsping都正常,oracle客户端到nbu master的端口都正常,最后发现是tnsnames.ora中的连接串写的有问题导致备份经常报错
backup =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.100.115)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.100.116)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dbtest)
)
)
因为一个连接串配置了两个ip,又加上load_balance值为yes,导致连接的时候不是连接到一个固定的ip
所以正确的做法应该是将load_balance的值写成no,或者只用一个ip,并且删掉load_balance这一行