Highlighted

Oracle: status 25

*** Moved to new post from https://vox.veritas.com/t5/NetBackup/ORA-19511-Error-received-from-media-manager-layer-error-text/m-... ***

 

Oracle backups are getting failed with 25 whereas windows backups are failing with 25 .Please find the below the logs for reference.

 


Recovery Manager: Release 10.1.0.4.0 - Production

Copyright (c) 1995, 2004, Oracle. All rights reserved.

connected to target database: DMSP (DBID=1485656476)
using target database controlfile instead of recovery catalog

RMAN> RUN {
2> ALLOCATE CHANNEL MYL_RMAN1 TYPE SBT_TAPE parms="ENV=(NB_ORA_POLICY=IRG_ora_gerpasx01_dmsp,nb_ora_client=GERPASX01, nb_ora_serv=w2zbu001,nb_ora_sched=weekly)";
3> ALLOCATE CHANNEL MYL_RMAN2 TYPE SBT_TAPE parms="ENV=(NB_ORA_POLICY=IRG_ora_gerpasx01_dmsp,nb_ora_client=GERPASX01, nb_ora_serv=w2zbu001,nb_ora_sched=weekly)";
4> CONFIGURE RETENTION POLICY TO NONE;
5> CONFIGURE CONTROLFILE AUTOBACKUP ON;
6> BACKUP INCREMENTAL LEVEL 0 FORMAT 'db_bkup_%d_%U_%t' DATABASE;
7> BACKUP FORMAT 'archive_%d_%U' ARCHIVELOG ALL DELETE INPUT ;
8> }
9> list backup summary;
10> exit;
allocated channel: MYL_RMAN1
channel MYL_RMAN1: sid=146 devtype=SBT_TAPE
channel MYL_RMAN1: Veritas NetBackup for Oracle - Release 7.5 (20130610)

allocated channel: MYL_RMAN2
channel MYL_RMAN2: sid=121 devtype=SBT_TAPE
channel MYL_RMAN2: Veritas NetBackup for Oracle - Release 7.5 (20130610)

old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO NONE;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO NONE;
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

Starting backup at 25-AUG-19
channel MYL_RMAN1: starting incremental level 0 datafile backupset
channel MYL_RMAN1: specifying datafile(s) in backupset
input datafile fno=00008 name=G:\ORACLE\ORADATA\DMSP\USERS02.DBF
input datafile fno=00009 name=H:\ORACLE\ORADATA\DMSP\USERS03.DBF
input datafile fno=00005 name=H:\ORACLE\ORADATA\DMSP\USRINDEX01.DBF
input datafile fno=00006 name=H:\ORACLE\ORADATA\DMSP\TOOLS01.DBF
channel MYL_RMAN1: starting piece 1 at 25-AUG-19
channel MYL_RMAN2: starting incremental level 0 datafile backupset
channel MYL_RMAN2: specifying datafile(s) in backupset
input datafile fno=00004 name=G:\ORACLE\ORADATA\DMSP\USERS01.DBF
input datafile fno=00001 name=G:\ORACLE\ORADATA\DMSP\SYSTEM01.DBF
input datafile fno=00003 name=G:\ORACLE\ORADATA\DMSP\SYSAUX01.DBF
input datafile fno=00002 name=G:\ORACLE\ORADATA\DMSP\UNDOTBS01.DBF
input datafile fno=00007 name=G:\ORACLE\ORADATA\DMSP\STATSPACK01.DBF
channel MYL_RMAN2: starting piece 1 at 25-AUG-19
RMAN-03009: failure of backup command on MYL_RMAN1 channel at 08/31/2019 18:47:21
ORA-19506: failed to create sequential file, name="db_bkup_DMSP_3vua46us_1_1_1017256924", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSACreateObject: Failed with error:
Server Status: cannot connect on socket
channel MYL_RMAN1 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on MYL_RMAN2 channel at 09/01/2019 18:15:51
ORA-19506: failed to create sequential file, name="db_bkup_DMSP_40ua46us_1_1_1017256924", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSACreateObject: Failed with error:
Server Status: cannot connect on socket
channel MYL_RMAN2 disabled, job failed on it will be run on another channel
released channel: MYL_RMAN1
released channel: MYL_RMAN2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on MYL_RMAN2 channel at 09/01/2019 18:15:51
ORA-19506: failed to create sequential file, name="db_bkup_DMSP_40ua46us_1_1_1017256924", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
VxBSACreateObject: Failed with error:
Server Status: cannot connect on socket

Recovery Manager complete.

 

 


Recovery Manager: Release 10.1.0.4.0 - Production

Copyright (c) 1995, 2004, Oracle. All rights reserved.

connected to target database: DMSP (DBID=1485656476)
using target database controlfile instead of recovery catalog

RMAN> RUN {
2> ALLOCATE CHANNEL MYL_RMAN1 TYPE SBT_TAPE parms="ENV=(NB_ORA_POLICY=IRG_ora_gerpasx01_dmsp,nb_ora_client=GERPASX01, nb_ora_serv=w2zbu001,nb_ora_sched=weekly)";
3> ALLOCATE CHANNEL MYL_RMAN2 TYPE SBT_TAPE parms="ENV=(NB_ORA_POLICY=IRG_ora_gerpasx01_dmsp,nb_ora_client=GERPASX01, nb_ora_serv=w2zbu001,nb_ora_sched=weekly)";
4> CONFIGURE CONTROLFILE AUTOBACKUP ON;
5> BACKUP FORMAT 'archive_%d_%U' ARCHIVELOG ALL DELETE INPUT ;
6> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
7> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
8> BACKUP FORMAT 'archive_%d_%U' ARCHIVELOG ALL DELETE INPUT ;
9> RELEASE CHANNEL MYL_RMAN1;
10> RELEASE CHANNEL MYL_RMAN2;
11> }
12> list backup summary;
13> exit;
allocated channel: MYL_RMAN1
channel MYL_RMAN1: sid=109 devtype=SBT_TAPE
channel MYL_RMAN1: Veritas NetBackup for Oracle - Release 7.5 (20130610)

allocated channel: MYL_RMAN2
channel MYL_RMAN2: sid=82 devtype=SBT_TAPE
channel MYL_RMAN2: Veritas NetBackup for Oracle - Release 7.5 (20130610)

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

Starting backup at 28-AUG-19
current log archived
channel MYL_RMAN1: starting archive log backupset
channel MYL_RMAN1: specifying archive log(s) in backup set
input archive log thread=1 sequence=148427 recid=147678 stamp=1017356444
input archive log thread=1 sequence=148428 recid=147679 stamp=1017357945
input archive log thread=1 sequence=148429 recid=147680 stamp=1017368154
input archive log thread=1 sequence=148430 recid=147681 stamp=1017399647
input archive log thread=1 sequence=148431 recid=147682 stamp=1017417645
input archive log thread=1 sequence=148432 recid=147683 stamp=1017442849
input archive log thread=1 sequence=148433 recid=147684 stamp=1017446150
input archive log thread=1 sequence=148434 recid=147685 stamp=1017477052
input archive log thread=1 sequence=148435 recid=147686 stamp=1017513770
channel MYL_RMAN1: starting piece 1 at 28-AUG-19
channel MYL_RMAN2: starting archive log backupset
channel MYL_RMAN2: specifying archive log(s) in backup set
input archive log thread=1 sequence=148416 recid=147667 stamp=1017152022
input archive log thread=1 sequence=148417 recid=147668 stamp=1017152022
input archive log thread=1 sequence=148418 recid=147669 stamp=1017152690
input archive log thread=1 sequence=148419 recid=147670 stamp=1017169927
input archive log thread=1 sequence=148420 recid=147671 stamp=1017197758
input archive log thread=1 sequence=148421 recid=147672 stamp=1017237658
input archive log thread=1 sequence=148422 recid=147673 stamp=1017256328
input archive log thread=1 sequence=148423 recid=147674 stamp=1017291706
input archive log thread=1 sequence=148424 recid=147675 stamp=1017310546
input archive log thread=1 sequence=148425 recid=147676 stamp=1017320206
input archive log thread=1 sequence=148426 recid=147677 stamp=1017342640
channel MYL_RMAN2: starting piece 1 at 28-AUG-19
RMAN-03009: failure of backup command on MYL_RMAN1 channel at 09/03/2019 19:12:08
ORA-19506: failed to create sequential file, name="archive_DMSP_41uac3gc_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: cannot connect on socket
channel MYL_RMAN1 disabled, job failed on it will be run on another channel

1 Reply

Re: Oracle: status 25

@Prabhu_Bruce 

You need to give us more info.

You say that this is NBU 8.1.2, but you have selected Windows 2003 as OS, and the Oracle Client is clearly on NBU 7.5:
channel MYL_RMAN1: Veritas NetBackup for Oracle - Release 7.5 (20130610)

Please give us all relevant info - OS and NBU version on all of these:
Master
Media
Client

Has this ever worked? 

Have you tested port connectivity (1556) between master and client? ANd between media server and client (if separate media server)?
Can the client connect to bprd on the master (via port 1556) on the master?
Can you show us output of this command on the client :
bpclntcmd -pn

Have you checked NBU compatibility lists?