standby db (clearing_current) status‏

[PaulH]

If you check the primary, you would find something like the following result:

SQL> select * from v$log;
GROUP#     THREAD#    SEQUENCE#   BYTES     MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ------- --- -------
         1          1        517    5242880       1 NO  CURRENT

You are correct my primary DB does say current (see below) but your not answering my question. Why does my status switch back to clearing_current after I cleared it and go back into recovery mode. I would have expected it to say current or am I missing something.

Thanks



SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 529 5242880 1 YES INACTIVE
1108113 11-MAY-09

2 1 530 5242880 1 NO CURRENT
1108151 11-MAY-09

3 1 528 5242880 1 YES INACTIVE
1108095 11-MAY-09