Oracle歸檔模式、引數意義、設定

1、檢視是否歸檔模式

SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/archive
Oldest online log sequence 41
Next log sequence to archive 43
Current log sequence 43
SQL>

2、修改歸檔模式、非歸檔模式（mont模式下修改）

SQL> startup mount;
ORACLE instance started.

Total System Global Area 167772160 bytes
Fixed Size 1218316 bytes
Variable Size 75499764 bytes
Database Buffers 88080384 bytes
Redo Buffers 2973696 bytes
Database mounted.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /u01/archive
Oldest online log sequence 41
Next log sequence to archive 43
Current log sequence 43
SQL>
SQL> alter database noarchivelog;

Database altered.

SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination /u01/archive
Oldest online log sequence 41
Current log sequence 43
SQL>

3、歸檔目錄。

如果不設定歸檔目錄預設的放在引數

db_recovery_file_dest下面，目錄預設大小2G

SQL> show parameter db_recover

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/flash_recovery
_area
db_recovery_file_dest_size big integer 2G
SQL>
SQL>

如果要指定歸檔目錄需要修改如下引數：

log_archive_dest_1 string

SQL> show parameter log_archive_dest

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_2 string
log_archive_dest_3 string
log_archive_dest_4 string
log_archive_dest_5 string
log_archive_dest_6 string
log_archive_dest_7 string
log_archive_dest_8 string
log_archive_dest_9 string

[@more@]