I have a simple 2 node standby setup. On my primary, I query v$archived_log for my secondary destination and it correctly shows the logs that have been archived and applied on the standby. However, the applied flag is not set for some logs, but the alert.log on the standby says it was applied.
Can anybody enlighten me or point me to some documentation that explains this?Code:1 select sequence#, dest_id, archived, applied, completion_time 2 from v$archived_log 3 where dest_id = 2 4 and sequence# > 36925 5* order by sequence# [email protected]> / SEQUENCE# DEST_ID ARC APP COMPLETION_TIME ---------- ---------- --- --- ------------------- 36926 2 YES YES 09/12/2004 20:17:46 36927 2 YES YES 09/12/2004 20:18:09 36928 2 YES YES 09/12/2004 20:18:36 36929 2 YES YES 09/12/2004 20:18:59 36930 2 YES NO 09/12/2004 20:25:49 36931 2 YES YES 09/12/2004 20:25:51 36932 2 YES YES 09/12/2004 20:56:02 36933 2 YES YES 09/12/2004 21:26:29 36934 2 YES YES 09/12/2004 21:56:55 36935 2 YES YES 09/12/2004 22:27:21 36936 2 YES YES 09/12/2004 22:57:47 36937 2 YES YES 09/12/2004 23:28:12 12 rows selected. Elapsed: 00:00:00.21 Media Recovery Waiting for thread 1 seq# 36922 Media Recovery Log /u07/oraarch/xxx/1_36922.dbf Media Recovery Waiting for thread 1 seq# 36923 Media Recovery Log /u07/oraarch/xxx/1_36923.dbf Media Recovery Waiting for thread 1 seq# 36924 Media Recovery Log /u07/oraarch/xxx/1_36924.dbf Media Recovery Waiting for thread 1 seq# 36925 Media Recovery Log /u07/oraarch/xxx/1_36925.dbf Media Recovery Log /u07/oraarch/xxx/1_36926.dbf Media Recovery Log /u07/oraarch/xxx/1_36927.dbf Media Recovery Log /u07/oraarch/xxx/1_36928.dbf Media Recovery Log /u07/oraarch/xxx/1_36929.dbf Media Recovery Log /u07/oraarch/xxx/1_36930.dbf Media Recovery Log /u07/oraarch/xxx/1_36931.dbf Media Recovery Waiting for thread 1 seq# 36932 Media Recovery Log /u07/oraarch/xxx/1_36932.dbf Media Recovery Waiting for thread 1 seq# 36933 Media Recovery Log /u07/oraarch/xxx/1_36933.dbf Media Recovery Waiting for thread 1 seq# 36934 Media Recovery Log /u07/oraarch/xxx/1_36934.dbf Media Recovery Waiting for thread 1 seq# 36935 Media Recovery Log /u07/oraarch/xxx/1_36935.dbf Media Recovery Waiting for thread 1 seq# 36936 Media Recovery Log /u07/oraarch/xxx/1_36936.dbf Media Recovery Waiting for thread 1 seq# 36937 Media Recovery Log /u07/oraarch/xxx/1_36937.dbf Media Recovery Waiting for thread 1 seq# 36938 $ r ls ls -l /u07/oraarch/xxx/1_36930.dbf -rw-r----- 1 oracle dba 32668160 Sep 12 20:25 /u07/oraarch/xxx1/1_36930.dbf




Reply With Quote