Skip to main content
Delphix

TB009 Queries May Fail Against VDBs Containing Datafiles With Non-Zero Final Blocks

 

 

Alert Type

Data Availability

Impact

If the last block of a datafile on a source database contains data, a query against a VDB provisioned from that source may fail with an ORA-08103 error due to missing data.

Contributing Factors

This issue occurs in the following Delphix Releases:

  • Delphix Engine 3.1.3.0
  • Delphix Engine 3.1.3.1

This issue may occur on VDBs provisioned from a source which has had data written to the last block of a datafile after the initial load was completed.

Symptoms

ORA-08103 errors while running queries on VDBs.  

Example:

ERROR at line 1: 
ORA-08103: object no longer exists 
ORA-06512: at "SYS.DBMS_STATS", line 18408 
ORA-06512: at "SYS.DBMS_STATS", line 18429 
ORA-06512: at line 1 

Relief/Workaround

The Delphix Engine should be upgraded to the latest version of Delphix Engine 3.1 or later releases. Contact Delphix Support to arrange an upgrade.

Resolution

The issue is addressed in Delphix Engine 3.1.3.2 and later releases.