Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> checkpoint over 15 minutes?

checkpoint over 15 minutes?

From: LS Cheng <exriscer_at_gmail.com>
Date: Tue, 23 May 2006 12:40:27 +0200
Message-ID: <6e9345580605230340x5bee0a8araad86ee46dcc50c4@mail.gmail.com>


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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 23 2006 - 05:40:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US