NetBackup Oracle RMAN backup fails with 'ORA-27028: skgfqcre: sbtbackup returned error' and job does not appear in the NBU Activity Monitor.

Article:TECH21869  |  Created: 2002-01-29  |  Updated: 2013-10-23  |  Article URL http://www.symantec.com/docs/TECH21869
Article Type
Technical Solution


Environment

Issue



NetBackup Oracle RMAN backup fails with 'ORA-27028: skgfqcre: sbtbackup returned error' and job does not appear in the NBU Activity Monitor.

Error



bprd_connect: errno = 146 - Connection refused

Solution



Problem Details

Previously working Oracle database backups suddenly begin failing with the following RMAN error message stack:

RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel c1
RMAN-10032: unhandled exception during execution of job step 1:
ORA-19624: operation failed, retry possible
ORA-19506: failed to create sequential file, name="dbf_CRMS_1870_1_qee1b8nv", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: sbtbackup: Failed to process backup file.
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 498
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 464
ORA-06512: at line 183
RMAN-10035: exception raised in RPC: ORA-19624: operation failed, retry possible
ORA-19506: failed to create sequential file, name="dbf_CRMS_1870_1_qee1b8nv", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: sbtbackup: Failed to process backup file.
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 498
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 464
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE

The dbclient log on the database client is as follows:

12:00:06 [706] <4> dbc_InitializeDBClient: INF - client's Debug Level = <0>
12:00:06 [706] <4> dbc_InitializeDBClient: --- SESSION INITIATED ---
12:00:06 [706] <4> get_alt_client: NB_ORA_CLIENT = <msuaor63.bn> found in environment
12:00:06 [706] <4> get_class: NB_ORA_CLASS = <Oracle> found in environment
12:00:06 [706] <4> get_alt_server: NB_ORA_SERV = <msuavt24> found in environment
12:00:06 [706] <4> sbtinit: VERITAS NetBackup for Oracle8 - Release 3.4GA (030800)
    System name:    SunOS
    Node name:  msuaor63
    Release:    5.7
    Version:    Generic_106541-15
    Machine:    sun4u
    User name:  oracle
    Group name: dba
    Client Host:    msuaor63
12:00:06 [706] <4> sbtinit: support for Proxy Copy enabled
12:00:09 [706] <4> get_bfs_date_range: Using default date range
12:00:09 [706] <4> get_bfs_date_range: Start Time = 12/25/95 19:00:00
12:00:09 [706] <4> get_bfs_date_range: End Time = 08/30/02 12:00:09
12:00:09 [706] <2> getsockconnected: host=msuavt24 service=bprd address=10.8.1.142 protocol=tcp non-reserved port=13720
12:00:40 [706] <16> getsockconnected: unable to connect() to msuavt24, Connection refused (146)
12:00:40 [706] <2> bprd_connect: Cannot connect to server msuavt24
12:00:40 [706] <2> bprd_connect:    errno = 146 - Connection refused
12:00:40 [706] <16> dbc_GetMediaListByName: Can't connect to host msuavt24: cannot connect on socket (25)
12:00:40 [706] <16> find_backup_image: GetMediaListByName() failed
12:00:40 [706] <16> sbtbackup: Failed to process backup file.
12:00:44 [706] <4> sbtend: --- END of SESSION ---


The indication is that the client cannot successfully connect to the bprd process on the master server to initiate the backup, possibly because of a network problem or a problem on the master server.

In this case it was discovered that bprd process was no longer running on the master server.  After restarting bprd, the backup ran successfully.



Legacy ID



250173


Article URL http://www.symantec.com/docs/TECH21869


Terms of use for this information are found in Legal Notices