Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> ORA-01400: cannot insert NULL into ("QRMAN"."BP"."HANDLE")
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-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 at03/22/2007 15:31:05
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
![]() |
![]() |