Sunday, October 12, 2014

Bug#6035495 in 10g standby environment

Bug#6035495 in 10g standby environment

I got a bug in one of my oracle 10g(10.2.0.3) standby database.
following are the details
Error Number : ORA-19909
Error Message : datafile 1 belongs to an orphan incarnation
Cause: it is due to bug 6035495.
Action : Rebuild Standby database
Permanent Fix : Apply 10.2.0.4 patch to both primary and standby databases.
For more information refer to metalink document 6035495.8.
P.S: The above error may also occur when an incomplete recovery was performed on the primary database.
Also, the following are the main things which are fixed & added when upgrading to 10.2.0.4 Patch

New additions

It synchronizes the cpu performance with the database performance (This feature is usually not included in all the patch set.
      But in this patch, this feature is inherited from all the patch sets up to Jan 2008 and is included as a whole in this patch set)


Oracle Configuration Manager 10.2.7.1 – This OCM will create a schema Oracle_OCM in our database which will collect the database
      configuration information on a monthly basis.


Bug Fixes:

·         ORA-12996 / ORA-12998 / corruption from ALTER TABLE DROP UNUSED COLUMNS CHECKPOINT
·         ORA-0600 [keltnfy-ldminit] – This ORA-600 error happens when resources are not available for oracle. (In our case, this error has occurred only
             once two times . We can confirm the exact root cause only based on the number of occurrences. With just one time, we can’t determine which
        resource is not enough for Oracle)
·         Slow performance of data pump during Export/Import
·         ALTER TABLE DDL can fail with ORA-2050 / ORA-60 if the table has
–          a TRIGGER using %type variable of the other TABLE and DBLINK.
–          a materialized view (the master table is the target table of ALTER TABLE.)
·         The performance of some queries which involve large sorts can be CPU intensive due to the memory allocation pattern used by the sort.

No comments:

Post a Comment