2 Replies Latest reply: Jan 9, 2013 2:28 PM by 982580 RSS

    Standby redo log status

    982580
      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
          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
            Many thanks, that helps!