ORA-03114: not connected to ORACLE
953153Jul 31 2012 — edited Aug 10 2012I have upgraded my db from 10g to 11g . Earlier db backups were configured to tape but after upgrade we have moved to disk. While deleting the backups to tape i am getting the following error :
RMAN Logfile
===========
allocated channel: ORA_MAINT_SBT_TAPE_2
channel ORA_MAINT_SBT_TAPE_2: SID=221 device type=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_2: Veritas NetBackup for Oracle - Release 6.5 (2007072323)
sent command to channel: ORA_MAINT_SBT_TAPE_2
sent command to channel: ORA_MAINT_SBT_TAPE_2
Deleting the following obsolete backups and copies:
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 58989433 2012/07/04 09:01:51
Backup Piece 58989833 2012/07/04 09:01:51 traxprd2_ntnf7uik_1_1_787741268
...................................................................................
Backup Piece 58990230 2012/07/14 17:47:14 c-1459067732-20120714-0c
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of delete command on ORA_MAINT_SBT_TAPE_2 channel at 07/31/2012 17:08:15
ORA-03114: not connected to ORACLE
Recovery Manager complete.
$
All the listners , tnsfiles are perfect . no user process were killed in between while deletion. Library link for the backup is fine.
Please suggest to overcome error.