ORA-01403: no data found, Standby cannot apply

Yesterday afternoon, logical standby suddenly failed to apply. The database reported the following error:

Warning: Apply error received: ORA-26714: User error encountered while applying. Clearing.

* ** 2010-03-16 20:04:48. 484

Knahcapplymain: encountered error = 12801

* ** 2010-03-16 20:04:48. 515

Ksedmp: internal or fatal error

ORA-12801: error signaled in parallel query server P004

ORA-01403: no data found

Check the database and find that the following SQL statement cannot be applied:

Update MES. BOARD_BARCODE

Set

CURRENT_SEQUENCE = 23

Where

BARCODE_NO = 'a3p0046010 'and

CURRENT_SEQUENCE = 22 and

ROWID = 'aaaaabpaabniiaa0'

This is a standby SQL statement. The original SQL statement of the master database should be:

Update MES. BOARD_BARCODE

Set

CURRENT_SEQUENCE = CURRENT_SEQUENCE + 1

Where

BARCODE_NO = 'a3p0046010'

No answer was found for Google/baidu/metalink. To restore the application as soon as possible, back up the broken Standby for future research and try again for Standby.

If anyone has experience in this area, please do not hesitate to provide a solution!

The database version is 10.2.0.3. windows.

Supplement:

This problem has been solved. It turns out that my colleague skipped an SQL statement and did not execute it, resulting in data inconsistency. Several tables are associated with primary foreign keys.

ORA-01172, ORA-01151 error handling

ORA-00600 [2662] troubleshooting

Troubleshooting for ORA-01078 and LRM-00109

Notes on ORA-00471 Processing Methods

ORA-00314, redolog corruption, or missing Handling Methods

Solution to ORA-00257 archive logs being too large to store