Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Oracle backup: not every stream is successful

Created: 10 Sep 2012 | 1 comment
nounejmak's picture

almost by every backup, one or two streams failed

Recovery Manager: Release 11.2.0.1.0 - Production on Sat Sep 8 23:30:00 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: VD01 (DBID=2560777890)

RMAN> run {
2>    allocate channel t1 type 'SBT_TAPE';
3>    send 'NB_ORA_CLIENT=ias-ora001bk, NB_ORA_POLICY=oracle_backup_L, NB_ORA_SCHED=back_1m';
4>    allocate channel t2 type 'SBT_TAPE';
5>    send 'NB_ORA_CLIENT=ias-ora001bk, NB_ORA_POLICY=oracle_backup_L, NB_ORA_SCHED=back_1m';
6>    allocate channel t3 type 'SBT_TAPE';
7>    send 'NB_ORA_CLIENT=ias-ora001bk, NB_ORA_POLICY=oracle_backup_L, NB_ORA_SCHED=back_1m';
8>    allocate channel t4 type 'SBT_TAPE';
9>    send 'NB_ORA_CLIENT=ias-ora001bk, NB_ORA_POLICY=oracle_backup_L, NB_ORA_SCHED=back_1m';
10>    backup database include current controlfile;
11>    release channel t1;
12>    release channel t2;
13>    release channel t3;
14>    release channel t4;
15>    allocate channel t1 type disk;
16>    sql "alter database backup controlfile to ''D:\RMAN_Backup\control\control_ora_full_vd01.bkp''";
17>    sql "create pfile=''D:\RMAN_Backup\spfile\initVD011.ora'' FROM spfile";
18>    release channel t1;
19>    }
20> exit
using target database control file instead of recovery catalog
allocated channel: t1
channel t1: SID=987 instance=vd011 device type=SBT_TAPE
channel t1: Veritas NetBackup for Oracle - Release 7.1 (20110203)

sent command to channel: t1

allocated channel: t2
channel t2: SID=10 instance=vd011 device type=SBT_TAPE
channel t2: Veritas NetBackup for Oracle - Release 7.1 (20110203)

sent command to channel: t1
sent command to channel: t2

allocated channel: t3
channel t3: SID=593 instance=vd011 device type=SBT_TAPE
channel t3: Veritas NetBackup for Oracle - Release 7.1 (20110203)

sent command to channel: t1
sent command to channel: t2
sent command to channel: t3

allocated channel: t4
channel t4: SID=983 instance=vd011 device type=SBT_TAPE
channel t4: Veritas NetBackup for Oracle - Release 7.1 (20110203)

sent command to channel: t1
sent command to channel: t2
sent command to channel: t3
sent command to channel: t4

Starting backup at 08-SEP-12
channel t1: starting full datafile backup set
channel t1: specifying datafile(s) in backup set
input datafile file number=00006 name=+DATA/vd01/datafile/kdb_massenkorrektur.270.733068349
channel t1: starting piece 1 at 08-SEP-12
channel t2: starting full datafile backup set
channel t2: specifying datafile(s) in backup set
input datafile file number=00008 name=+DATA/vd01/datafile/kdb_idp.272.733069869
input datafile file number=00001 name=+DATA/vd01/datafile/system.260.732996089
input datafile file number=00010 name=+DATA/vd01/datafile/kdb_indx_idp.274.733070179
input datafile file number=00005 name=+DATA/vd01/datafile/users.265.732996325
channel t2: starting piece 1 at 08-SEP-12
channel t3: starting full datafile backup set
channel t3: specifying datafile(s) in backup set
input datafile file number=00007 name=+DATA/vd01/datafile/kdb_dat.271.733069499
input datafile file number=00013 name=+DATA/vd01/datafile/vdbdba_indx.277.733070279
input datafile file number=00011 name=+DATA/vd01/datafile/kdb_warehouse.275.733070191
input datafile file number=00002 name=+DATA/vd01/datafile/sysaux.261.732996097
channel t3: starting piece 1 at 08-SEP-12
channel t4: starting full datafile backup set
channel t4: specifying datafile(s) in backup set
input datafile file number=00003 name=+DATA/vd01/datafile/undotbs1.262.732996117
input datafile file number=00004 name=+DATA/vd01/datafile/undotbs2.264.732996239
input datafile file number=00009 name=+DATA/vd01/datafile/kdb_indx.273.733070115
input datafile file number=00012 name=+DATA/vd01/datafile/vdbdba_dat.276.733070217
channel t4: starting piece 1 at 08-SEP-12
RMAN-03009: failure of backup command on t4 channel at 09/08/2012 23:36:52
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
   Failed to process backup file <qenkni8s_1_1>
ORA-19502: write error on file "qenkni8s_1_1", block number 84609 (block size=8192)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSASendData: Failed with error:
channel t4 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on t1 channel at 09/09/2012 01:47:10
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
   Failed to process backup file <qbnkni8o_1_1>
ORA-19502: write error on file "qbnkni8o_1_1", block number 2776513 (block size=8192)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSASendData: Failed with error:
channel t1 disabled, job failed on it will be run on another channel
RMAN-03009: failure of backup command on t3 channel at 09/09/2012 01:47:10
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
   Failed to process backup file <qdnkni8p_1_1>
ORA-19502: write error on file "qdnkni8p_1_1", block number 2654785 (block size=8192)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSASendData: Failed with error:
channel t3 disabled, job failed on it will be run on another channel
channel t2: finished piece 1 at 09-SEP-12
piece handle=qcnkni8p_1_1 tag=TAG20120908T233032 comment=API Version 2.0,MMS Version 5.0.0.0
channel t2: backup set complete, elapsed time: 11:54:07
channel t2: starting full datafile backup set
channel t2: specifying datafile(s) in backup set
input datafile file number=00006 name=+DATA/vd01/datafile/kdb_massenkorrektur.270.733068349
channel t2: starting piece 1 at 09-SEP-12
released channel: t1
released channel: t2
released channel: t3
released channel: t4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t2 channel at 09/09/2012 21:09:10
ORA-27192: skgfcls: sbtclose2 returned error - failed to close file
ORA-19511: Error received from media manager layer, error text:
   Failed to process backup file <qfnkos3o_1_1>
ORA-19502: write error on file "qfnkos3o_1_1", block number 10966273 (block size=8192)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
   VxBSASendData: Failed with error:

Recovery Manager complete.
 

--------------------------------------------------------

00:09:52.800 [8636.14536] <2> int_WriteData: INF - writing buffer # 18000 of size 262144
00:10:12.861 [8636.16264] <2> int_WriteData: INF - writing buffer # 18000 of size 262144
00:11:08.850 [8636.13700] <16> writeToServer: ERR - send() to server on socket failed:
00:11:08.850 [8636.13700] <16> dbc_put: ERR - failed sending data to server
00:11:08.975 [8636.13700] <16> VxBSASendData: ERR - Could not do a bsa_put().
00:11:08.975 [8636.13700] <16> xbsa_SendData: ERR - VxBSASendData: Failed with error:
   Server Status:  Communication with the server has not been initiated or the server status has not been retrieved from the serve
00:11:08.975 [8636.13700] <16> dbc_put: ERR - invalid handle received from the application
00:11:08.975 [8636.13700] <16> VxBSASendData: ERR - Could not do a bsa_put().
00:11:08.975 [8636.13700] <16> xbsa_SendData: ERR - VxBSASendData: Failed with error:
   Server Status:  Communication with the server has not been initiated or the server status has not been retrieved from the serve
00:11:09.989 [8636.13700] <2> int_CloseImage: INF - Backup - closing <qknkq6ko_1_1>
00:11:09.989 [8636.13700] <16> writeToServer: ERR - send() to server on socket failed:
00:11:09.989 [8636.13700] <16> write_LF_END_tarHeader: ERR - failed writing LF_END_U_LEN_FILE record on DATA socket
00:11:09.989 [8636.13700] <16> finishTarImage: ERR - write_LF_END_tarHeader() failed.
00:11:09.989 [8636.13700] <16> VxBSAEndData: ERR - EndData unable to bsa_finishTarImage().
00:11:09.989 [8636.13700] <16> xbsa_EndData: ERR - VxBSAEndData: Failed with error:
   Server Status:  Communication with the server has not been initiated or the server status has not been retrieved from the serve
00:11:09.989 [8636.13700] <16> int_CloseImage: ERR - Failed to process backup file <qknkq6ko_1_1>

00:11:09.989 [8636.13700] <8> close_image: Session being terminated abnormally, cleaning up
00:11:09.989 [8636.13700] <4> close_image: INF - backup FAILED
00:11:09.989 [8636.13700] <4> close_image: INF ---- end of Backup ---

Comments 1 CommentJump to latest comment

nounejmak's picture

the backup was running via very old media server

i have redirected backup via new media server and after that everything is running