ORA-01400: cannot insert NULL into ("QRMAN"."BP"."HANDLE")

From: RDP62 <rdperry3_at_bellsouth.net>
Date: 28 Mar 2007 07:29:03 -0700
Message-ID: <1175092143.284508.164740@p77g2000hsh.googlegroups.com>

We use RMAN and Veritas Net Backup to backup our archivelogs and level0 backups to tape. Prior to our upgrade from 9i to 10.2.0.2, our backups worked with no issues. Shortly after our upgrade(approximately 1 month) we began experiencing the following errors

BEFORE modifying the BP.HANDLE column to allow nulls:

RMAN> 2> 3> 4> 5> 6> 7>
RMAN-00571:

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

RMAN-00571:

RMAN-03002: failure of allocate command at 03/22/2007 15:31:05
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of partial resync command on default channel at

03/22/2007 15:31:05
ORA-01400: cannot insert NULL into ("QRMAN"."BP"."HANDLE")

AFTER modifying the BP.HANDLE column to allow null:

RMAN-03009: failure of backup command on t1 channel at 03/27/2007 15:33:14
ORA-00447: fatal error in background process continuing other job steps, job failed will not be re-run

The Oracle analyst that is working with me said this is a bug and transferred my request to the Development team for resolution. Unfortunately, I have been waiting almost a month for a fix. Has any one experienced this problem before. If so, how did you resolve it.

Thanks In Advance!!!!!!!!!!!!!!!!!!!!

Received on Wed Mar 28 2007 - 09:29:03 CDT