arc0 oracle,oracle8.1.6.0数据库只是开启了一个归档进程,为什么会有ARC0和ARC1 ?

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

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值