Datapump data corruption due to read only standby using network link
We are running following environment:
1- Primary Oracle RAC 10.2.0.4.0 (CRS 10.2.0.4.0) on AIX 6.1 64 Bits
2- Standby Single Instance on AIX 6.1 64 Bits
We are taking backup using datapump from Standby in read only mode and run the Export from other DB using network link.
Today we restored the dump file (taken from read-only standby using networ-link) in a test database. User reported errors in reading XMLTYPE columns. Error descrption is as under:
XML Parsing failed
Even we cannot query the XMLTYPE field and it failes giving error XML Parsing failed.
I perfomed testing by exporting the table directly from standby database opened R/W. When restored that dump file there was no error.
2- Standby Single Instance on AIX 6.1 64 Bits
We are taking backup using datapump from Standby in read only mode and run the Export from other DB using network link.
Today we restored the dump file (taken from read-only standby using networ-link) in a test database. User reported errors in reading XMLTYPE columns. Error descrption is as under:
XML Parsing failed
Even we cannot query the XMLTYPE field and it failes giving error XML Parsing failed.
I perfomed testing by exporting the table directly from standby database opened R/W. When restored that dump file there was no error.
0