Mrp0 Wait_for_gap Solved

Asked By Ryan J Hamilton 0 points N/A Posted on - 07/08/2019

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?

• Status: Open
• Question Views: 250
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Database
• Question Tags: Data

Answered By Hanley Samson 90 points N/A #319995

Mrp0 Wait_for_gap Solved

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;

About Hanley Samson

Questions
62

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/08/2019
• Question Category: Database