Standby- What to do when MRP0 WAIT_FOR_LOG ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Standby- What to do when MRP0 WAIT_FOR_LOG ?

  1. #1
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    Standby- What to do when MRP0 WAIT_FOR_LOG ?

    Hi all
    i have created a standby database and log sequence on the primary and standby are not in sync.
    Primary= 14211
    standby=14204
    When I checked the alert log there is no error mesage not

    PROCESS STATUS CLIENT_P SEQUENCE# BLOCK# ACTIVE_AGENTS KNOWN_AGENTS
    --------- ------------ -------- ---------- ---------- ------------- ------------
    ARCH CONNECTED ARCH 0 0 0 0
    ARCH CONNECTED ARCH 0 0 0 0
    MRP0 WAIT_FOR_LOG N/A 14205 0 0 0

    The following statement also is showing that dest_id 3 which the standby in question destination is "inactive"


    SQL> select dest_id, status from v$archive_dest;

    DEST_ID STATUS
    ---------- ---------
    1 VALID
    2 VALID
    3 INACTIVE
    4 INACTIVE
    5 INACTIVE

    What to do when MRP0 WAIT_FOR_LOG ?
    Please advise
    Thanks
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

  2. #2
    Join Date
    Dec 2001
    Location
    Baltimore, MD
    Posts
    372

    Standby logs are not getting shipped/applied- need help please

    Standby logs are not getting shipped/applied- need help please
    Arsene Lupain
    The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width