3 Replies Latest reply: Jan 7, 2013 8:08 AM by John-MK RSS

    Standby FRA is getting FULL, and behind from Primary

    John-MK
      Hi,

      Standby DB FRA is 80% full, and also 30 minutes behind.

      11.2.0.3 on RHLinux

      On standby db I connected to RMAN with nocatalog and

      delete noprompt archivelog all;

      It says RMAN-08120 ...cannot delete archivelogs listed, I think they are not applied to standby db yet.

      Primary
      select thread#,max(sequence#) from v$archived_log group by thread#

      THREAD# MAX(SEQUENCE#)
      ---------- --------------
           1     10485

      standby
      select thread#,max(sequence#) from v$archived_log where applied='YES' group by thread#

      THREAD# MAX(SEQUENCE#)
      ---------- --------------
           1     10342

      Edited by: John-MK on Jan 5, 2013 12:29 PM