歸檔日誌多歸檔路徑 duplex

wzz123snow發表於2013-12-02
昨天用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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章