Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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