Oracle归档模式的运行模式

以下的文章主要讲述的是正确的`启动或是关闭Oracle归档模式的实际操作步骤,我们大家都知道Oracle数据库运行于2种模式,主要实施Oracle归档模式(archivelog)与非归档模式(noarchivelog)。

Oracle归档模式的运行模式

Oracle归档模式可以提高Oracle数据库的可恢复性,生产数据库都应该运行在此模式下,归档模式应该和相应的备份策略相结合,只有归档模式没有相应的备份策略只会带来麻烦。

  down normal或shutdown immediate关闭数据库

le@jumper oracle]$ sqlplus "/ as sysdba"

*Plus: Release - Production on Sat Oct 15 15:48:36 2005

right (c) 1982, 2002, Oracle Corporation. All rights reserved.

ected to:

le9i Enterprise Edition Release - Production

the Partitioning option

ver Release - Production

> shutdown immediate;

base closed.

base dismounted.

LE instance shut down.

  2.启动数据库到mount状态

> startup mount;

LE instance started.

l System Global Area 101782828 bytes

d Size 451884 bytes

able Size 37748736 bytes

base Buffers 62914560 bytes

Buffers 667648 bytes

base mounted.

  3.启用或停止归档模式

如果要启用Oracle归档模式,此处使用

r database archivelog 命令

> alter database archivelog;

base altered.

> alter database open;

base altered.

> archive log list;

base log mode Archive Mode

matic archival Enabled

ive destination /opt/oracle/oradata/conner/archive

st online log sequence 148

log sequence to archive 151

ent log sequence 151