Home » Server Options » Data Guard » Standby not applying archived redo logs / fixed
Standby not applying archived redo logs / fixed [message #240772] Fri, 25 May 2007 13:26 Go to next message
mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO
Senior Member

The ALERT log shows me that I'm now getting archived redo, but the MRP0 has been halted because archivelogs beyond "End-Of-REDO" are encountered...

Media Recovery Log /u04/oradata/MYDB/logs/archive/arch_1_540.arc
Identified end-of-REDO for thread 1 sequence 540
Identified end-of-REDO for thread 1 sequence 540
Media Recovery End-Of-Redo indicator encountered
Media Recovery Applied until change 2481617
MRP0: Media Recovery Complete: End-Of-REDO
Media Recovery archivelogs detected beyond End-Of-REDO
Resetting standby activation ID 2164286092 (0x8100628c)
MRP0: Background Media Recovery process shutdown

Resulting in:

SQL> select sequence#,applied from v$archived_log order by sequence#;

SEQUENCE# APP
---------- ---
535 YES
536 YES
537 NO
538 NO
539 NO
540 NO
541 NO
542 NO
543 NO
544 NO

To fix this, I removed the physical Archived Redo Log files on the Standby Server (numbers 537-544), shutdown and restarted the Standby Database and let FAL do the recovery. Worked great. [It broke communications at the firewall, but I figure that's a local issue.] Having them look at port settings.

M
Re: Standby not applying archived redo logs / fixed [message #241758 is a reply to message #240772] Wed, 30 May 2007 10:07 Go to previous message
mlgoins
Messages: 116
Registered: March 2007
Location: Denver, CO
Senior Member

Color this one done. Cool

The "End-of-REDO" simply tells the Standby Database that this is all it's going to get from the Primary (which is about to become a Standby Database itself). It's like the signal the Standby is looking for to know that a Switchover is about to take place. This flags the last REDO that will be applied on the Standby Database before it becomes the Primary.
Previous Topic: Yet another topic -- archiving being done by another process
Next Topic: DATA TRANSFER FROM PRIMARY TO STANDBY
Goto Forum:
  


Current Time: Thu Mar 28 05:10:19 CDT 2024