-
standby db (CLEARING_CURRENT) status
When I issue select * from v$log on my standby DB I see the following:
QL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIM
------------- ---------
1 1 202 5242880 1 YES CLEARING_CURRENT
332659 20-APR-09
3 1 201 5242880 1 YES CLEARING
331949 20-APR-09
2 1 200 5242880 1 YES CLEARING
326095 20-APR-09
Can somebody give me a good explanation about CLEARING_CURRENT status.
Does this mean that the archive for sequence 202 has not been applied yet?
FYI, from my standby DB
SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;
SEQUENCE# APP
---------- ---
197 YES
198 YES
199 YES
200 YES
201 YES
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|