更改archive log 歸檔路徑和歸檔檔名稱

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/oracle/product/dbs/arch
Oldest online log sequence     749
Next log sequence to archive   751
Current log sequence           751
SQL> show parameter archive

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

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

log_archive_dest_2                   string

log_archive_dest_3                   string

log_archive_dest_4                   string

log_archive_dest_5                   string

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_dest_6                   string

log_archive_dest_7                   string

log_archive_dest_8                   string

log_archive_dest_9                   string

log_archive_dest_state_1             string

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

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

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
enable
log_archive_duplex_dest              string

log_archive_format                   string
ora_%t_%s_%r.arc
log_archive_local_first              boolean
TRUE
log_archive_max_processes            integer
2

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

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
?/dbs/arch
SQL> alter system set log_archive_dest_1="location=/oratest/arch" scope=both;

System altered.

SQL> show parameter log_archive_dest_1

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_dest_1                   string
location=/oratest/arch
log_archive_dest_10                  string

SQL> alter system set log_archive_format="oratest_%t_%S_%r.arc" scope=both;
alter system set log_archive_format="oratest_%t_%S_%r.arc" scope=both
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified

//不可修改記憶體中的引數，只可修改spfile中的，重啟資料庫生效

SQL> alter system set log_archive_format="oratest_%t_%S_%r.arc" scope=spfile;

System altered.
SQL> show parameter log_archive_format

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_format                   string
ora_%t_%s_%r.arc
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 591396864 bytes
Fixed Size                  2022536 bytes
Variable Size             159384440 bytes
Database Buffers          423624704 bytes
Redo Buffers                6365184 bytes
Database mounted.
Database opened.
SQL> show parameter log_archive_format

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_format                   string
oratest_%t_%S_%r.arc

// t 是thread 的意思，通常單例項模式的為 1 ,RAC模式的會有多個情況

// S 指序列號，有固定長度的，不足的將前補0，s沒有固定長度，按順序顯示
SQL> alter system switch logfile;

System altered.

//切換redo log 從一個組到另一個組，這時將觸發checkpoint，歸檔

SQL> alter system switch logfile;

System altered.

SQL> !ls -l /oratest/arch

SQL> archive log list
Database log mode              Archive Mode   //歸檔和非歸檔模式
Automatic archival             Enabled                //顯示是自動還是手動
Archive destination            /oratest/arch         //歸檔目錄，已修改。有多個時只顯示一個，dest_1的
Oldest online log sequence     751               //已經歸檔的sequence 號
Next log sequence to archive   753               // 即將要歸檔的sequence 號
Current log sequence           753                    // 當前的sequence 號
SQL> spool off

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/24558279/viewspace-701139/，如需轉載，請註明出處，否則將追究法律責任。

更改archive log 歸檔路徑和歸檔檔名稱

相關文章