Mrp0 Wait_for_gap Solved

Asked By 0 points N/A Posted on -
qa-featured

Hello, I am new to Dataguard’s setup and recently connected to a Dataguard setup for testing purposes. Unfortunately, I deleted some archive log files from my main database, which canceled the Standby update. To try to resolve the problem, I resynchronized the SCN in sleep mode using an incremental backup. After recovery, the two SCNs were identical, but the Recovery Service Restart (MRP) still displays mrp0 WAIT_FOR_GAP and waits for my missing archive logs. However, the new archive logs are provided in sleep mode. An idea of what I missed or what should I do?

SHARE
Answered By 90 points N/A #319995

Mrp0 Wait_for_gap Solved

qa-featured

In Oracle 12c, it is no longer necessary to perform the downstream “hand-by-hand” restore. Some commands in RMAN do this automatically using the primary database service (G12DGGOP_DG). So restore in mounted mode: RESTORING THE DATABASE FROM THE NOREDO G12DGGOP_DG SERVICE USING THE COMPRESSED SAFEGUARD SECTION 100M.

Then, the standby control file is restored to nomount (after shutdown): RESTORE STANDBY CONTROLFILE FROM SERVICE G12DGGOP_DG;

Related Questions