1、log_archive_min_succeed_dest 必须保证成功的归档日志文件组数。
设置归档文件时属性:mandatory。不能比这个小。
查询
SQL> show parameter log_archive_min_succeed_dest;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_min_succeed_dest integer 1
修改:
SQL> alter system set log_archive_min_succeed_dest=2;
System altered
SQL> show parameter log_archive_min_succeed_dest;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_min_succeed_dest integer 2
2、如某一归档日志文件损坏,设置log_archive_dest_state_n不可用
SQL> alter system set log_archive_dest_state_1=defer;
System altered
查看:
show parameter log_archive_dest_1;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
og_archive_dest_state_1 string DEFER
启用:
SQL> alter system set log_archive_dest_state_1=enable;
System altered
设置归档文件时属性:mandatory。不能比这个小。
查询
SQL> show parameter log_archive_min_succeed_dest;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_min_succeed_dest integer 1
修改:
SQL> alter system set log_archive_min_succeed_dest=2;
System altered
SQL> show parameter log_archive_min_succeed_dest;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_min_succeed_dest integer 2
2、如某一归档日志文件损坏,设置log_archive_dest_state_n不可用
SQL> alter system set log_archive_dest_state_1=defer;
System altered
查看:
show parameter log_archive_dest_1;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
og_archive_dest_state_1 string DEFER
启用:
SQL> alter system set log_archive_dest_state_1=enable;
System altered