Database Administration (MOSC)

MOSC Banner

Standby redo log files - thread#0???

edited Oct 29, 2013 8:06AM in Database Administration (MOSC) 4 commentsAnswered
 Oracle 11.2.0.2 - standalone primary and standby databases running on Linux
 I've been playing around with writing a set of scripts to compare the primary and the standby database in preparation for a switchover test.

I am comparing the number and size of the redo and standby redo log files for both the primary and the standby.  Low and behold some of the standby redo log files are using thread# 0:

SQL> select thread# from v$thread;

   THREAD#
----------
         1

SQL> select group#, thread#, bytes
  2  from v$standby_log;

    GROUP#    THREAD#      BYTES
---------- ---------- ----------
         6          1  104857600
         7          1  104857600
         8          1  104857600
         9          0  104857600

SQL>

I'm assuming that for a standalone database the thread# still matters, right?  I am guessing that the standby log files in thread# 0 are being ignored.  (Is there a way to verify which standby log files are actually being used?)

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