Standby not applying archived redo logs / fixed [message #240772] |
Fri, 25 May 2007 13:26 |
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
|
|
|
|