OraFAQ Forum: Data Guard » CLEARING Status for logs

Home » Server Options » Data Guard » CLEARING Status for logs

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

CLEARING Status for logs [message #528504]

Tue, 25 October 2011 06:06

mamingui
Messages: 83
Registered: July 2006

Member

Hi All,

I'm using oracle 10.2.0.3. on windows 2003. I've implemented physical stanby and it was working fine until last week. No problem on primary DB. Archived logs are sent normally to standby. And standby DB is also able to apply the archived logs coming from primary.
I've already check data on standby DB after opening it with READ ONLY option : data are exported normally and I can read them.
The issue is the status of logs in view v$log on standby database.
select group#,status from v$log;
group# status
1 clearing_current
2 clearing
3 clearing

I've tried this :

On standby DB :

SQL> RECOVER MANAGED STANDBY DATABASE CANCEL;
Media recovery complete.
SQL> alter database open read only;

complete.
SQL> alter database clear logfile group 1;
Database altered.
SQL> alter database clear logfile group 2;
Database altered.
SQL> alter database clear 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 25-OCT-11
2 1 0 5242880 1 YES UNUSED
1087538 25-OCT-11
3 1 0 5242880 1 YES UNUSED
1091468 25-OCT-11

I go back into recovery mode and my status says clearing_current.

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 25-OCT-11
3 1 0 5242880 1 YES UNUSED
1091468 25-OCT-11
2 1 0 5242880 1 YES UNUSED
1087538 25-OCT-11

I know that the good status is ACTIVE or CURRENT or INACTIVE...

Someone knows how to fiw this issue.

Thanks in advance for help.

Regards.

Report message to a moderator