Media Recovery Waiting for thread 1 sequence <SEQUENCE#> (in transit)
I am trying to convert a physical standby to logical standby.
All log have been transfered and applied on this physical standby. Following document for the standby on RAC environement
SQL> alter database recover managed standby database cancel;
SQL> ALTER SYSTEM SET CLUSTER_DATABASE=FALSE SCOPE=SPFILE;
SQL> SHUTDOWN ABORT;
SQL> STARTUP MOUNT EXCLUSIVE;
SQL> ALTER DATABASE RECOVER TO LOGICAL STANDBY 'p1108s2';
It takes long time.
The alert file shows
'Media Recovery Waiting for thread 1 sequence 1541 (in transit)'
I start the active redo apply and make sure all received log are applied and no gap exist.