多路径重用归档日志

SQL> show parameter log_archive_dest;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
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
log_archive_dest_7                   string
log_archive_dest_8                   string
log_archive_dest_9                   string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
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
log_archive_dest_state_9             string      enable
SQL> alter  system set log_archive_dest='D:\oracle\product\10.2.0\arch' scope=sp
file;

系统已更改。

SQL> startup force;
ORACLE 例程已经启动。

Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             255855492 bytes
Database Buffers          348127232 bytes
Redo Buffers                7135232 bytes
数据库装载完毕。
数据库已经打开。
SQL> show parameter log_archive_dest;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest                     string      D:\oracle\product\10.2.0\arch
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
log_archive_dest_8                   string
log_archive_dest_9                   string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
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
log_archive_dest_state_9             string      enable
SQL> alter  system set log_archive_dest_1='D:\oracle\product\10.2.0\arch' scope=
spfile;
alter  system set log_archive_dest_1='D:\oracle\product\10.2.0\arch' scope=spfil
e
*
第 1 行出现错误:
ORA-32017: 更新 SPFILE 时失败
ORA-16179: 不允许使用 SPFILE 对 "log_archive_dest_1" 进行增量更改

SQL> alter system set log_archive_dest_1='location=D:\oracle\product\10.2.0\arch
\arch' scope=spfile;

系统已更改。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21416913/viewspace-719199/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21416913/viewspace-719199/