Hello All,
I'm bit confuse with the logs I see in alert log file. My export job is scheduled to execute every morning 4:00AM, but couple of days back I saw unusual entries in log file as below. This scenario also hamper our database operation for long time. Kindly suggest for solution.
------------------------------
Oracle 11.2.0.1.0 Enterprise Edition
Red Hat Linux 6.5
------------------------------
Sat Feb 27 02:00:00 2016
Clearing Resource Manager plan via parameter
Sat Feb 27 04:00:04 2016
DM00 started with pid=34, OS id=10776, job SYSTEM.SYS_EXPORT_SCHEMA_35
Sat Feb 27 04:00:06 2016
DW00 started with pid=35, OS id=10778, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_35
Sat Feb 27 04:00:40 2016
Thread 1 advanced to log sequence 212 (LGWR switch)
Current log# 7 seq# 212 mem# 0: /oradata/redo/redolog7a.log
Current log# 7 seq# 212 mem# 1: /oradata/redo/redolog7b.log
Sat Feb 27 04:00:42 2016
Archived Log entry 28678 added for thread 1 sequence 211 ID 0xc96dd59e dest 1:
Sat Feb 27 04:01:01 2016
DM03 started with pid=38, OS id=10827, job SYSTEM.SYS_EXPORT_SCHEMA_37
Sat Feb 27 04:01:02 2016
DW01 started with pid=39, OS id=10829, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_37
Sat Feb 27 04:02:01 2016
DM06 started with pid=41, OS id=10854, job SYSTEM.SYS_EXPORT_SCHEMA_38
Sat Feb 27 04:02:03 2016
DW02 started with pid=42, OS id=10856, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_38
Sat Feb 27 04:03:01 2016
DM09 started with pid=45, OS id=10881, job SYSTEM.SYS_EXPORT_SCHEMA_39
Sat Feb 27 04:03:03 2016
DW03 started with pid=46, OS id=10883, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_39
Sat Feb 27 04:03:09 2016
Thread 1 cannot allocate new log, sequence 213
Private strand flush not complete
Current log# 7 seq# 212 mem# 0: /oradata/redo/redolog7a.log
Current log# 7 seq# 212 mem# 1: /oradata/redo/redolog7b.log
Thread 1 advanced to log sequence 213 (LGWR switch)
Current log# 4 seq# 213 mem# 0: /oradata/redo/redolog4a.log
Current log# 4 seq# 213 mem# 1: /oradata/redo/redolog4b.log
Sat Feb 27 04:03:26 2016
Archived Log entry 28679 added for thread 1 sequence 212 ID 0xc96dd59e dest 1:
Sat Feb 27 04:04:05 2016
DM0C started with pid=48, OS id=10906, job SYSTEM.SYS_EXPORT_SCHEMA_40
Sat Feb 27 04:04:07 2016
DW04 started with pid=49, OS id=10909, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_40
Sat Feb 27 04:05:05 2016
DM0F started with pid=51, OS id=10933, job SYSTEM.SYS_EXPORT_SCHEMA_41
Sat Feb 27 04:05:10 2016
DW05 started with pid=52, OS id=10937, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_41
Sat Feb 27 04:05:27 2016
Thread 1 cannot allocate new log, sequence 214
Private strand flush not complete
Current log# 4 seq# 213 mem# 0: /oradata/redo/redolog4a.log
Current log# 4 seq# 213 mem# 1: /oradata/redo/redolog4b.log
Sat Feb 27 04:05:40 2016
Thread 1 advanced to log sequence 214 (LGWR switch)
Current log# 1 seq# 214 mem# 0: /oradata/redo/redolog11a.log
Current log# 1 seq# 214 mem# 1: /oradata/redo/redolog11b.log
Sat Feb 27 04:06:05 2016
DM0I started with pid=54, OS id=10957, job SYSTEM.SYS_EXPORT_SCHEMA_42
Sat Feb 27 04:06:08 2016
DW06 started with pid=55, OS id=10960, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_42
Sat Feb 27 04:06:10 2016
Archived Log entry 28680 added for thread 1 sequence 213 ID 0xc96dd59e dest 1:
Sat Feb 27 04:07:06 2016
DM0L started with pid=57, OS id=10982, job SYSTEM.SYS_EXPORT_SCHEMA_43
Sat Feb 27 04:07:09 2016
DW07 started with pid=58, OS id=10985, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_43
Sat Feb 27 04:08:02 2016
DM00 started with pid=32, OS id=11013, job SYSTEM.SYS_EXPORT_SCHEMA_44
Sat Feb 27 04:08:03 2016
DW06 started with pid=34, OS id=11017, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_44
Sat Feb 27 04:09:01 2016
DM00 started with pid=32, OS id=11047, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:10:01 2016
DM01 started with pid=35, OS id=11075, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:11:01 2016
DM00 started with pid=32, OS id=11101, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:12:02 2016
DM01 started with pid=35, OS id=11126, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:13:02 2016
DM00 started with pid=32, OS id=11151, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:14:01 2016
DM01 started with pid=35, OS id=11177, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:15:02 2016
DM00 started with pid=32, OS id=11204, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:16:01 2016
DM01 started with pid=35, OS id=11228, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:17:02 2016
DM00 started with pid=32, OS id=11255, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:18:02 2016
DM01 started with pid=35, OS id=11280, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:19:01 2016
DM00 started with pid=32, OS id=11306, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:19:04 2016
Thread 1 cannot allocate new log, sequence 215
Private strand flush not complete
Current log# 1 seq# 214 mem# 0: /oradata/redo/redolog11a.log
Current log# 1 seq# 214 mem# 1: /oradata/redo/redolog11b.log
Thread 1 advanced to log sequence 215 (LGWR switch)
Current log# 2 seq# 215 mem# 0: /oradata/redo/redolog2a.log
Current log# 2 seq# 215 mem# 1: /oradata/redo/redolog2b.log
Sat Feb 27 04:19:15 2016
Archived Log entry 28681 added for thread 1 sequence 214 ID 0xc96dd59e dest 1:
Sat Feb 27 04:20:02 2016
DM01 started with pid=35, OS id=11337, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:21:02 2016
DM00 started with pid=32, OS id=11361, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:22:02 2016
DM01 started with pid=35, OS id=11386, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:23:01 2016
DM00 started with pid=32, OS id=11411, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:24:01 2016
DM01 started with pid=35, OS id=11437, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:25:02 2016
DM00 started with pid=32, OS id=11464, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:26:01 2016
DM01 started with pid=35, OS id=11488, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:27:01 2016
DM00 started with pid=32, OS id=11513, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:28:02 2016
DM01 started with pid=35, OS id=11538, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:29:02 2016
DM00 started with pid=32, OS id=11564, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:30:01 2016
DM01 started with pid=35, OS id=11594, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:31:01 2016
DM00 started with pid=32, OS id=11622, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:32:01 2016
DM01 started with pid=35, OS id=11649, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:33:02 2016
DM00 started with pid=32, OS id=11674, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:34:02 2016
DM01 started with pid=35, OS id=11700, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:35:02 2016
DM00 started with pid=32, OS id=11727, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:36:02 2016
DM01 started with pid=35, OS id=11751, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:37:01 2016
DM00 started with pid=32, OS id=11776, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:38:01 2016
DM01 started with pid=35, OS id=11800, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:39:09 2016
DM00 started with pid=29, OS id=11834, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:40:01 2016
DM01 started with pid=35, OS id=11857, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:41:01 2016
DM00 started with pid=36, OS id=11881, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:42:02 2016
DM01 started with pid=35, OS id=11906, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:43:02 2016
DM00 started with pid=36, OS id=11932, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:44:01 2016
DM01 started with pid=35, OS id=11957, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:45:02 2016
DM00 started with pid=39, OS id=11985, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:46:01 2016
DM01 started with pid=34, OS id=12008, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:47:01 2016
DM00 started with pid=36, OS id=12035, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:48:02 2016
DM01 started with pid=34, OS id=12062, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:49:02 2016
DM00 started with pid=36, OS id=12088, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:50:02 2016
DM01 started with pid=34, OS id=12118, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:51:02 2016
DM00 started with pid=36, OS id=12142, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:52:02 2016
DM01 started with pid=34, OS id=12167, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:53:01 2016
DM00 started with pid=36, OS id=12192, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:54:02 2016
DM01 started with pid=34, OS id=12222, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:55:02 2016
DM00 started with pid=36, OS id=12249, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:56:01 2016
DM01 started with pid=34, OS id=12273, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:57:02 2016
DM00 started with pid=36, OS id=12298, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 04:58:02 2016
DM01 started with pid=34, OS id=12323, job SYSTEM.SYS_EXPORT_SCHEMA_46
Sat Feb 27 04:59:01 2016
DM00 started with pid=36, OS id=12349, job SYSTEM.SYS_EXPORT_SCHEMA_45
Sat Feb 27 06:00:00 2016
Starting background process VKRM
Sat Feb 27 06:00:00 2016
VKRM started with pid=29, OS id=13175
Sat Feb 27 06:00:01 2016
Begin automatic SQL Tuning Advisor run for special tuning task "SYS_AUTO_SQL_TUNING_TASK"
Sat Feb 27 06:00:42 2016
Thread 1 advanced to log sequence 216 (LGWR switch)
Current log# 6 seq# 216 mem# 0: /oradata/redo/redolog6a.log
Current log# 6 seq# 216 mem# 1: /oradata/redo/redolog6b.log
Sat Feb 27 06:00:44 2016
Archived Log entry 28682 added for thread 1 sequence 215 ID 0xc96dd59e dest 1:
Sat Feb 27 06:01:00 2016
Thread 1 advanced to log sequence 217 (LGWR switch)
Current log# 5 seq# 217 mem# 0: /oradata/redo/redolog5a.log
Current log# 5 seq# 217 mem# 1: /oradata/redo/redolog5b.log
Sat Feb 27 06:01:03 2016
Archived Log entry 28683 added for thread 1 sequence 216 ID 0xc96dd59e dest 1:
Sat Feb 27 06:01:21 2016
Thread 1 advanced to log sequence 218 (LGWR switch)
Current log# 3 seq# 218 mem# 0: /oradata/redo/redolog3a.log
Current log# 3 seq# 218 mem# 1: /oradata/redo/redolog3b.log
Sat Feb 27 06:01:24 2016
Archived Log entry 28684 added for thread 1 sequence 217 ID 0xc96dd59e dest 1:
Sat Feb 27 06:01:37 2016
Thread 1 advanced to log sequence 219 (LGWR switch)
Current log# 7 seq# 219 mem# 0: /oradata/redo/redolog7a.log
Current log# 7 seq# 219 mem# 1: /oradata/redo/redolog7b.log
Sat Feb 27 06:01:40 2016
Archived Log entry 28685 added for thread 1 sequence 218 ID 0xc96dd59e dest 1:
Sat Feb 27 06:01:55 2016
Thread 1 advanced to log sequence 220 (LGWR switch)
Current log# 4 seq# 220 mem# 0: /oradata/redo/redolog4a.log
Current log# 4 seq# 220 mem# 1: /oradata/redo/redolog4b.log
Sat Feb 27 06:01:57 2016
Archived Log entry 28686 added for thread 1 sequence 219 ID 0xc96dd59e dest 1:
Sat Feb 27 06:02:13 2016
Thread 1 advanced to log sequence 221 (LGWR switch)
Current log# 1 seq# 221 mem# 0: /oradata/redo/redolog11a.log
Current log# 1 seq# 221 mem# 1: /oradata/redo/redolog11b.log
Sat Feb 27 06:02:16 2016
Archived Log entry 28687 added for thread 1 sequence 220 ID 0xc96dd59e dest 1:
Thread 1 cannot allocate new log, sequence 222
Checkpoint not complete
Current log# 1 seq# 221 mem# 0: /oradata/redo/redolog11a.log
Current log# 1 seq# 221 mem# 1: /oradata/redo/redolog11b.log
Sat Feb 27 06:08:44 2016
Thread 1 advanced to log sequence 222 (LGWR switch)
Current log# 2 seq# 222 mem# 0: /oradata/redo/redolog2a.log
Current log# 2 seq# 222 mem# 1: /oradata/redo/redolog2b.log
Sat Feb 27 06:08:51 2016
Archived Log entry 28688 added for thread 1 sequence 221 ID 0xc96dd59e dest 1:
Sat Feb 27 06:08:57 2016
Thread 1 cannot allocate new log, sequence 223
Checkpoint not complete
Current log# 2 seq# 222 mem# 0: /oradata/redo/redolog2a.log
Current log# 2 seq# 222 mem# 1: /oradata/redo/redolog2b.log
Sat Feb 27 06:10:35 2016
Thread 1 advanced to log sequence 223 (LGWR switch)
Current log# 6 seq# 223 mem# 0: /oradata/redo/redolog6a.log
Current log# 6 seq# 223 mem# 1: /oradata/redo/redolog6b.log
Sat Feb 27 06:10:39 2016
Archived Log entry 28689 added for thread 1 sequence 222 ID 0xc96dd59e dest 1:
Thread 1 cannot allocate new log, sequence 224
Checkpoint not complete
Current log# 6 seq# 223 mem# 0: /oradata/redo/redolog6a.log
Current log# 6 seq# 223 mem# 1: /oradata/redo/redolog6b.log
Sat Feb 27 06:11:58 2016
Thread 1 advanced to log sequence 224 (LGWR switch)
Current log# 5 seq# 224 mem# 0: /oradata/redo/redolog5a.log
Current log# 5 seq# 224 mem# 1: /oradata/redo/redolog5b.log
Sat Feb 27 06:12:01 2016
Archived Log entry 28690 added for thread 1 sequence 223 ID 0xc96dd59e dest 1:
Sat Feb 27 06:12:19 2016
Thread 1 cannot allocate new log, sequence 225
Checkpoint not complete
Current log# 5 seq# 224 mem# 0: /oradata/redo/redolog5a.log
Current log# 5 seq# 224 mem# 1: /oradata/redo/redolog5b.log
Sat Feb 27 06:13:02 2016
Thread 1 advanced to log sequence 225 (LGWR switch)
Current log# 3 seq# 225 mem# 0: /oradata/redo/redolog3a.log
Current log# 3 seq# 225 mem# 1: /oradata/redo/redolog3b.log
Sat Feb 27 06:13:09 2016
Archived Log entry 28691 added for thread 1 sequence 224 ID 0xc96dd59e dest 1:
Sat Feb 27 06:13:19 2016
Thread 1 advanced to log sequence 226 (LGWR switch)
Current log# 7 seq# 226 mem# 0: /oradata/redo/redolog7a.log
Current log# 7 seq# 226 mem# 1: /oradata/redo/redolog7b.log
Sat Feb 27 06:13:22 2016
Archived Log entry 28692 added for thread 1 sequence 225 ID 0xc96dd59e dest 1:
Sat Feb 27 06:13:35 2016
Thread 1 advanced to log sequence 227 (LGWR switch)
Current log# 4 seq# 227 mem# 0: /oradata/redo/redolog4a.log
Current log# 4 seq# 227 mem# 1: /oradata/redo/redolog4b.log
Sat Feb 27 06:13:41 2016
Archived Log entry 28693 added for thread 1 sequence 226 ID 0xc96dd59e dest 1:
Sat Feb 27 06:13:46 2016
Thread 1 cannot allocate new log, sequence 228
Checkpoint not complete
Current log# 4 seq# 227 mem# 0: /oradata/redo/redolog4a.log
Current log# 4 seq# 227 mem# 1: /oradata/redo/redolog4b.log
Sat Feb 27 06:14:11 2016
Thread 1 advanced to log sequence 228 (LGWR switch)
Current log# 1 seq# 228 mem# 0: /oradata/redo/redolog11a.log
Current log# 1 seq# 228 mem# 1: /oradata/redo/redolog11b.log
Sat Feb 27 06:14:14 2016
Archived Log entry 28694 added for thread 1 sequence 227 ID 0xc96dd59e dest 1:
Thread 1 cannot allocate new log, sequence 229
Checkpoint not complete
Current log# 1 seq# 228 mem# 0: /oradata/redo/redolog11a.log
Current log# 1 seq# 228 mem# 1: /oradata/redo/redolog11b.log
Sat Feb 27 06:14:51 2016
Thread 1 advanced to log sequence 229 (LGWR switch)
Current log# 2 seq# 229 mem# 0: /oradata/redo/redolog2a.log
Current log# 2 seq# 229 mem# 1: /oradata/redo/redolog2b.log
Sat Feb 27 06:14:54 2016
Archived Log entry 28695 added for thread 1 sequence 228 ID 0xc96dd59e dest 1:
Thread 1 cannot allocate new log, sequence 230
Checkpoint not complete
Current log# 2 seq# 229 mem# 0: /oradata/redo/redolog2a.log
Current log# 2 seq# 229 mem# 1: /oradata/redo/redolog2b.log
Sat Feb 27 06:15:26 2016
Thread 1 advanced to log sequence 230 (LGWR switch)
Current log# 6 seq# 230 mem# 0: /oradata/redo/redolog6a.log
Current log# 6 seq# 230 mem# 1: /oradata/redo/redolog6b.log
Sat Feb 27 06:15:28 2016
Archived Log entry 28696 added for thread 1 sequence 229 ID 0xc96dd59e dest 1:
Thread 1 cannot allocate new log, sequence 231
Checkpoint not complete
Current log# 6 seq# 230 mem# 0: /oradata/redo/redolog6a.log
Current log# 6 seq# 230 mem# 1: /oradata/redo/redolog6b.log
Sat Feb 27 06:15:50 2016
Thread 1 advanced to log sequence 231 (LGWR switch)
Current log# 5 seq# 231 mem# 0: /oradata/redo/redolog5a.log
Current log# 5 seq# 231 mem# 1: /oradata/redo/redolog5b.log
Sat Feb 27 06:15:55 2016
Archived Log entry 28697 added for thread 1 sequence 230 ID 0xc96dd59e dest 1:
Thread 1 cannot allocate new log, sequence 232
Checkpoint not complete
Current log# 5 seq# 231 mem# 0: /oradata/redo/redolog5a.log
Current log# 5 seq# 231 mem# 1: /oradata/redo/redolog5b.log
Sat Feb 27 06:16:14 2016
Thread 1 advanced to log sequence 232 (LGWR switch)
Current log# 3 seq# 232 mem# 0: /oradata/redo/redolog3a.log
Current log# 3 seq# 232 mem# 1: /oradata/redo/redolog3b.log
Sat Feb 27 06:16:17 2016
Archived Log entry 28698 added for thread 1 sequence 231 ID 0xc96dd59e dest 1:
Thread 1 cannot allocate new log, sequence 233
Checkpoint not complete
Current log# 3 seq# 232 mem# 0: /oradata/redo/redolog3a.log
Current log# 3 seq# 232 mem# 1: /oradata/redo/redolog3b.log
Sat Feb 27 06:16:37 2016
Thread 1 advanced to log sequence 233 (LGWR switch)
Current log# 7 seq# 233 mem# 0: /oradata/redo/redolog7a.log
Current log# 7 seq# 233 mem# 1: /oradata/redo/redolog7b.log
Sat Feb 27 06:16:40 2016
Archived Log entry 28699 added for thread 1 sequence 232 ID 0xc96dd59e dest 1:
Sat Feb 27 06:16:48 2016
Thread 1 cannot allocate new log, sequence 234
Checkpoint not complete
Current log# 7 seq# 233 mem# 0: /oradata/redo/redolog7a.log
Current log# 7 seq# 233 mem# 1: /oradata/redo/redolog7b.log
Sat Feb 27 06:17:14 2016
Thread 1 advanced to log sequence 234 (LGWR switch)
Current log# 4 seq# 234 mem# 0: /oradata/redo/redolog4a.log
Current log# 4 seq# 234 mem# 1: /oradata/redo/redolog4b.log
Sat Feb 27 06:17:17 2016
Archived Log entry 28700 added for thread 1 sequence 233 ID 0xc96dd59e dest 1:
Sat Feb 27 06:17:25 2016
Thread 1 cannot allocate new log, sequence 235
Checkpoint not complete
Current log# 4 seq# 234 mem# 0: /oradata/redo/redolog4a.log
Current log# 4 seq# 234 mem# 1: /oradata/redo/redolog4b.log
Sat Feb 27 06:17:54 2016
Thread 1 advanced to log sequence 235 (LGWR switch)
Current log# 1 seq# 235 mem# 0: /oradata/redo/redolog11a.log
Current log# 1 seq# 235 mem# 1: /oradata/redo/redolog11b.log
Sat Feb 27 06:17:57 2016
Archived Log entry 28701 added for thread 1 sequence 234 ID 0xc96dd59e dest 1:
Sat Feb 27 06:18:11 2016
Thread 1 cannot allocate new log, sequence 236
Checkpoint not complete
Current log# 1 seq# 235 mem# 0: /oradata/redo/redolog11a.log
Current log# 1 seq# 235 mem# 1: /oradata/redo/redolog11b.log
Sat Feb 27 06:18:29 2016
Thread 1 advanced to log sequence 236 (LGWR switch)
Current log# 2 seq# 236 mem# 0: /oradata/redo/redolog2a.log
Current log# 2 seq# 236 mem# 1: /oradata/redo/redolog2b.log
Sat Feb 27 06:18:32 2016
Archived Log entry 28702 added for thread 1 sequence 235 ID 0xc96dd59e dest 1:
Thread 1 cannot allocate new log, sequence 237
Checkpoint not complete
Current log# 2 seq# 236 mem# 0: /oradata/redo/redolog2a.log
Current log# 2 seq# 236 mem# 1: /oradata/redo/redolog2b.log
Sat Feb 27 06:19:01 2016
Thread 1 advanced to log sequence 237 (LGWR switch)
Current log# 6 seq# 237 mem# 0: /oradata/redo/redolog6a.log
Current log# 6 seq# 237 mem# 1: /oradata/redo/redolog6b.log
......
Best Regards,
Kapil Relan.