Take a closer look
If you look at this:
SQL> alter database clear unarchived logfile group 1;
Database altered.
SQL> alter database clear unarchived logfile group 2;
Database altered.
SQL> alter database clear unarchived logfile group 3;
Database altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1
0 5242880 1 YES CURRENT
1096021 09-MAY-09
2 1
0 5242880 1 YES UNUSED
1087538 09-MAY-09
3 1
0 5242880 1 YES UNUSED
1091468 09-MAY-09
It's NOT the same as this:
I go back into recovery mode and my status says clearing_current. Is this
the expected behavior?
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
Database altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1
517 5242880 1 YES CLEARING_CURRENT
1096021 09-MAY-09
3 1
0 5242880 1 YES UNUSED
1091468 09-MAY-09
2 1
0 5242880 1 YES UNUSED
1087538 09-MAY-09
The 517 sequence number is still in transition.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb