归档管理

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