This discussion is archived
2 Replies Latest reply: Jan 9, 2013 12:28 PM by 982580 RSS

Standby redo log status

982580 Newbie
Currently Being Moderated
Can anyone explain what the status of clearing means when viewing standby redo log status?

SQL> select status from v$log;

STATUS
------------------------------------------------
CLEARING
CLEARING
CURRENT

This is a bit different to what we'd see on an open database.
  • 1. Re: Standby redo log status
    mseberg Guru
    Currently Being Moderated
    Hello;

    Log is being re-created as an empty log.

    In a Standby database the regular redo are not used ( when not in PRIMARY MODE) only the standby redo logs are used. Sometimes as buffers for the redo coming from the primary.

    You should be able to change the status by doing a ALTER SYSTEM SWITCH LOGFILE on your primary.

    This note may help:

    Online Redo Logs on Physical Standby [ID 740675.1]

    Also

    Take a look at v$standby_log too.

    http://docs.oracle.com/cd/B28359_01/server.111/b28320/dynviews_3068.htm

    Best Regards

    mseberg
  • 2. Re: Standby redo log status
    982580 Newbie
    Currently Being Moderated
    Many thanks, that helps!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points