Oracle8.1.6.0数据库只是开启了一个归档进程,为什么会有ARC0和ARC1 ?
歸檔相關參數:
SQL*Plus: Release 8.1.6.0.0 - Production on Mon Nov 7 10:14:36 2005
(c) Copyright 1999 Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production
SQL> show parameter arch
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
log_archive_dest string
log_archive_dest_1 string location=/data/multidb/arch
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_state_1 string enable
log_archive_dest_state_2 string enable
log_archive_dest_state_3 string enable
log_archive_dest_state_4 string enable
log_archive_dest_state_5 string enable
NAME TYPE VALUE
------------------------------------ ------- ------------------------------
log_archive_duplex_dest string
log_archive_format string %t_%s.arc
log_archive_max_processes integer 1
log_archive_min_succeed_dest integer 1
log_archive_start boolean TRUE
log_archive_trace integer 0
standby_archive_dest string ?/dbs/arch
SQL>
在Alert log 文件中的信息:
Mon Nov 7 08:49:37 2005
Thread 1 advanced to log sequence 48952
Mon Nov 7 08:49:37 2005
ARC0: Beginning to archive log# 5 seq# 48951
Mon Nov 7 08:49:37 2005
Current log# 6 seq# 48952 mem# 0: /u01/product/oradata/multidb/redo06a.log
Current log# 6 seq# 48952 mem# 1: /data/multidb/redo06b.log
Mon Nov 7 08:49:39 2005
ARC0: Completed archiving log# 5 seq# 48951
Mon Nov 7 09:30:47 2005
Thread 1 advanced to log sequence 48953
Current log# 1 seq# 48953 mem# 0: /u01/product/oradata/multidb/redo01a.log
Current log# 1 seq# 48953 mem# 1: /data/multidb/redo01b.log
Mon Nov 7 09:30:47 2005
ARC0: Beginning to archive log# 6 seq# 48952
ARC0: Completed archiving log# 6 seq# 48952
Mon Nov 7 10:06:25 2005
alter tablespace sn_idx
add datafile '/data/multidb/sn_idx07.dbf' size
2048064k
Mon Nov 7 10:07:28 2005
Completed: alter tablespace sn_idx
add datafile '/data/multid
Mon Nov 7 10:08:26 2005
Thread 1 advanced to log sequence 48954
Current log# 2 seq# 48954 mem# 0: /u01/product/oradata/multidb/redo02a.log
Current log# 2 seq# 48954 mem# 1: /data/multidb/redo02b.log
Mon Nov 7 10:08:26 2005
ARC0: Beginning to archive log# 1 seq# 48953
Mon Nov 7 10:08:27 2005
Thread 1 advanced to log sequence 48955
Current log# 3 seq# 48955 mem# 0: /u01/product/oradata/multidb/redo03a.log
Current log# 3 seq# 48955 mem# 1: /data/multidb/redo03b.log
Mon Nov 7 10:08:27 2005
ARC1: Beginning to archive log# 1 seq# 48953
ARC1: Failed to archive log# 1 seq# 48953
ARC1: Beginning to archive log# 2 seq# 48954
ARC1: Completed archiving log# 2 seq# 48954
ARC1: Beginning to archive log# 1 seq# 48953
ARC1: Failed to archive log# 1 seq# 48953
Mon Nov 7 10:08:28 2005
Thread 1 advanced to log sequence 48956
Current log# 4 seq# 48956 mem# 0: /u01/product/oradata/multidb/redo04a.log
Current log# 4 seq# 48956 mem# 1: /data/multidb/redo04b.log
Mon Nov 7 10:08:28 2005
ARC1: Beginning to archive log# 1 seq# 48953
ARC1: Failed to archive log# 1 seq# 48953
ARC1: Beginning to archive log# 3 seq# 48955
ARC1: Completed archiving log# 3 seq# 48955
ARC1: Beginning to archive log# 1 seq# 48953
ARC1: Failed to archive log# 1 seq# 48953
Mon Nov 7 10:08:29 2005
ARC0: Completed archiving log# 1 seq# 48953
Mon Nov 7 10:08:29 2005
Thread 1 advanced to log sequence 48957
Current log# 5 seq# 48957 mem# 0: /u01/product/oradata/multidb/redo05a.log
Current log# 5 seq# 48957 mem# 1: /data/multidb/redo05b.log
Mon Nov 7 10:08:29 2005
ARC1: Beginning to archive log# 4 seq# 48956
ARC1: Completed archiving log# 4 seq# 48956