归档日志多归档路径 duplex

昨天用RMAN备份了多份归档日志，不由得想到归档日志在归档的时候也可以多路径，可能还有有相应的需求，于是做个小实验，看一下。
C:\Documents and Settings\Administrator>sqlplus / as sysdba


SQL*Plus: Release 10.2.0.3.0 - Production on 星期一 12月 2 09:41:42 2013


Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.




Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options


SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            F:\arch
Oldest online log sequence     2461
Next log sequence to archive   2463
Current log sequence           2463
SQL> alter system switch logfile;


System altered.


SQL> show parameter log_archive_dest--我的原归档日志路径在F:\arch下


NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_dest                     string
F:\arch
log_archive_dest_1                   string


log_archive_dest_10                  string


log_archive_dest_2                   string


log_archive_dest_3                   string


NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------


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


NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
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


NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
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='F:\arch1';--尝试去修改，却遇到了错误
alter system set log_archive_dest_1='F:\arch1'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-16179: incremental changes to "log_archive_dest_1" not allowed with SPFILE




SQL> alter system set log_archive_duplex_dest='F:\arch1';--查了下官方文档，重新进行了修改


System altered.


SQL> alter system switch logfile;--此时再进行归档的时候，发现两个归档路径F:\arch以及F:\arch1都有了归档日志


System altered.




SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options


C:\Documents and Settings\Administrator>sqlplus / as sysdba


SQL*Plus: Release 10.2.0.3.0 - Production on 星期一 12月 2 09:46:46 2013


Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.




Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options


SQL> archive log list;--
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            F:\arch1
Oldest online log sequence     2463
Next log sequence to archive   2465
Current log sequence           2465

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

转载于:http://blog.itpub.net/26084062/viewspace-1061812/