oracle改成归档模式_修改oracle的归档模式

1.查看当前数据库的运行模式

方法一：需使用DBA用户

[oracle@oracle ~]$ sqlplus sys/oracle as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Sep 26 08:37:45 2011

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, OLAP and Data Mining options

SQL>

SQL> archive log list;

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     5

Current log sequence           7

方法二：

SQL> select name,log_mode from v$database;

NAME      LOG_MODE

--------- ------------

FANTLAM   NOARCHIVELOG

2. 修改数据库为归档模式

2.1 正常关闭数据库

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

2.2 启动数据库到mount模式

SQL> startup mount;

ORACLE instance started.

Total System Global Area  104857600 bytes

Fixed Size                  1217980 bytes

Variable Size              75500100 bytes

Database Buffers           20971520 bytes

Redo Buffers                7168000 bytes

Database mounted.

2.3  修改为归档模式

SQL> alter database archivelog;

Database altered.

3. 打开数据库，查询更改后状态

SQL> alter database archivelog; Database altered.                           SQL> alter database open; Database altered. SQL> archive log list; Database log mode              Archive Mode Automatic archival             Enabled Archive destination            USE_DB_RECOVERY_FILE_DEST Oldest online log sequence     5 Next log sequence to archive   7 Current log sequence           7 SQL>