Home » RDBMS Server » Backup & Recovery » database session for channel sbt_4 terminated unexpectedly (Recovery Manager: Release 11.2.0.2.0, AIX 6.1)
database session for channel sbt_4 terminated unexpectedly [message #544753] Thu, 23 February 2012 10:45 Go to next message
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 Go to previous messageGo to next message
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

Re: database session for channel sbt_4 terminated unexpectedly [message #544757 is a reply to message #544753] Thu, 23 February 2012 11:02 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Tape issue, check your tape logs.

[Updated on: Thu, 23 February 2012 11:17] by Moderator

Report message to a moderator

Re: database session for channel sbt_4 terminated unexpectedly [message #544759 is a reply to message #544757] Thu, 23 February 2012 11:10 Go to previous messageGo to next message
jjosserand
Messages: 3
Registered: February 2012
Location: Boise, ID
Junior Member
Thanks. I am, unfortunately, not in control of the backup server, but will send my backup run log to that team and ask for review of the tape logs, then let you know here what was found.
Re: database session for channel sbt_4 terminated unexpectedly [message #544772 is a reply to message #544759] Thu, 23 February 2012 12:25 Go to previous message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
At one location we were experiencing same issue, our backups allocated from 4 - 8 channels and when there were not enough tape channels available, this error occurred.

The cause at that time was overload of the tape servers (not enough servers for the size of the site).

You need to get the storage managers involved.
Good luck!

[Updated on: Thu, 23 February 2012 12:27] by Moderator

Report message to a moderator

Previous Topic: Recovery using copied oracle folder
Next Topic: Recover Database Error
Goto Forum:
  


Current Time: Sun Dec 22 00:36:21 CST 2024