1. 查看默认归档目录
SYS@orcl>show parameter db_recovery

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/flash_recovery
_area
db_recovery_file_dest_size big integer 3882M

2. 查看归档进程数
SYS@orcl>show parameter log_archive_max_processes

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_max_processes integer 4

3. 修改归档进程数
SYS@orcl>alter system set log_archive_max_processes=6;
System altered.

SYS@orcl>show parameter log_archive_max_processes;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_max_processes integer 6

4. 设置归档目录参数设置：mandatory：强制在该目录下归档写成功
SYS@orcl>alter system set log_archive_dest_1='location=/u01/arch/1/mandatory'; optional：及时归档没有写成功，对应的日志文件依然可以重新使用
System altered. ：没有任何参数的话，默认是optional

SYS@orcl>alter system set log_archive_dest_2='location=/u01/arch/2/optional';
System altered.

SYS@orcl>alter system set log_archive_dest_3='location=/u01/arch/3/';
System altered.

5. 验证归档木了设置
SYS@orcl>show parameter log_archive_dest

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string location=/u01/arch/1/mandatory
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string
log_archive_dest_15 string
log_archive_dest_16 string
log_archive_dest_17 string
log_archive_dest_18 string
log_archive_dest_19 string
log_archive_dest_2 string location=/u01/arch/2/optional
log_archive_dest_20 string
log_archive_dest_21 string
log_archive_dest_22 string
log_archive_dest_23 string
log_archive_dest_24 string
log_archive_dest_25 string
log_archive_dest_26 string
log_archive_dest_27 string
log_archive_dest_28 string
log_archive_dest_29 string
log_archive_dest_3 string location=/u01/arch/3/

6. 验证归档终点设置
SYS@orcl>select BINDING,DESTINATION,TARGET,STATUS from v$archive_dest where DESTINATION is not null;

BINDING DESTINATION TARGET STATUS
--------- ------------------------------ ------- ---------
OPTIONAL /u01/arch/1/mandatory PRIMARY VALID
OPTIONAL /u01/arch/2/optional PRIMARY VALID
OPTIONAL /u01/arch/3/ PRIMARY VALID

7. SYS@orcl>show parameter log_archive_min_succeed_dest;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_min_succeed_dest integer 1

这是个动态参数，该值意思为至少有几个归档成功

SYS@orcl>alter system set log_archive_min_succeed_dest=2; 修改一下
System altered.

SYS@orcl>show parameter log_archive_min_succeed_dest;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_min_succeed_dest integer 2

ITPub博客

归档管理

最新文章