-- 啟用歸檔(Windows,Linux)

-- 查看歸檔信息
SYS@HUIYI>select name,log_mode from v$database;

NAME                           LOG_MODE
------------------------------ ------------
HUIYI                          NOARCHIVELOG

SYS@HUIYI>select name,value from v$parameter 
where name in('log_archive_dest','log_archive_format','log_archive_start');

NAME                           VALUE
------------------------------ --------------------------------------------------
log_archive_start              FALSE
log_archive_dest
log_archive_format             ARC%S.%T

log_arhive_start:    歸檔是否啟動
log_archive_dest:    歸檔的目的地(可以設置多個目的地)
log_archive_format: 歸檔文件名格式

-- 設置數据庫歸檔
SYS@HUIYI>alter system set log_archive_dest='D:backuparchive';

System altered.

SYS@HUIYI>alter system set log_archive_start=true scope=spfile;

System altered.

SYS@HUIYI>alter system set log_archive_format='%s.trc';
alter system set log_archive_format='%s.trc'
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified


SYS@HUIYI>alter system set log_archive_format='%s.trc' scope=spfile;

System altered.

SYS@HUIYI>shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@HUIYI>startup mount
ORACLE instance started.

Total System Global Area  147921840 bytes
Fixed Size                   453552 bytes
Variable Size             109051904 bytes
Database Buffers           37748736 bytes
Redo Buffers                 667648 bytes
Database mounted.
SYS@HUIYI>alter database archivelog;

Database altered.

SYS@HUIYI>alter database open;

Database altered.

SYS@HUIYI>select name,log_mode from v$database;

NAME                           LOG_MODE
------------------------------ ------------
HUIYI                          ARCHIVELOG

SYS@HUIYI>select name,value from v$parameter 
where name in('log_archive_dest','log_archive_format','log_archive_start');

NAME                           VALUE
------------------------------ --------------------------------------------------
log_archive_start              TRUE
log_archive_dest               D:backuparchive
log_archive_format             %s.trc

-- 查看歸檔路徑
SYS@HUIYI>select dest_id,dest_name,status,destination from v$archive_dest;

   DEST_ID DEST_NAME                                STATUS    DESTINATION
---------- ---------------------------------------- --------- ------------------------------
         1 LOG_ARCHIVE_DEST_1                       VALID     D:backuparchive
         2 LOG_ARCHIVE_DEST_2                       INACTIVE
         3 LOG_ARCHIVE_DEST_3                       INACTIVE
         4 LOG_ARCHIVE_DEST_4                       INACTIVE
         5 LOG_ARCHIVE_DEST_5                       INACTIVE
         6 LOG_ARCHIVE_DEST_6                       INACTIVE
         7 LOG_ARCHIVE_DEST_7                       INACTIVE
         8 LOG_ARCHIVE_DEST_8                       INACTIVE
         9 LOG_ARCHIVE_DEST_9                       INACTIVE
        10 LOG_ARCHIVE_DEST_10                      INACTIVE

10 rows selected.

-- 查看歸檔信息
SYS@HUIYI>archive log list
Database log mode              Archive Mode(處於歸檔模式)
Automatic archival             Enabled(啟動自動歸檔)
Archive destination            D:backuparchive(歸檔路徑)
Oldest online log sequence     85(當前第一個在線日誌)
Next log sequence to archive   86(下一個將歸檔的序列號)
Current log sequence           86（當前的在線重做日誌文件序列號）

-- Linux
[huiyi.local@huiyi ~]$ ps -ef|grep ora_
oracle   12227     1  0 17:03 ?        00:00:01 ora_pmon_huiyi
oracle   12229     1  0 17:03 ?        00:00:00 ora_dbw0_huiyi
oracle   12231     1  0 17:03 ?        00:00:01 ora_lgwr_huiyi
oracle   12233     1  0 17:03 ?        00:00:00 ora_ckpt_huiyi
oracle   12235     1  0 17:03 ?        00:00:01 ora_smon_huiyi
oracle   12237     1  0 17:03 ?        00:00:00 ora_reco_huiyi
oracle   12239     1  0 17:03 ?        00:00:01 ora_cjq0_huiyi
oracle   12243     1  0 17:03 ?        00:00:00 ora_s000_huiyi
oracle   12245     1  0 17:03 ?        00:00:00 ora_d000_huiyi
oracle   12247     1  0 17:03 ?        00:00:00 ora_arc0_huiyi
oracle   12249     1  0 17:03 ?        00:00:00 ora_arc1_huiyi
oracle   12271     1  2 17:04 ?        00:00:04 ora_qmn0_huiyi
507      12372 10589  0 17:07 pts/0    00:00:00 grep ora_