The backup of one of our production servers suddenly has following errors in the log.
RMAN-03014: implicit resync of recovery catalog failed
RMAN-03009: failure of partial resync command on default channel at 10/06/2008 10:54:54
ORA-01400: cannot insert NULL into ("RMANCAT"."ROUT"."ROUT_SKEY")
It looks like this is a hit of Oracle bug
Bug No:5528078
ORA-01400: CANNOT INSERT NULL INTO ("RMAN"."ROUT"."ROUT_SKEY")
The strange thing is I didn't had any changes lately in production. I am not quite sure what event has triggered this bug.
The workaround involve changing script $ORACLE_HOME/rdbms/admin/recover.bsq and UPGRADE CATALOG .
This error usually happens after database migration.
1 comment:
Hey Yingkuan,
Just bumped over your blog.Never knew about it :-). I shall be adding it to my blogroll.
Regards
Aman....
Post a Comment