Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Archive error

User470870-OCAug 29 2012 — edited Sep 4 2012

Hi

Database verasion : 11.1.0.7
Applications R12 : 12.1.3

Enabled archive log mode recently with default log_Archive_max_processes=4 and 3 redolog files with size 50mb each,
Db_writer_processses=4 cpu_count=16.
Below message in the alrt log file.

LGWR: STARTING ARCH PROCESSES
Tue Aug 28 00:07:02 2012
ARC0 started with pid=20, OS id=27290
Tue Aug 28 00:07:02 2012
ARC1 started with pid=21, OS id=27292
Tue Aug 28 00:07:02 2012
ARC2 started with pid=22, OS id=27294
ARC0: Archival started
ARC1: Archival started
Tue Aug 28 00:07:03 2012
ARC3 started with pid=23, OS id=27296
ARC2: Archival started
ARC3: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 opened at log sequence 331
Current log# 3 seq# 331 mem# 0: /u02/OBAPROD/db/apps_st/data/log03a.dbf
Current log# 3 seq# 331 mem# 1: /u02/OBAPROD/db/apps_st/data/log03b.dbf
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
SMON: enabling cache recovery
Successfully onlined Undo Tablespace 368.

and also
Thread 1 cannot allocate new log, sequence 340
Private strand flush not complete
Current log# 3 seq# 339 mem# 0: /u02/OBAPROD/db/apps_st/data/log03a.dbf
Current log# 3 seq# 339 mem# 1: /u02/OBAPROD/db/apps_st/data/log03b.dbf
Tue Aug 28 17:00:14 2012
Beginning log switch checkpoint up to RBA [0x154.2.10], SCN: 5965237781623
Thread 1 advanced to log sequence 340 (LGWR switch)
Current log# 4 seq# 340 mem# 0: /u02/OBAPROD/db/apps_st/data/log04a.dbf
Current log# 4 seq# 340 mem# 1: /u02/OBAPROD/db/apps_st/data/log04b.dbf
Tue Aug 28 17:05:47 2012
Completed checkpoint up to RBA [0x154.2.10], SCN: 5965237781623
Tue Aug 28 17:07:43 2012
Thread 1 cannot allocate new log, sequence 341
Private strand flush not complete
Current log# 4 seq# 340 mem# 0: /u02/OBAPROD/db/apps_st/data/log04a.dbf
Current log# 4 seq# 340 mem# 1: /u02/OBAPROD/db/apps_st/data/log04b.dbf
Tue Aug 28 17:08:55 2012
Beginning log switch checkpoint up to RBA [0x155.2.10], SCN: 5965237828905
Thread 1 advanced to log sequence 341 (LGWR switch)
Current log# 2 seq# 341 mem# 0: /u02/OBAPROD/db/apps_st/data/log02a.dbf
Current log# 2 seq# 341 mem# 1: /u02/OBAPROD/db/apps_st/data/log02b.dbf
Tue Aug 28 17:10:14 2012
Completed checkpoint up to RBA [0x155.2.10], SCN: 5965237828905
Tue Aug 28 17:17:54 2012
Thread 1 cannot allocate new log, sequence 342
Private strand flush not complete
Current log# 2 seq# 341 mem# 0: /u02/OBAPROD/db/apps_st/data/log02a.dbf
Current log# 2 seq# 341 mem# 1: /u02/OBAPROD/db/apps_st/data/log02b.dbf
Tue Aug 28 17:18:30 2012
Beginning log switch checkpoint up to RBA [0x156.2.10], SCN: 5965237844727
Thread 1 advanced to log sequence 342 (LGWR switch)
Current log# 1 seq# 342 mem# 0: /u02/OBAPROD/db/apps_st/data/log01a.dbf
Current log# 1 seq# 342 mem# 1: /u02/OBAPROD/db/apps_st/data/log01b.dbf
Tue Aug 28 17:18:42 2012
Incremental checkpoint up to RBA [0x155.50653.0], current log tail at RBA [0x156.28a3.0]
Tue Aug 28 17:24:41 2012
Completed checkpoint up to RBA [0x156.2.10], SCN: 5965237844727
Tue Aug 28 17:35:40 2012

Thanks in advance..
Arudhi

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 2 2012

Added on Aug 29 2012

#performance-availability, #recovery-manager-rman

16 comments

316 views