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

MOSC Banner

MRP0 WAIT_FOR_GAP '10.2.0.1

Greetings!

deployed a fresh physical standby with 10gR2 base release 10.2.0.1 - log ship services running, log apply services NOT.

Managed Standby Recovery starting Real Time Apply

Media Recovery start incarnation depth : 3, target inc# : 8, irscn : 12658392655

Media Recovery Waiting for thread 1 sequence 2 branch(resetlogs_id) 751724108

Fetching gap sequence in thread 1 branch(resetlogs_id) 751724108, gap seq 2-2

Tue Mar 21 09:59:39 2017

Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT

+++++++++++++++

SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;

PROCESS   STATUS

--------- ------------

ARCH      CONNECTED

ARCH      CONNECTED

ARCH      CONNECTED

RFS       IDLE

MRP0      WAIT_FOR_GAP

+++++++++++++++++++

SQL> select NAME,APPLIED,STATUS,END_OF_REDO,FAL from v$archived_log where SEQUENCE#=2;

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