DataGuard - a solution about the Recover problem in Physical Standby

xiaoxiao2021-03-06  107

The following prompt appears during the Recover process:

Media Recovery Log /global/oradata/ctsdb/archive/arch1_2574.logIdentified end-of-REDO for thread 1 sequence 2574Identified end-of-REDO for thread 1 sequence 2574Media Recovery End-Of-Redo indicator encounteredMedia Recovery Applied until change 2404883MRP0: Media Recovery Complete: End-of-Redo

I thought it was because the RFS timeout truncated this archive, so I changed this archive FTP on Primary, I still report this prompt. After this prompt, MRP stopped, no longer made back Recovery, even continuously Archive to Primary.

Solution:

1. SHUTDOWN PRIMARY NORMAL

2. Replace the current Standby ControlFile of Control File

3. Open primary

4. Mount Standby:

SQL> Startup Mount;

5. Recover Standby:

SQL> Recover data;

6. In Recover, the Arch1_2574.log ends in Recover, and continues the archive log under Recover, until the Recover error does not find the required archive, do not open Standby, directly shutdown

7. Recreate Standby ControlFile on Primary, FTP to Standby, override the current Control File

8. Mount Standby:

SQL> Startup Nomount;

SQL> ALTER DATABASE MOUNT Standby Database;

9. Set to automatic recovery status:

SQL> Alter Database Recover Managed Standby Database Parallel 8 Disconnect from Session;

10. OK, end

转载请注明原文地址:https://www.9cbs.com/read-126956.html

New Post(0)