Skip to main content

Posts

Showing posts from April, 2014

MRP: Background Media Recovery process shutdown or NO MRP0 EXISTS !

MRP: Background Media Recovery process shutdown  The main problem was standby db not applying the archive redo received from production DB. The MRP0 process was missing. When we query the following SQL it returned no rows. SQL> SELECT PROCESS FROM V$MANAGED_STANDBY WHERE PROCESS LIKE 'MRP%'; no rows returned. Suspicious list of errors showing on Standby Server alert: ORA-16401: archive log rejected by Remote File Server (RFS) MRP: Background Media Recovery process shutdown  To Drill down check the error message in dataguard status: select severity,        error_code,        message,        to_char(timestamp, 'DD-MON-YYYY HH24:MI:SS') "TIMESTAMP"   from v$dataguard_status  order by timestamp desc; You will find an error like following: MRP0: Detected orphaned datafiles!  This could be for two reason. 1. There may me UNNAMED datafiles To Check: select file#,name from v$datafile where name like '%UNNAMED%'; if no