Standby FRA is getting FULL, and behind from Primary
John-MKJan 5 2013 — edited Jan 7 2013Hi,
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