Home » Server Options » Data Guard » CLEARING Status for logs
CLEARING Status for logs [message #528504] Tue, 25 October 2011 06:06 Go to next message
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.
Re: CLEARING Status for logs [message #528509 is a reply to message #528504] Tue, 25 October 2011 06:58 Go to previous messageGo to next message
John Watson
Messages: 4710
Registered: January 2010
Location: Global Village
Senior Member
This is normal for a standby database. I don't know what you are trying to do, but you probably want to look at v$standby_log instead.
Re: CLEARING Status for logs [message #529251 is a reply to message #528509] Sun, 30 October 2011 06:02 Go to previous messageGo to next message
lonion
Messages: 97
Registered: August 2011
Location: shenzhen,China
Member
can u query the data from the standby database?is it normally working ?
Re: CLEARING Status for logs [message #530748 is a reply to message #529251] Thu, 10 November 2011 04:03 Go to previous message
mamingui
Messages: 83
Registered: July 2006
Member
yes, data is working
Previous Topic: Query regarding standby server
Next Topic: 10g dataguard slow apply and reset log issue
Goto Forum:
  


Current Time: Fri Oct 31 18:50:06 CDT 2014

Total time taken to generate the page: 0.11024 seconds