配置ARCHIVELOG 模式

1、    確定資料庫當前以哪種歸檔模式執行。

以sys使用者登入資料庫，透過archive log list命令來確認當前資料庫是否採用歸檔模式。

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Mar 24 14:41:21 2013

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> archive log list

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     14

Current log sequence           16

2、    關閉資料庫

只有在mount狀態，才可以更改ARCHIVELOG 模式，因此先關閉資料庫。

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

3、    裝載資料庫

SQL> startup mount

ORACLE instance started.

Total System Global Area  707244032 bytes

Fixed Size                  1338868 bytes

Variable Size             511705612 bytes

Database Buffers          188743680 bytes

Redo Buffers                5455872 bytes

Database mounted.

4、    將資料庫更改為使用ARCHIVELOG 模式。

SQL> alter database archivelog;

Database altered.

5、    開啟資料庫

SQL> alter database open;

Database altered.

6、    驗證資料庫歸檔模式修改結果（兩種方式均可）

SQL>  select name,log_mode from v$database;

NAME      LOG_MODE

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

ORCL      ARCHIVELOG

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     15

Next log sequence to archive   17

Current log sequence           17