Oracle 9i 非歸檔模式到歸檔模式設置一例

創建歸檔目錄：-
 

[Oracle@ORA9ISERV arch]$ mkdir -p /u01/app/oracle/oradata/orcl/arch

設置log_archive_dest_1參數：

SQL> alter system set log_archive_dest_1='LOCATION=/u01/app/Oracle/oradata/orcl/arch' scope=both;

System altered.

查看log_archive_dest_1設置：

SQL> show parameter log_archive_dest_1

NAME                                 TYPE                   VALUE

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

log_archive_dest_1                   string                 LOCATION=/u01/app/Oracle/orada

ta/orcl/arch

SQL> show parameter log_archive_dest_state_1

NAME                                 TYPE                   VALUE

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

log_archive_dest_state_1             string                 enable

切換日志:

SQL> alter system switch logfile;

System altered.

SQL> select sequence#,dest_id,archived,applied,deleted, status,first_time from v$archived_log order by sequence#;

no rows selected

觀察并沒有產生歸檔。

查看數據庫歸檔模式：

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Disabled   --不解

Archive destination            /u01/app/Oracle/oradata/orcl/arch

Oldest online log sequence     4

Next log sequence to archive   4

Current log sequence           6

Google：修改pfile參數文件，設置log_archive_start='TRUE'

SQL> create pfile from spfile;

File created.

添加：log_archive_start='TRUE'

*.log_archive_dest_1='LOCATION=/u01/app/Oracle/oradata/orcl/arch'

log_archive_start='TRUE'

SQL> create spfile from pfile;

File created.

重啟數據庫：

SQL> startup

Oracle instance started.

Total System Global Area  738793148 bytes

Fixed Size                   452284 bytes

Variable Size             335544320 bytes

Database Buffers          402653184 bytes

Redo Buffers                 143360 bytes

Database mounted.

Database opened.

查看數據庫歸檔模式：

SQL> archive log list

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            /u01/app/Oracle/oradata/orcl/arch

Oldest online log sequence     4

Next log sequence to archive   6

Current log sequence           6

切換日志：

SQL> alter system switch logfile;

System altered.

SQL> select sequence#,dest_id,archived,applied,deleted, status,first_time from v$archived_log order by sequence#;

 SEQUENCE#    DEST_ID ARCHIV APPLIE DELETE ST FIRST_TIM

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

         4          1 YES    NO     NO     A  19-APR-11

         5          1 YES    NO     NO     A  19-APR-11

         6          1 YES    NO     NO     A  19-APR-11

         7          1 YES    NO     NO     A  19-APR-11

歸檔已經產生。

查看歸檔目錄是否有歸檔文件產生：

[Oracle@ORA9ISERV arch]$ pwd

/u01/app/Oracle/oradata/orcl/arch

[Oracle@ORA9ISERV arch]$ ls -l

total 1124

-rw-r----- 1 Oracle oinstall 278528 Apr 19 13:37 1_4.dbf

-rw-r----- 1 Oracle oinstall  31232 Apr 19 13:37 1_5.dbf

-rw-r----- 1 Oracle oinstall 585728 Apr 19 13:38 1_6.dbf

-rw-r----- 1 Oracle oinstall 225280 Apr 19 13:42 1_7.dbf

一切正常，完畢。

服務器租用/服務器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質保障！--億恩科技[ENKJ.COM]