Home » Server Options » Data Guard » log applied stopped "ORA-01442: column to be modified to NOT NULL is already NOT NULL" (11g, 11.2.0.1, window server 2008)
log applied stopped "ORA-01442: column to be modified to NOT NULL is already NOT NULL" [message #600769] Tue, 12 November 2013 05:11 Go to next message
ishika_20
Messages: 334
Registered: December 2006
Location: delhi
Senior Member
Dear All,

Log apply has stopped at logical standby server due to the below reason.

"ORA-01442: column to be modified to NOT NULL is already NOT NULL"
"ORA-16222: automatic Logical Standby retry of last action"
"Apply LWM 8261872281279, HWM 8261872281279, SCN 8261872281278"

EVENTS >> CLOB

If it is already NOT NULL then why it is getting stopped in between the shipment? Please assist me to know the reason about it.

Waiting for your kind response...

Regards,
Ishika
Re: log applied stopped "ORA-01442: column to be modified to NOT NULL is already NOT NULL" [message #600770 is a reply to message #600769] Tue, 12 November 2013 05:30 Go to previous message
John Watson
Messages: 4400
Registered: January 2010
Location: Global Village
Senior Member
If you are 100% sure of the environment, this may get you out of trouble:

alter database start logical standby apply skip failed transaction;

(it may also put you into a dreadful mess if the situation is more complicated that you say)
Previous Topic: log archive miss
Next Topic: Data Guard
Goto Forum:
  


Current Time: Tue Jul 29 04:18:19 CDT 2014

Total time taken to generate the page: 0.15510 seconds