Database Backup and Recovery (MOSC)

MOSC Banner

+DATA diskgroup filled up on ASM on standby server and now redo isn't being applied

edited Feb 21, 2012 5:35AM in Database Backup and Recovery (MOSC) 4 commentsAnswered
+DATA diskgroup filled up on ASM on standby server and now redo isn't being applied, space is no longer an issue but I am getting similar issues on multiple databases, any ideas / hints how to recover from this?

 on primary
SQL> select max(sequence#), thread# from v$archived_log group by thread#;

MAX(SEQUENCE#)    THREAD#
-------------- ----------
        111068          1
         92725          2


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

   THREAD# MAX(SEQUENCE#)
---------- --------------
         1         109560
         2          91306

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