checkpoint over 15 minutes?
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 23 May 2006 12:40:27 +0200
Hi
I have a piece of alert.log, as follows:
Tue May 23 12:10:20 2006
ARC1: Completed archiving log 1 thread 1 sequence 1268
ARC1: Evaluating archive log 2 thread 1 sequence 1269
ARC1: Unable to archive log 2 thread 1 sequence 1269
Log actively being archived by another process
Tue May 23 12:10:48 2006
Beginning log switch checkpoint up to RBA [0x4f7.2.10], SCN: 0x0336.77684e1c
Thread 1 advanced to log sequence 1271
Current log# 4 seq# 1271 mem# 0: /e920psft/log/log42e920psft.dbf
Current log# 4 seq# 1271 mem# 1: /e920psft/log1/log41e920psft.dbf
Tue May 23 12:10:48 2006
ARC1: Evaluating archive log 2 thread 1 sequence 1269
ARC1: Unable to archive log 2 thread 1 sequence 1269
Log actively being archived by another process
ARC1: Evaluating archive log 3 thread 1 sequence 1270
ARC1: Beginning to archive log 3 thread 1 sequence 1270
Creating archive destination LOG_ARCHIVE_DEST_1:
'/arce920psft/dbs/e920psft_1270.arc'
Tue May 23 12:11:09 2006
ARC0: Completed archiving log 2 thread 1 sequence 1269
ARC0: Evaluating archive log 3 thread 1 sequence 1270
ARC0: Unable to archive log 3 thread 1 sequence 1270
Log actively being archived by another process
ARC0: Evaluating archive log 3 thread 1 sequence 1270
ARC0: Unable to archive log 3 thread 1 sequence 1270
Log actively being archived by another process
Tue May 23 12:11:54 2006
ARC1: Completed archiving log 3 thread 1 sequence 1270
Tue May 23 12:22:31 2006
Completed checkpoint up to RBA [0x4f5.2.10], SCN: 0x0336.7767c828
Tue May 23 12:24:45 2006
Completed checkpoint up to RBA [0x4f6.2.10], SCN: 0x0336.77680ebf
Tue May 23 12:26:10 2006
Completed checkpoint up to RBA [0x4f7.2.10], SCN: 0x0336.77684e1c
If I understand well the checkpoint SCN: 0x0336.77684e1c took 16 minutes???
Cheers
LSC
Other related posts:
