配置归档日志双路径

最新推荐文章于 2023-10-30 16:20:23 发布

原创最新推荐文章于 2023-10-30 16:20:23 发布 · 652 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#ORA-02097 #ORA-16019

oracle故障处理专栏收录该内容

29 篇文章

订阅专栏

今天想改一下归档路径,配置成双路径备份归档日志,但是配置的时候,除了一点小问题

SQL> alter system set log_archive_dest_1='LOCATION=/oracle10/product/10.2/dbs/arch/';
alter system set log_archive_dest_1='LOCATION=/oracle10/product/10.2/dbs/arch/'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or
LOG_ARCHIVE_DUPLEX_DEST
SQL>

在选择第二个归档路径log_archive_dest_1时报错,查看归档参数：
SQL> show parameter arch_
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target                   integer     0
log_archive_config                   string
log_archive_dest                     string      /dsg/oracle10/cxf/DBF
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

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_8                   string
log_archive_dest_9                   string
log_archive_dest_state_1             string      enable
log_archive_dest_state_10            string      enable
log_archive_dest_state_2             string      enable
log_archive_dest_state_3             string      enable
log_archive_dest_state_4             string      enable
log_archive_dest_state_5             string      enable
log_archive_dest_state_6             string      enable
log_archive_dest_state_7             string      enable
log_archive_dest_state_8             string      enable

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_9             string      enable
log_archive_duplex_dest              string
log_archive_format                   string      %t_%s_%r.dbf
log_archive_local_first              boolean     TRUE
log_archive_max_processes            integer     2
log_archive_min_succeed_dest         integer     1
log_archive_start                    boolean     FALSE
log_archive_trace                    integer     0
remote_archive_enable                string      true
standby_archive_dest                 string      /dsg/oracle10/cxf/DBF
SQL>

把默认归档log_archive_dest删掉：
SQL> alter system set log_archive_dest=" ";
System altered.
SQL>
SQL> show parameter arch_

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target                   integer     0
log_archive_config                   string
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

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_7                   string
log_archive_dest_8                   string
log_archive_dest_9                   string
log_archive_dest_state_1             string      enable
log_archive_dest_state_10            string      enable
log_archive_dest_state_2             string      enable
log_archive_dest_state_3             string      enable
log_archive_dest_state_4             string      enable
log_archive_dest_state_5             string      enable
log_archive_dest_state_6             string      enable
log_archive_dest_state_7             string      enable

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_state_8             string      enable
log_archive_dest_state_9             string      enable
log_archive_duplex_dest              string
log_archive_format                   string      %t_%s_%r.dbf
log_archive_local_first              boolean     TRUE
log_archive_max_processes            integer     2
log_archive_min_succeed_dest         integer     1
log_archive_start                    boolean     FALSE
log_archive_trace                    integer     0
remote_archive_enable                string      true
standby_archive_dest                 string      /dsg/oracle10/cxf/DBF
SQL>
SQL> alter system set log_archive_dest_1='LOCATION=/oracle10/product/10.2/dbs/arch';
System altered.
SQL> alter system set log_archive_dest_2='LOCATION=/dsg/oracle10/cxf/DBF';
System altered.
SQL>

SQL> show parameter arch_
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target                   integer     0
log_archive_config                   string
log_archive_dest                     string
log_archive_dest_1                   string      LOCATION=/oracle10/product/10.2/dbs/arch
log_archive_dest_10                  string
log_archive_dest_2                   string      LOCATION=/dsg/oracle10/cxf/DBF
log_archive_dest_3                   string
log_archive_dest_4                   string
log_archive_dest_5                   string
log_archive_dest_6                   string