Database Backup and Recovery (MOSC)

MOSC Banner

media recovery(MRP) stopped applying from standby redologs

edited Oct 13, 2020 5:51PM in Database Backup and Recovery (MOSC) 3 commentsAnswered ✓

Hi

media recovery after some time periodicly stop applying redo logs to my standby server.

 select * from

 (select dest_id,thread#,sequence#,applied,status,first_time,next_time from v$archived_log

  order by sequence# desc) where rownum < 100

  / 2  3  4


  DEST_ID  THREAD# SEQUENCE# APPLIED  S FIRST_TIM NEXT_TIME

---------- ---------- ---------- --------- - --------- ---------

     1     1    4296 NO    A 13-OCT-20 13-OCT-20

     1     1    4295 NO    A 13-OCT-20 13-OCT-20

     1     1    4294 NO    A 13-OCT-20 13-OCT-20

     1     1    4293 NO    A 13-OCT-20 13-OCT-20

     1     1    4292 NO    A 13-OCT-20 13-OCT-20

     1     1    4291 NO    A 13-OCT-20 13-OCT-20

     1     1    4290 NO    A 13-OCT-20 13-OCT-20

     1     1    4289 NO    A 13-OCT-20 13-OCT-20

     1     1    4288 NO    A 13-OCT-20 13-OCT-20

     1     1    4287 NO    A 13-OCT-20 13-OCT-20

     1     1    4286 NO    A 13-OCT-20 13-OCT-20


  DEST_ID  THREAD# SEQUENCE# APPLIED  S FIRST_TIM NEXT_TIME

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center