database session for channel sbt_4 terminated unexpectedly [message #544753] |
Thu, 23 February 2012 10:45 |
|
jjosserand
Messages: 3 Registered: February 2012 Location: Boise, ID
|
Junior Member |
|
|
Backup for database has been working fine until today.
Today, about 1/3 of the way through the backup (large database), I got this...
RMAN-12005: error during channel cleanup
RMAN-10038: database session for channel sbt_4 terminated unexpectedly
...and the backup died.
Never seen before and the research I've done online has been less than helpful. This database is an SAP/oracle db with brtools 7.20 (22) and is using the new parameter in its init.sap file, called "_rman_chan_failo = yes", to address disagreement between brtools and oracle about channel drops being ok if all datafiles backed up.
Nothing in the alert log at the time of this error.
Any help appreciated.
|
|
|
Re: database session for channel sbt_4 terminated unexpectedly [message #544754 is a reply to message #544753] |
Thu, 23 February 2012 10:49 |
|
jjosserand
Messages: 3 Registered: February 2012 Location: Boise, ID
|
Junior Member |
|
|
Here's a bit more from the oracle backup run log...
786 0 Incr 84050079044 22-Feb-2012 12:35:11 /oracle/ARS/sapdata2/r3e_740/r3e.
data740
813 0 Incr 84050079044 22-Feb-2012 12:35:11 /oracle/ARS/sapdata4/r3e_767/r3e.
data767
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-12005: error during channel cleanup
RMAN-10038: database session for channel sbt_4 terminated unexpectedly
RMAN>
Recovery Manager complete.
BR0200I BR_TRACE: location BrRmanCall-41, commands for RMAN in: /oracle/ARS/sapba
ckup/.behyfogg.cmd
'@/oracle/ARS/sapbackup/..behyfogg..cmd^'
'host '/usr/sap/ARS/SYS/exe/run/brtools -f delete /oracle/ARS/sapbackup/..behyfog
g..cmd';^'
'run { allocate channel sbt_1 device type 'SBT_TAPE'^'
'parms 'ENV=(NB_ORA_SAP=/oracle/ARS/112_64/dbs/initARS.utl,NB_ORA_POLICY=SAP_NonP
rodDB_Tape,NB_ORA_CLIENT=de08u3543-bkp)';^'
'allocate channel sbt_2 device type 'SBT_TAPE'^'
'parms 'ENV=(NB_ORA_SAP=/oracle/ARS/112_64/dbs/initARS.utl,NB_ORA_POLICY=SAP_NonP
rodDB_Tape,NB_ORA_CLIENT=de08u3543-bkp)';^'
'allocate channel sbt_3 device type 'SBT_TAPE'^'
'parms 'ENV=(NB_ORA_SAP=/oracle/ARS/112_64/dbs/initARS.utl,NB_ORA_POLICY=SAP_NonP
rodDB_Tape,NB_ORA_CLIENT=de08u3543-bkp)';^'
'allocate channel sbt_4 device type 'SBT_TAPE'^'
'parms 'ENV=(NB_ORA_SAP=/oracle/ARS/112_64/dbs/initARS.utl,NB_ORA_POLICY=SAP_NonP
rodDB_Tape,NB_ORA_CLIENT=de08u3543-bkp)';^'
'allocate channel sbt_5 device type 'SBT_TAPE'^'
'parms 'ENV=(NB_ORA_SAP=/oracle/ARS/112_64/dbs/initARS.utl,NB_ORA_POLICY=SAP_NonP
rodDB_Tape,NB_ORA_CLIENT=de08u3543-bkp)';^'
'allocate channel sbt_6 device type 'SBT_TAPE'^'
'parms 'ENV=(NB_ORA_SAP=/oracle/ARS/112_64/dbs/initARS.utl,NB_ORA_POLICY=SAP_NonP
rodDB_Tape,NB_ORA_CLIENT=de08u3543-bkp)';^'
'backup incremental level 0 tag behyfogg format 'ARS_behyfogg.%s_%p' filesperset
23 check logical^'
'database;^'
' }^'
'list backup of database tag behyfogg;^'
'exit;^'
BR0280I BRBACKUP time stamp: 2012-02-22 21.41.51
BR0279E Return code from 'SHELL=/bin/sh /oracle/ARS/112_64/bin/rman nocatalog': 1
BR0522E 414 of 816 files / save sets processed by RMAN
BR0536E RMAN call for database instance ARS failed
BR0280I BRBACKUP time stamp: 2012-02-22 21.41.51
BR0506E Full database backup (level 0) using RMAN failed
BR0056I End of database backup: behyfogg.fnr 2012-02-22 21.41.51
BR0280I BRBACKUP time stamp: 2012-02-22 21.41.54
BR0054I BRBACKUP terminated with errors
|
|
|
|
|
|