Home » Server Options » Data Guard » Log apply is taking long time (11g, 11.2.0.3, solaris10)
Log apply is taking long time [message #611702] Mon, 07 April 2014 08:03 Go to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

In my ODS environment, log shipping is taking place but apply is taking log time. This problem started from today.


   	FILE_NAME	SEQUENCE#	TIMESTAMP	APPLIED
1	+ODS_DATA2/archive_ods/uatods_58c25dcb_39729_1_820851149.arc	39729	07/04/2014 17:36:13	NO - Not Applied Logs!
2	+ODS_DATA2/archive_ods/uatods_58c25dcb_39728_1_820851149.arc	39728	07/04/2014 17:25:35	NO - Not Applied Logs!
3	+ODS_DATA2/archive_ods/uatods_58c25dcb_39727_1_820851149.arc	39727	07/04/2014 17:10:45	NO - Not Applied Logs!
4	+ODS_DATA2/archive_ods/uatods_58c25dcb_39726_1_820851149.arc	39726	07/04/2014 16:55:56	NO - Not Applied Logs!
5	+ODS_DATA2/archive_ods/uatods_58c25dcb_39725_1_820851149.arc	39725	07/04/2014 16:41:14	NO - Not Applied Logs!
6	+ODS_DATA2/archive_ods/uatods_58c25dcb_39724_1_820851149.arc	39724	07/04/2014 15:54:20	NO - Not Applied Logs!
7	+ODS_DATA2/archive_ods/uatods_58c25dcb_39723_1_820851149.arc	39723	07/04/2014 15:04:03	NO - Not Applied Logs!
8	+ODS_DATA2/archive_ods/uatods_58c25dcb_39722_1_820851149.arc	39722	07/04/2014 14:13:41	NO - Not Applied Logs!
9	+ODS_DATA2/archive_ods/uatods_58c25dcb_39721_1_820851149.arc	39721	07/04/2014 12:48:43	NO - Not Applied Logs!
10	+ODS_DATA2/archive_ods/uatods_58c25dcb_39720_1_820851149.arc	39720	07/04/2014 12:30:46	NO - Not Applied Logs!
11	+ODS_DATA2/archive_ods/uatods_58c25dcb_39719_1_820851149.arc	39719	07/04/2014 12:16:47	NO - Not Applied Logs!
12	+ODS_DATA2/archive_ods/uatods_58c25dcb_39718_1_820851149.arc	39718	07/04/2014 11:53:38	NO - Not Applied Logs!
13	+ODS_DATA2/archive_ods/uatods_58c25dcb_39717_1_820851149.arc	39717	07/04/2014 11:30:38	NO - Not Applied Logs!
14	+ODS_DATA2/archive_ods/uatods_58c25dcb_39716_1_820851149.arc	39716	07/04/2014 10:19:11	NO - Not Applied Logs!
15	+ODS_DATA2/archive_ods/uatods_58c25dcb_39715_1_820851149.arc	39715	07/04/2014 10:08:35	NO - Not Applied Logs!
16	+ODS_DATA2/archive_ods/uatods_58c25dcb_39714_1_820851149.arc	39714	07/04/2014 09:29:31	NO - Not Applied Logs!
17	+ODS_DATA2/archive_ods/uatods_58c25dcb_39713_1_820851149.arc	39713	07/04/2014 09:29:34	CURRENT
18	+ODS_DATA2/archive_ods/uatods_58c25dcb_39712_1_820851149.arc	39712	07/04/2014 09:29:32	CURRENT
19	+ODS_DATA2/archive_ods/uatods_58c25dcb_39711_1_820851149.arc	39711	07/04/2014 09:29:25	CURRENT
20	+ODS_DATA2/archive_ods/uatods_58c25dcb_39710_1_820851149.arc	39710	07/04/2014 09:29:27	CURRENT
21	+ODS_DATA2/archive_ods/uatods_58c25dcb_39709_1_820851149.arc	39709	07/04/2014 09:29:00	CURRENT
22	+ODS_DATA2/archive_ods/uatods_58c25dcb_39708_1_820851149.arc	39708	07/04/2014 09:29:00	CURRENT
23	+ODS_DATA2/archive_ods/uatods_58c25dcb_39707_1_820851149.arc	39707	07/04/2014 09:28:55	CURRENT
24	+ODS_DATA2/archive_ods/uatods_58c25dcb_39706_1_820851149.arc	39706	07/04/2014 09:28:52	CURRENT
25	+ODS_DATA2/archive_ods/uatods_58c25dcb_39705_1_820851149.arc	39705	07/04/2014 09:28:47	CURRENT
26	+ODS_DATA2/archive_ods/uatods_58c25dcb_39704_1_820851149.arc	39704	07/04/2014 08:40:52	YES - OK
27	+ODS_DATA2/archive_ods/uatods_58c25dcb_39703_1_820851149.arc	39703	07/04/2014 08:38:16	YES - OK
28	+ODS_DATA2/archive_ods/uatods_58c25dcb_39702_1_820851149.arc	39702	07/04/2014 08:29:46	YES - OK
29	+ODS_DATA2/archive_ods/uatods_58c25dcb_39701_1_820851149.arc	39701	07/04/2014 08:02:51	YES - OK
30	+ODS_DATA2/archive_ods/uatods_58c25dcb_39700_1_820851149.arc	39700	07/04/2014 07:56:58	YES - OK
31	+ODS_DATA2/archive_ods/uatods_58c25dcb_39699_1_820851149.arc	39699	07/04/2014 07:45:40	YES - OK
32	+ODS_DATA2/archive_ods/uatods_58c25dcb_39698_1_820851149.arc	39698	07/04/2014 07:40:16	YES - OK
33	+ODS_DATA2/archive_ods/uatods_58c25dcb_39697_1_820851149.arc	39697	07/04/2014 07:08:44	YES - OK
34	+ODS_DATA2/archive_ods/uatods_58c25dcb_39696_1_820851149.arc	39696	07/04/2014 05:54:59	YES - OK
35	+ODS_DATA2/archive_ods/uatods_58c25dcb_39695_1_820851149.arc	39695	07/04/2014 05:54:49	YES - OK




APPLIED_THREAD#	READ_SCN	APPLIED_SCN	TO_CHAR(APPLIED_TIME,'DD/MM/YY	NEWEST_SCN	APPLIED_SEQUENCE#	NEWEST_SEQUENCE#
1	8262455360197	8262455360815	07/04/2014 09:29:19	8262455652419	39714	39730



Below is the part of alert log (in-between to end)

Mon Apr 07 16:30:48 2014
LOGMINER: End   mining logfile for session 1 thread 1 sequence 39712, +ODS_DATA2/archive_ods/uatods_58c25dcb_39712_1_820851149.arc
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 39713, +ODS_DATA2/archive_ods/uatods_58c25dcb_39713_1_820851149.arc
Mon Apr 07 16:36:48 2014
Thread 1 advanced to log sequence 20563 (LGWR switch)
  Current log# 1 seq# 20563 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Mon Apr 07 16:36:49 2014
Archived Log entry 20562 added for thread 1 sequence 20562 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:41:13 2014
RFS[1]: Selected log 5 for thread 1 sequence 39726 dbid 1489133003 branch 820851149
Mon Apr 07 16:41:14 2014
RFS LogMiner: Registered logfile [+ODS_DATA2/archive_ods/uatods_58c25dcb_39725_1_820851149.arc] to LogMiner session id [1]
Mon Apr 07 16:51:32 2014
Thread 1 advanced to log sequence 20564 (LGWR switch)
  Current log# 2 seq# 20564 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Mon Apr 07 16:51:34 2014
Archived Log entry 20563 added for thread 1 sequence 20563 ID 0x65d20fa0 dest 1:
Thread 1 advanced to log sequence 20565 (LGWR switch)
  Current log# 3 seq# 20565 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Mon Apr 07 16:51:37 2014
Archived Log entry 20564 added for thread 1 sequence 20564 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:51:42 2014
Thread 1 cannot allocate new log, sequence 20566
Checkpoint not complete
  Current log# 3 seq# 20565 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Thread 1 advanced to log sequence 20566 (LGWR switch)
  Current log# 1 seq# 20566 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Mon Apr 07 16:51:49 2014
Archived Log entry 20565 added for thread 1 sequence 20565 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:52:18 2014
Thread 1 cannot allocate new log, sequence 20567
Checkpoint not complete
  Current log# 1 seq# 20566 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Thread 1 advanced to log sequence 20567 (LGWR switch)
  Current log# 2 seq# 20567 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Mon Apr 07 16:52:21 2014
Archived Log entry 20566 added for thread 1 sequence 20566 ID 0x65d20fa0 dest 1:
Thread 1 cannot allocate new log, sequence 20568
Checkpoint not complete
  Current log# 2 seq# 20567 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Thread 1 advanced to log sequence 20568 (LGWR switch)
  Current log# 3 seq# 20568 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Mon Apr 07 16:52:27 2014
Archived Log entry 20567 added for thread 1 sequence 20567 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:52:31 2014
Thread 1 cannot allocate new log, sequence 20569
Checkpoint not complete
  Current log# 3 seq# 20568 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Thread 1 advanced to log sequence 20569 (LGWR switch)
  Current log# 1 seq# 20569 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Mon Apr 07 16:52:34 2014
Archived Log entry 20568 added for thread 1 sequence 20568 ID 0x65d20fa0 dest 1:
Thread 1 cannot allocate new log, sequence 20570
Checkpoint not complete
  Current log# 1 seq# 20569 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Thread 1 advanced to log sequence 20570 (LGWR switch)
  Current log# 2 seq# 20570 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Mon Apr 07 16:52:40 2014
Archived Log entry 20569 added for thread 1 sequence 20569 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:52:43 2014
Thread 1 cannot allocate new log, sequence 20571
Checkpoint not complete
  Current log# 2 seq# 20570 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Thread 1 advanced to log sequence 20571 (LGWR switch)
  Current log# 3 seq# 20571 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Mon Apr 07 16:52:46 2014
Archived Log entry 20570 added for thread 1 sequence 20570 ID 0x65d20fa0 dest 1:
Thread 1 cannot allocate new log, sequence 20572
Checkpoint not complete
  Current log# 3 seq# 20571 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Thread 1 advanced to log sequence 20572 (LGWR switch)
  Current log# 1 seq# 20572 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Mon Apr 07 16:52:52 2014
Archived Log entry 20571 added for thread 1 sequence 20571 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:52:55 2014
Thread 1 cannot allocate new log, sequence 20573
Checkpoint not complete
  Current log# 1 seq# 20572 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Thread 1 advanced to log sequence 20573 (LGWR switch)
  Current log# 2 seq# 20573 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Mon Apr 07 16:52:58 2014
Archived Log entry 20572 added for thread 1 sequence 20572 ID 0x65d20fa0 dest 1:
Thread 1 cannot allocate new log, sequence 20574
Checkpoint not complete
  Current log# 2 seq# 20573 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Thread 1 advanced to log sequence 20574 (LGWR switch)
  Current log# 3 seq# 20574 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Mon Apr 07 16:53:04 2014
Archived Log entry 20573 added for thread 1 sequence 20573 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:53:08 2014
Thread 1 cannot allocate new log, sequence 20575
Checkpoint not complete
  Current log# 3 seq# 20574 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Thread 1 advanced to log sequence 20575 (LGWR switch)
  Current log# 1 seq# 20575 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Mon Apr 07 16:53:11 2014
Archived Log entry 20574 added for thread 1 sequence 20574 ID 0x65d20fa0 dest 1:
Thread 1 cannot allocate new log, sequence 20576
Checkpoint not complete
  Current log# 1 seq# 20575 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Thread 1 advanced to log sequence 20576 (LGWR switch)
  Current log# 2 seq# 20576 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Mon Apr 07 16:53:17 2014
Archived Log entry 20575 added for thread 1 sequence 20575 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:53:20 2014
Thread 1 cannot allocate new log, sequence 20577
Checkpoint not complete
  Current log# 2 seq# 20576 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Thread 1 advanced to log sequence 20577 (LGWR switch)
  Current log# 3 seq# 20577 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Mon Apr 07 16:53:23 2014
Archived Log entry 20576 added for thread 1 sequence 20576 ID 0x65d20fa0 dest 1:
Thread 1 cannot allocate new log, sequence 20578
Checkpoint not complete
  Current log# 3 seq# 20577 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Mon Apr 07 16:53:31 2014
Thread 1 advanced to log sequence 20578 (LGWR switch)
  Current log# 1 seq# 20578 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Mon Apr 07 16:53:32 2014
Archived Log entry 20577 added for thread 1 sequence 20577 ID 0x65d20fa0 dest 1:
Thread 1 cannot allocate new log, sequence 20579
Checkpoint not complete
  Current log# 1 seq# 20578 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Thread 1 advanced to log sequence 20579 (LGWR switch)
  Current log# 2 seq# 20579 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Mon Apr 07 16:53:41 2014
Archived Log entry 20578 added for thread 1 sequence 20578 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:53:44 2014
Thread 1 cannot allocate new log, sequence 20580
Checkpoint not complete
  Current log# 2 seq# 20579 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Thread 1 advanced to log sequence 20580 (LGWR switch)
  Current log# 3 seq# 20580 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Mon Apr 07 16:53:47 2014
Archived Log entry 20579 added for thread 1 sequence 20579 ID 0x65d20fa0 dest 1:
Thread 1 cannot allocate new log, sequence 20581
Checkpoint not complete
  Current log# 3 seq# 20580 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Thread 1 advanced to log sequence 20581 (LGWR switch)
  Current log# 1 seq# 20581 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Mon Apr 07 16:53:52 2014
Archived Log entry 20580 added for thread 1 sequence 20580 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:53:56 2014
Thread 1 cannot allocate new log, sequence 20582
Checkpoint not complete
  Current log# 1 seq# 20581 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Thread 1 advanced to log sequence 20582 (LGWR switch)
  Current log# 2 seq# 20582 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Mon Apr 07 16:53:59 2014
Archived Log entry 20581 added for thread 1 sequence 20581 ID 0x65d20fa0 dest 1:
Thread 1 cannot allocate new log, sequence 20583
Checkpoint not complete
  Current log# 2 seq# 20582 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Thread 1 advanced to log sequence 20583 (LGWR switch)
  Current log# 3 seq# 20583 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Mon Apr 07 16:54:05 2014
Archived Log entry 20582 added for thread 1 sequence 20582 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:54:08 2014
Thread 1 cannot allocate new log, sequence 20584
Checkpoint not complete
  Current log# 3 seq# 20583 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Thread 1 advanced to log sequence 20584 (LGWR switch)
  Current log# 1 seq# 20584 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Mon Apr 07 16:54:12 2014
Archived Log entry 20583 added for thread 1 sequence 20583 ID 0x65d20fa0 dest 1:
Thread 1 cannot allocate new log, sequence 20585
Checkpoint not complete
  Current log# 1 seq# 20584 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Thread 1 advanced to log sequence 20585 (LGWR switch)
  Current log# 2 seq# 20585 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Mon Apr 07 16:54:17 2014
Archived Log entry 20584 added for thread 1 sequence 20584 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:54:20 2014
Thread 1 cannot allocate new log, sequence 20586
Checkpoint not complete
  Current log# 2 seq# 20585 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Thread 1 advanced to log sequence 20586 (LGWR switch)
  Current log# 3 seq# 20586 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Mon Apr 07 16:54:24 2014
Archived Log entry 20585 added for thread 1 sequence 20585 ID 0x65d20fa0 dest 1:
Thread 1 cannot allocate new log, sequence 20587
Checkpoint not complete
  Current log# 3 seq# 20586 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Thread 1 advanced to log sequence 20587 (LGWR switch)
  Current log# 1 seq# 20587 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Mon Apr 07 16:54:29 2014
Archived Log entry 20586 added for thread 1 sequence 20586 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:54:35 2014
Thread 1 cannot allocate new log, sequence 20588
Checkpoint not complete
  Current log# 1 seq# 20587 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Thread 1 advanced to log sequence 20588 (LGWR switch)
  Current log# 2 seq# 20588 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Mon Apr 07 16:54:37 2014
Archived Log entry 20587 added for thread 1 sequence 20587 ID 0x65d20fa0 dest 1:
Thread 1 cannot allocate new log, sequence 20589
Checkpoint not complete
  Current log# 2 seq# 20588 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Thread 1 advanced to log sequence 20589 (LGWR switch)
  Current log# 3 seq# 20589 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Mon Apr 07 16:54:44 2014
Archived Log entry 20588 added for thread 1 sequence 20588 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:54:47 2014
Thread 1 cannot allocate new log, sequence 20590
Checkpoint not complete
  Current log# 3 seq# 20589 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Thread 1 advanced to log sequence 20590 (LGWR switch)
  Current log# 1 seq# 20590 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Mon Apr 07 16:54:47 2014
Archived Log entry 20589 added for thread 1 sequence 20589 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:55:00 2014
Thread 1 cannot allocate new log, sequence 20591
Checkpoint not complete
  Current log# 1 seq# 20590 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Thread 1 advanced to log sequence 20591 (LGWR switch)
  Current log# 2 seq# 20591 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Mon Apr 07 16:55:07 2014
Archived Log entry 20590 added for thread 1 sequence 20590 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:55:12 2014
Thread 1 cannot allocate new log, sequence 20592
Checkpoint not complete
  Current log# 2 seq# 20591 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Thread 1 advanced to log sequence 20592 (LGWR switch)
  Current log# 3 seq# 20592 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Mon Apr 07 16:55:16 2014
Archived Log entry 20591 added for thread 1 sequence 20591 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:55:24 2014
Thread 1 cannot allocate new log, sequence 20593
Checkpoint not complete
  Current log# 3 seq# 20592 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Thread 1 advanced to log sequence 20593 (LGWR switch)
  Current log# 1 seq# 20593 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Mon Apr 07 16:55:28 2014
Archived Log entry 20592 added for thread 1 sequence 20592 ID 0x65d20fa0 dest 1:
Mon Apr 07 16:55:54 2014
RFS[1]: Selected log 4 for thread 1 sequence 39727 dbid 1489133003 branch 820851149
Mon Apr 07 16:55:56 2014
RFS LogMiner: Registered logfile [+ODS_DATA2/archive_ods/uatods_58c25dcb_39726_1_820851149.arc] to LogMiner session id [1]
Mon Apr 07 17:10:44 2014
RFS[1]: Selected log 5 for thread 1 sequence 39728 dbid 1489133003 branch 820851149
Mon Apr 07 17:10:45 2014
RFS LogMiner: Registered logfile [+ODS_DATA2/archive_ods/uatods_58c25dcb_39727_1_820851149.arc] to LogMiner session id [1]
Mon Apr 07 17:23:59 2014
Thread 1 advanced to log sequence 20594 (LGWR switch)
  Current log# 2 seq# 20594 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Mon Apr 07 17:24:00 2014
Archived Log entry 20593 added for thread 1 sequence 20593 ID 0x65d20fa0 dest 1:
Mon Apr 07 17:24:29 2014
Thread 1 advanced to log sequence 20595 (LGWR switch)
  Current log# 3 seq# 20595 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Mon Apr 07 17:24:30 2014
Archived Log entry 20594 added for thread 1 sequence 20594 ID 0x65d20fa0 dest 1:
Mon Apr 07 17:25:34 2014
RFS[1]: Selected log 4 for thread 1 sequence 39729 dbid 1489133003 branch 820851149
Mon Apr 07 17:25:35 2014
RFS LogMiner: Registered logfile [+ODS_DATA2/archive_ods/uatods_58c25dcb_39728_1_820851149.arc] to LogMiner session id [1]
Mon Apr 07 17:28:54 2014
Thread 1 cannot allocate new log, sequence 20596
Checkpoint not complete
  Current log# 3 seq# 20595 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Thread 1 advanced to log sequence 20596 (LGWR switch)
  Current log# 1 seq# 20596 mem# 0: +ODS_DATA1/uatods/onlinelog/group_1.334.835718253
Mon Apr 07 17:28:58 2014
Archived Log entry 20595 added for thread 1 sequence 20595 ID 0x65d20fa0 dest 1:
Mon Apr 07 17:36:12 2014
RFS[1]: Selected log 5 for thread 1 sequence 39730 dbid 1489133003 branch 820851149
Mon Apr 07 17:36:13 2014
RFS LogMiner: Registered logfile [+ODS_DATA2/archive_ods/uatods_58c25dcb_39729_1_820851149.arc] to LogMiner session id [1]
Mon Apr 07 17:39:06 2014
Thread 1 advanced to log sequence 20597 (LGWR switch)
  Current log# 2 seq# 20597 mem# 0: +ODS_DATA1/uatods/onlinelog/group_2.333.835718253
Mon Apr 07 17:39:07 2014
Archived Log entry 20596 added for thread 1 sequence 20596 ID 0x65d20fa0 dest 1:
Mon Apr 07 18:00:37 2014
LOGMINER: End   mining logfile for session 1 thread 1 sequence 39713, +ODS_DATA2/archive_ods/uatods_58c25dcb_39713_1_820851149.arc
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 39714, +ODS_DATA2/archive_ods/uatods_58c25dcb_39714_1_820851149.arc
Mon Apr 07 18:13:34 2014
Thread 1 advanced to log sequence 20598 (LGWR switch)
  Current log# 3 seq# 20598 mem# 0: +ODS_DATA1/uatods/onlinelog/group_3.332.835718253
Mon Apr 07 18:13:35 2014
Archived Log entry 20597 added for thread 1 sequence 20597 ID 0x65d20fa0 dest 1:
Mon Apr 07 18:19:29 2014
RFS[1]: Selected log 4 for thread 1 sequence 39731 dbid 1489133003 branch 820851149
Mon Apr 07 18:19:30 2014
RFS LogMiner: Registered logfile [+ODS_DATA2/archive_ods/uatods_58c25dcb_39730_1_820851149.arc] to LogMiner session id [1]


Please help me out to understand the issue related to delay in log apply.

Waiting for your kind response on the same..

Regards,
Ashish
Re: Log apply is taking long time [message #611703 is a reply to message #611702] Mon, 07 April 2014 08:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Can you post the query that gave you this output.

Re: Log apply is taking long time [message #611721 is a reply to message #611703] Mon, 07 April 2014 23:16 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear Michel,

Below are the queries are -


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;


select file_name, sequence#, timestamp,
decode(applied,'NO',applied||' - Not Applied Logs!','YES',applied||' - OK',applied) applied
from dba_logstdby_log
order by sequence# desc;



Re: Log apply is taking long time [message #612340 is a reply to message #611721] Wed, 16 April 2014 04:36 Go to previous messageGo to next message
ashishkumarmahanta80
Messages: 231
Registered: October 2006
Location: kolkatta
Senior Member
Dear All,

In Alert log, found that, RFS keep trying to register log files and apply is not possible. Since,, there were huge archive apply gap. So, lastly, we decided to re-configure it again. Now, shipping and apply is upto to date.

Regards,
Ashish kumar Mahanta
Re: Log apply is taking long time [message #613641 is a reply to message #612340] Thu, 08 May 2014 14:09 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Sorry multiple questions.

How big your redo size ?
How big your archive log size ?
How long takes to apply ?
And Is there any interesting message in DR alert log ?

Also are you using compress feature in production ?
In DR Site how was the server load ?

- babu
Re: Log apply is taking long time [message #613656 is a reply to message #613641] Fri, 09 May 2014 00:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What is the purpose of posting these questions when the origin of the problem and solution are found and the problem is over?

Re: Log apply is taking long time [message #613709 is a reply to message #613656] Fri, 09 May 2014 07:17 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Ok. The original problem solved but did not tell more details about slowness instead I see only for delay apply because of gap.

And, I happy to close this thread if no more discussion needed.

thanks, babu
Previous Topic: DataGuard missing archivelogs issue
Next Topic: Oracle Physical Standby Replicate between Different OS
Goto Forum:
  


Current Time: Thu Mar 28 10:01:21 CDT 2024