Pavan DBA's Blog

The DBA Knowledge Store

Bug#6035495 in 10g standby environment

Posted by Pavan DBA on December 31, 2009


Today 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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: