Logical standby after upgrade from 11.1.0.7. to 11.2.0.2 stops applying changes
I have a problem while upgrading database using logical standby. I created physical standby (11.1.0.7 AIX 6.1.) and converted it into logical. Logical apply process works fine until I upgraded the database to version 11.2.0.2 - AIX 6.1.
Here is the state of standby processes:
SELECT TYPE, STATUS, HIGH_SCN FROM V$LOGSTDBY;
TYPE STATUS HIGH_SCN
----------- -------------------------------------------------- ---------------
COORDINATOR ORA-16116: no work available 12468151290584
ANALYZER ORA-16116: no work available 12468151308603
APPLIER ORA-16124: transaction 8 7 605451 is waiting on an 12468151290605
other transaction
APPLIER ORA-16124: transaction 25 15 103422 is waiting on 12468151290607
another transaction
...
Appliers are waiting for other transactions, but no other transaction is being mined. In alert.log I see following notes: