数据库开启关闭均无问题,为什么alter文件里有"ARC0: media recovery disabled"呀?这是正常现象吗?有人遇到过这种问题吗?下面是alter文件(问题的地方我在后面用?????标出了):
------------------------------------------------------------------
Tue Apr 11 16:52:33 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 300
shared_pool_size = 60M
large_pool_size = 32M
java_pool_size = 32M
control_files = /opt/oracle/oradata/mis0_db/controla.ctl
db_block_buffers = 15360
db_block_size = 8192
compatible = 8.1.0
log_archive_start = TRUE
log_archive_dest = /opt/oracle/arch/mis0_db
log_archive_format = LOG%S_%T.ARC
log_buffer = 163840
log_checkpoint_interval = 10000
db_files = 50
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
db_domain = chnsys.com.cn
global_names = TRUE
distributed_transactions = 10
instance_name = mis0_db
sort_area_size = 163840
sort_area_retained_size = 65536
db_name = mis0_db
open_cursors = 300
job_queue_processes = 2
job_queue_interval = 60
parallel_max_servers = 10
background_dump_dest = /opt/oracle/admin/mis0_db/bdump
user_dump_dest = /opt/oracle/admin/mis0_db/udump
max_dump_file_size = 10000
core_dump_dest = /opt/oracle/admin/mis0_db/cdump
PMON started with pid=2
Load Indicator not supported by OS !
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
Tue Apr 11 16:52:33 2006
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=10
Tue Apr 11 16:52:33 2006
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue Apr 11 16:52:33 2006
ARC0: Archival started
Tue Apr 11 16:52:33 2006
create database mis0_db
logfile
group 1 '/opt/oracle/oradata/mis0_db/redo01a.log' size 20M,
group 2 '/opt/oracle/oradata/mis0_db/redo02a.log' size 20M,
group 3 '/opt/oracle/oradata/mis0_db/redo03a.log' size 20M
datafile
'/opt/oracle/oradata/mis0_db/system01.dbf' size 200M
autoextend on next 50M maxsize unlimited
maxdatafiles 50
maxinstances 4
maxlogfiles 16
character set ZHS16GBK
national character set ZHS16GBK
Tue Apr 11 16:52:33 2006
Database mounted in Exclusive Mode.
Tue Apr 11 16:52:35 2006
Successful mount of redo thread 1, with mount id 927379537.
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /opt/oracle/oradata/mis0_db/redo01a.log
Successful open of redo thread 1.
Tue Apr 11 16:52:35 2006
ARC0: media recovery disabled
Tue Apr 11 16:52:35 2006
SMON: enabling cache recovery
Tue Apr 11 16:52:35 2006
create tablespace SYSTEM datafile
'/opt/oracle/oradata/mis0_db/system01.dbf' size 200M
autoextend on next 50M maxsize unlimited
default storage (initial 10K next 10K) online
Tue Apr 11 16:52:43 2006
Completed: create tablespace SYSTEM datafile
'/opt/oracl
Tue Apr 11 16:52:43 2006
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
Tue Apr 11 16:52:53 2006
SMON: enabling tx recovery
Tue Apr 11 16:52:53 2006
Completed: create database mis0_db
logfile
group 1 '/op
Tue Apr 11 16:52:53 2006
create rollback segment r00 tablespace system
storage (initial 32k next 32k minextents 2 maxextents 100)
Completed: create rollback segment r00 tablespace system
st
Tue Apr 11 16:52:53 2006
alter rollback segment r00 online
Completed: alter rollback segment r00 online
Tue Apr 11 16:52:53 2006
create tablespace rbs
datafile
'/opt/oracle/oradata/mis0_db/rbs01.dbf' size 50M,
'/opt/oracle/oradata/mis0_db/rbs02.dbf' size 50M,
'/opt/oracle/oradata/mis0_db/rbs03.dbf' size 50M
Completed: create tablespace rbs
datafile
'/opt/oracle/
Tue Apr 11 16:52:59 2006
create rollback segment r01 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r01 tablespace rbs
stora
Tue Apr 11 16:52:59 2006
create rollback segment r02 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r02 tablespace rbs
stora
Tue Apr 11 16:52:59 2006
create rollback segment r03 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r03 tablespace rbs
stora
Tue Apr 11 16:52:59 2006
create rollback segment r04 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r04 tablespace rbs
stora
Tue Apr 11 16:52:59 2006
create rollback segment r05 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r05 tablespace rbs
stora
Tue Apr 11 16:52:59 2006
create rollback segment r06 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r06 tablespace rbs
stora
Tue Apr 11 16:52:59 2006
create rollback segment r07 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r07 tablespace rbs
stora
Tue Apr 11 16:53:00 2006
create rollback segment r08 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r08 tablespace rbs
stora
Tue Apr 11 16:53:00 2006
create rollback segment r09 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r09 tablespace rbs
stora
Tue Apr 11 16:53:00 2006
create rollback segment r10 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r10 tablespace rbs
stora
Tue Apr 11 16:53:00 2006
create rollback segment r11 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r11 tablespace rbs
stora
------------------------------------------------------------------
Tue Apr 11 16:52:33 2006
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.1.7.0.0.
System parameters with non-default values:
processes = 300
shared_pool_size = 60M
large_pool_size = 32M
java_pool_size = 32M
control_files = /opt/oracle/oradata/mis0_db/controla.ctl
db_block_buffers = 15360
db_block_size = 8192
compatible = 8.1.0
log_archive_start = TRUE
log_archive_dest = /opt/oracle/arch/mis0_db
log_archive_format = LOG%S_%T.ARC
log_buffer = 163840
log_checkpoint_interval = 10000
db_files = 50
max_enabled_roles = 30
remote_login_passwordfile= EXCLUSIVE
db_domain = chnsys.com.cn
global_names = TRUE
distributed_transactions = 10
instance_name = mis0_db
sort_area_size = 163840
sort_area_retained_size = 65536
db_name = mis0_db
open_cursors = 300
job_queue_processes = 2
job_queue_interval = 60
parallel_max_servers = 10
background_dump_dest = /opt/oracle/admin/mis0_db/bdump
user_dump_dest = /opt/oracle/admin/mis0_db/udump
max_dump_file_size = 10000
core_dump_dest = /opt/oracle/admin/mis0_db/cdump
PMON started with pid=2
Load Indicator not supported by OS !
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
SNP0 started with pid=8
SNP1 started with pid=9
Tue Apr 11 16:52:33 2006
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=10
Tue Apr 11 16:52:33 2006
ARCH: STARTING ARCH PROCESSES COMPLETE
Tue Apr 11 16:52:33 2006
ARC0: Archival started
Tue Apr 11 16:52:33 2006
create database mis0_db
logfile
group 1 '/opt/oracle/oradata/mis0_db/redo01a.log' size 20M,
group 2 '/opt/oracle/oradata/mis0_db/redo02a.log' size 20M,
group 3 '/opt/oracle/oradata/mis0_db/redo03a.log' size 20M
datafile
'/opt/oracle/oradata/mis0_db/system01.dbf' size 200M
autoextend on next 50M maxsize unlimited
maxdatafiles 50
maxinstances 4
maxlogfiles 16
character set ZHS16GBK
national character set ZHS16GBK
Tue Apr 11 16:52:33 2006
Database mounted in Exclusive Mode.
Tue Apr 11 16:52:35 2006
Successful mount of redo thread 1, with mount id 927379537.
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: /opt/oracle/oradata/mis0_db/redo01a.log
Successful open of redo thread 1.
Tue Apr 11 16:52:35 2006
ARC0: media recovery disabled
Tue Apr 11 16:52:35 2006
SMON: enabling cache recovery
Tue Apr 11 16:52:35 2006
create tablespace SYSTEM datafile
'/opt/oracle/oradata/mis0_db/system01.dbf' size 200M
autoextend on next 50M maxsize unlimited
default storage (initial 10K next 10K) online
Tue Apr 11 16:52:43 2006
Completed: create tablespace SYSTEM datafile
'/opt/oracl
Tue Apr 11 16:52:43 2006
create rollback segment SYSTEM tablespace SYSTEM
storage (initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace SYSTEM
Tue Apr 11 16:52:53 2006
SMON: enabling tx recovery
Tue Apr 11 16:52:53 2006
Completed: create database mis0_db
logfile
group 1 '/op
Tue Apr 11 16:52:53 2006
create rollback segment r00 tablespace system
storage (initial 32k next 32k minextents 2 maxextents 100)
Completed: create rollback segment r00 tablespace system
st
Tue Apr 11 16:52:53 2006
alter rollback segment r00 online
Completed: alter rollback segment r00 online
Tue Apr 11 16:52:53 2006
create tablespace rbs
datafile
'/opt/oracle/oradata/mis0_db/rbs01.dbf' size 50M,
'/opt/oracle/oradata/mis0_db/rbs02.dbf' size 50M,
'/opt/oracle/oradata/mis0_db/rbs03.dbf' size 50M
Completed: create tablespace rbs
datafile
'/opt/oracle/
Tue Apr 11 16:52:59 2006
create rollback segment r01 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r01 tablespace rbs
stora
Tue Apr 11 16:52:59 2006
create rollback segment r02 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r02 tablespace rbs
stora
Tue Apr 11 16:52:59 2006
create rollback segment r03 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r03 tablespace rbs
stora
Tue Apr 11 16:52:59 2006
create rollback segment r04 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r04 tablespace rbs
stora
Tue Apr 11 16:52:59 2006
create rollback segment r05 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r05 tablespace rbs
stora
Tue Apr 11 16:52:59 2006
create rollback segment r06 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r06 tablespace rbs
stora
Tue Apr 11 16:52:59 2006
create rollback segment r07 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r07 tablespace rbs
stora
Tue Apr 11 16:53:00 2006
create rollback segment r08 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r08 tablespace rbs
stora
Tue Apr 11 16:53:00 2006
create rollback segment r09 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r09 tablespace rbs
stora
Tue Apr 11 16:53:00 2006
create rollback segment r10 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r10 tablespace rbs
stora
Tue Apr 11 16:53:00 2006
create rollback segment r11 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r11 tablespace rbs
stora
create rollback segment r12 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r12 tablespace rbs
stora
Tue Apr 11 16:53:00 2006
create rollback segment r13 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r13 tablespace rbs
stora
Tue Apr 11 16:53:00 2006
create rollback segment r14 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r14 tablespace rbs
stora
Tue Apr 11 16:53:00 2006
create rollback segment r15 tablespace rbs
storage (initial 128k next 128k minextents 10)
Completed: create rollback segment r15 tablespace rbs
stora
Tue Apr 11 16:53:00 2006
alter rollback segment r01 online
Completed: alter rollback segment r01 online
Tue Apr 11 16:53:00 2006
alter rollback segment r02 online
Completed: alter rollback segment r02 online
Tue Apr 11 16:53:00 2006
alter rollback segment r03 online
Completed: alter rollback segment r03 online
Tue Apr 11 16:53:00 2006
alter rollback segment r04 online
Completed: alter rollback segment r04 online
Tue Apr 11 16:53:00 2006
alter rollback segment r05 online
Completed: alter rollback segment r05 online
Tue Apr 11 16:53:00 2006
alter rollback segment r06 online
Completed: alter rollback segment r06 online
Tue Apr 11 16:53:00 2006
alter rollback segment r07 online
Completed: alter rollback segment r07 online
Tue Apr 11 16:53:00 2006
alter rollback segment r08 online
Completed: alter rollback segment r08 online
Tue Apr 11 16:53:00 2006
alter rollback segment r09 online
Completed: alter rollback segment r09 online
Tue Apr 11 16:53:00 2006
alter rollback segment r10 online
Completed: alter rollback segment r10 online
Tue Apr 11 16:53:00 2006
alter rollback segment r11 online
Completed: alter rollback segment r11 online
Tue Apr 11 16:53:00 2006
alter rollback segment r12 online
Completed: alter rollback segment r12 online
Tue Apr 11 16:53:00 2006
alter rollback segment r13 online
Completed: alter rollback segment r13 online
Tue Apr 11 16:53:00 2006
alter rollback segment r14 online
Completed: alter rollback segment r14 online
Tue Apr 11 16:53:00 2006
alter rollback segment r15 online
Completed: alter rollback segment r15 online
Tue Apr 11 16:53:00 2006
create tablespace users
datafile
'/opt/oracle/oradata/mis0_db/users01.dbf' size 100M
default storage (
initial 1M
next 512K
pctincrease 0
minextents 5
maxextents unlimited )
Completed: create tablespace users
datafile
'/opt/oracl
Tue Apr 11 16:53:04 2006
create temporary tablespace temp
tempfile '/opt/oracle/oradata/mis0_db/temp01.dbf' size 100M
autoextend on next 50M maxsize unlimited
extent management local uniform size 1M
Completed: create temporary tablespace temp
tempfile '/opt/
Tue Apr 11 16:53:04 2006
create tablespace indx
datafile
'/opt/oracle/oradata/mis0_db/indx01.dbf' size 100M
default storage (
initial 1M
next 512K
pctincrease 0
minextents 5
maxextents unlimited )
Completed: create tablespace indx
datafile
'/opt/oracle
Tue Apr 11 16:53:26 2006
ARC0: media recovery disabled ???????????????????????????????
Tue Apr 11 16:53:26 2006
Thread 1 advanced to log sequence 2
Current log# 2 seq# 2 mem# 0: /opt/oracle/oradata/mis0_db/redo02a.log
Tue Apr 11 16:54:12 2006
Thread 1 advanced to log sequence 3
Tue Apr 11 16:54:12 2006
Current log# 3 seq# 3 mem# 0: /opt/oracle/oradata/mis0_db/redo03a.log
Tue Apr 11 16:54:12 2006
ARC0: media recovery disabled ??????????????????????????????
Tue Apr 11 16:54:38 2006
Thread 1 advanced to log sequence 4
Current log# 1 seq# 4 mem# 0: /opt/oracle/oradata/mis0_db/redo01a.log
Tue Apr 11 16:54:38 2006
ARC0: media recovery disabled ?????????????????????????????
Tue Apr 11 16:54:56 2006
Thread 1 advanced to log sequence 5
Current log# 2 seq# 5 mem# 0: /opt/oracle/oradata/mis0_db/redo02a.log
Tue Apr 11 16:54:56 2006
ARC0: media recovery disabled ?????????????????????????????
Tue Apr 11 16:55:18 2006
ARC0: media recovery disabled ?????????????????????????????
Tue Apr 11 16:55:18 2006
Thread 1 advanced to log sequence 6
Current log# 3 seq# 6 mem# 0: /opt/oracle/oradata/mis0_db/redo03a.log
Tue Apr 11 16:55:36 2006
Thread 1 advanced to log sequence 7
Current log# 1 seq# 7 mem# 0: /opt/oracle/oradata/mis0_db/redo01a.log
Tue Apr 11 16:55:36 2006
ARC0: media recovery disabled ?????????????????????????????
Tue Apr 11 16:56:07 2006
Thread 1 advanced to log sequence 8
Current log# 2 seq# 8 mem# 0: /opt/oracle/oradata/mis0_db/redo02a.log
Tue Apr 11 16:56:07 2006
ARC0: media recovery disabled ??????????????????????????????
Tue Apr 11 16:56:26 2006
Thread 1 advanced to log sequence 9
Current log# 3 seq# 9 mem# 0: /opt/oracle/oradata/mis0_db/redo03a.log
Tue Apr 11 16:56:26 2006
ARC0: media recovery disabled ?????????????????????????????
Tue Apr 11 16:56:47 2006
Thread 1 advanced to log sequence 10
Current log# 1 seq# 10 mem# 0: /opt/oracle/oradata/mis0_db/redo01a.log
Tue Apr 11 16:56:47 2006
ARC0: media recovery disabled ????????????????????????????
Tue Apr 11 16:57:08 2006
Thread 1 advanced to log sequence 11
Current log# 2 seq# 11 mem# 0: /opt/oracle/oradata/mis0_db/redo02a.log
Tue Apr 11 16:57:08 2006
ARC0: media recovery disabled