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  |
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 #611721 is a reply to message #611703] |
Mon, 07 April 2014 23:16  |
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 |
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
|
|
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Sun Feb 02 14:40:55 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
