standby db (clearing_current) status
All:
Can somebody please explain why this happens or if this is normal behavior.
I am running version Oracle 10.2.0.3 version of the Oracle database.
When in managed recovery mode (been running like this for a week or so).
I see my status as "CLEARING_CURRENT"
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
2 1 515 5242880 1 YES CLEARING
1087538 09-MAY-09
3 1 516 5242880 1 YES CLEARING
1091468 09-MAY-09
I take DB out of managed recovery mode and into read only mode and clear
log files and everything looks okay now.
SQL> RECOVER MANAGED STANDBY DATABASE CANCEL;
Media recovery complete.
SQL> alter database open read only;
complete.
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
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