Dear All,
OLTP & ODS of UAT is configured on same server. Now, there are gaps between the applied scn and newest scn.
In alert log file, it's showing "REGISTERED LOGFILE". Does it may be due to network issue?
Below are the details -
UATODS
select applied_thread#,applied_scn,to_char(applied_time,'dd/mm/yyyy hh12:mi:ss'),newest_scn,applied_sequence#,newest_sequence# from DBA_LOGSTDBY_PROGRESS;
APPLIED_THREAD# APPLIED_SCN TO_CHAR(APPLIED_TIME,'DD/MM/YY NEWEST_SCN APPLIED_SEQUENCE# NEWEST_SEQUENCE#
1 8262395095418 06/12/13 09:24 8262399332388 34462 35512
select * from dba_logstdby_events order by event_time desc;
EVENT_TIME EVENT_TIMESTAMP START_SCN CURRENT_SCN COMMIT_SCN XIDUSN XIDSLT XIDSQN EVENT STATUS_CODE STATUS
11/12/13 09:08 11-DEC-13 09.08.23.010698 AM 8262395034181 8262395034186 8262395034192 10 23 524668 <CLOB> 16205 ORA-16205: DDL skipped due to skip setting
11/12/13 09:08 11-DEC-13 09.08.22.818513 AM 8262395033789 8262395033793 8262395033796 5 0 616801 <CLOB> 16205 ORA-16205: DDL skipped due to skip setting
UATOLTP
select sequence#, archived, resetlogs_time, first_time, next_time from v$archived_log order by 1 desc;
SEQUENCE# ARCHIVED RESETLOGS_TIME FIRST_TIME NEXT_TIME
35511 YES 15/07/13 14:12 17/12/13 10:46 17/12/13 11:26
select group#, sequence#, archived, status from v$log order by group#;
GROUP# SEQUENCE# ARCHIVED STATUS
1 35512 NO CURRENT
2 35510 YES INACTIVE
3 35511 YES INACTIVE
select group#, status, members from v$log order by group#, members;
GROUP# STATUS MEMBERS
1 CURRENT 2
2 INACTIVE 2
3 INACTIVE 2
alert log -
Mon Dec 16 22:06:33 2013
Archived Log entry 1095 added for thread 1 sequence 1095 ID 0x65998d9a dest 1:
Thread 1 cannot allocate new log, sequence 1097
Checkpoint not complete
Current log# 1 seq# 1096 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.324.832005481
Thread 1 advanced to log sequence 1097 (LGWR switch)
Current log# 2 seq# 1097 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.325.832005483
Mon Dec 16 22:06:39 2013
Archived Log entry 1096 added for thread 1 sequence 1096 ID 0x65998d9a dest 1:
Mon Dec 16 22:06:45 2013
Thread 1 cannot allocate new log, sequence 1098
Checkpoint not complete
Current log# 2 seq# 1097 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.325.832005483
Thread 1 advanced to log sequence 1098 (LGWR switch)
Current log# 3 seq# 1098 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.326.832005485
Mon Dec 16 22:06:48 2013
Archived Log entry 1097 added for thread 1 sequence 1097 ID 0x65998d9a dest 1:
Mon Dec 16 22:17:19 2013
RFS[11]: Selected log 4 for thread 1 sequence 35507 dbid 1489133003 branch 820851149
Mon Dec 16 22:17:19 2013
RFS LogMiner: Registered logfile [+ODS_DATA2/archive_ods/uatods_58c25dcb_35506_1_820851149.arc] to LogMiner session id [1]
Mon Dec 16 22:27:00 2013
RFS[11]: Selected log 5 for thread 1 sequence 35508 dbid 1489133003 branch 820851149
Mon Dec 16 22:27:00 2013
RFS LogMiner: Registered logfile [+ODS_DATA2/archive_ods/uatods_58c25dcb_35507_1_820851149.arc] to LogMiner session id [1]
RFS[11]: Selected log 4 for thread 1 sequence 35509 dbid 1489133003 branch 820851149
Mon Dec 16 22:27:04 2013
RFS LogMiner: Registered logfile [+ODS_DATA2/archive_ods/uatods_58c25dcb_35508_1_820851149.arc] to LogMiner session id [1]
Tue Dec 17 02:00:00 2013
Closing scheduler window
Closing Resource Manager plan via scheduler window
Clearing Resource Manager plan via parameter
Tue Dec 17 02:30:23 2013
Thread 1 advanced to log sequence 1099 (LGWR switch)
Current log# 1 seq# 1099 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.324.832005481
Tue Dec 17 02:30:24 2013
Archived Log entry 1098 added for thread 1 sequence 1098 ID 0x65998d9a dest 1:
Tue Dec 17 03:30:37 2013
RFS[11]: Selected log 5 for thread 1 sequence 35510 dbid 1489133003 branch 820851149
Tue Dec 17 03:30:37 2013
RFS LogMiner: Registered logfile [+ODS_DATA2/archive_ods/uatods_58c25dcb_35509_1_820851149.arc] to LogMiner session id [1]
Tue Dec 17 07:30:37 2013
Thread 1 advanced to log sequence 1100 (LGWR switch)
Current log# 2 seq# 1100 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.325.832005483
Tue Dec 17 07:30:37 2013
Archived Log entry 1099 added for thread 1 sequence 1099 ID 0x65998d9a dest 1:
Tue Dec 17 10:46:08 2013
RFS[11]: Selected log 4 for thread 1 sequence 35511 dbid 1489133003 branch 820851149
Tue Dec 17 10:46:08 2013
RFS LogMiner: Registered logfile [+ODS_DATA2/archive_ods/uatods_58c25dcb_35510_1_820851149.arc] to LogMiner session id [1]
Do I need to check anything else to check whether archive applied and log shipping is happening or not?
Kindly assist me to resolve the problem.
Regards,
Ishika