High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Media Recovery Waiting for thread 1 sequence <SEQUENCE#> (in transit)

Hi

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center