11g归档模式记录

1.开启归档模式：

SQL> archive log list
Database log mode           No Archive Mode
Automatic archival           Disabled
Archive destination           USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     75
Current log sequence           77

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.
Total System Global Area 2.5053E+10 bytes
Fixed Size            2239976 bytes
Variable Size         2885681688 bytes
Database Buffers     2.2146E+10 bytes
Redo Buffers           19619840 bytes
Database mounted.

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     80
Next log sequence to archive   82
Current log sequence           82

2：修改归档目录

SQL> alter system set log_archive_dest_5='location=/oracle_archive_log' ;立即生效
System altered.

SQL> archive log list;
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           /oracle_archive_log
Oldest online log sequence     82
Next log sequence to archive   84
Current log sequence           84

3: 归档目录还原为默认

SQL> alter system set DB_RECOVERY_FILE_DEST='/u01/app/oracle/fast_recovery_area';
System altered.

SQL> alter system set log_archive_dest_10='location=USE_DB_RECOVERY_FILE_DEST' scope=spfile;  //下次启动生效
System altered.

SQL> alter system set log_archive_dest_state_7= defer;; //暂时不用自定义的目录作为归档目录

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.
Total System Global Area 2.5053E+10 bytes
Fixed Size            2239976 bytes
Variable Size         2885681688 bytes
Database Buffers     2.2146E+10 bytes
Redo Buffers           19619840 bytes
Database mounted.
Database opened.

SQL> archive log list;
Database log mode           Archive Mode
Automatic archival           Enabled
Archive destination           USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     84
Next log sequence to archive   86
Current log sequence           86

4：修改闪回恢复区大小

SQL> alter system set db_recovery_file_dest_size=1g; //这个参数只是控制闪回恢复区大小，如果换了目录这个参数就意义不大了。
System altered.

5：关闭日志归档模式

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount;
ORACLE instance started.
Total System Global Area 2.5053E+10 bytes
Fixed Size            2239976 bytes
Variable Size         2885681688 bytes
Database Buffers     2.2146E+10 bytes
Redo Buffers           19619840 bytes
Database mounted.

SQL> alter database noarchivelog;
Database altered.

SQL> alter database open ;
Database altered.

SQL> archive log list;
Database log mode           No Archive Mode
Automatic archival           Disabled
Archive destination           USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     89
Current log sequence           91