Database Backup and Recovery (MOSC)

MOSC Banner

Standby database MRP problem WAIT_FOR_GAP

Hi,

Previously there was a configured stb database but since a lot of time had passed when the databases were not synchronized due to lack of space in the reco group I did again duplicate database PRIMDB FOR STANDBY NOFILENAMECHECK; Oracle 11.2.0.4.0 Backup is configured with ZDLRA. After rman duplicate I have problem with MRP:

MRP0 WAIT_FOR_GAP 1 121856

On STB: select current_scn from v$database result is 1.2492E+11

On PRIM: select current_scn from v$database result is 1.2498E+11;

SELECT name, sequence#, archived, status FROM v$archived_log WHERE sequence# = 121857; sequence 121857 is archived (yes)

After command ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION

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