測試log_archive_dest_1與log_archive_format對生成的歸檔檔名的影響

還不算暈發表於2016-02-01
原文網址 : https://blog.csdn.net/haibusuanyun/article/details/50619253
HiveORM
客戶反映歸檔的位置不太多，再仔細看歸檔的名字也不對；檢查下發現指定 歸檔目錄類似
/arch/test 而不是/arch/test/
如下測試驗證log_archive_dest_1與log_archive_format對生成的歸檔檔名的影響。

1.log_archive_dest_1指定的目錄後面還有欄位

1.1. 欄位對應的無同名目錄，生成歸檔檔名=log_archive_dest_1+log_archive_format

1.2 欄位對應的有同名目錄，生成歸檔檔案在同名目錄下，檔名為log_archive_format

2.log_archive_dest_1指定的目錄不存在--報錯

3.log_archive_dest_1指定的目錄
歸檔檔名=log_archive_format

-----------------------------------

1 log_archive_dest_1指定的目錄後面還有欄位

1.1. 欄位對應的無同名目錄，生成歸檔檔名=log_archive_dest_1+log_archive_format

歸檔檔名=log_archive_dest_1+log_archive_format
SQL> alter system set log_archive_dest_1='LOCATION=/u01/oracle/base/oracle/oradata/arch/test';
System altered.
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/oracle/base/oracle/oradata/arch/test
Oldest online log sequence     24
Next log sequence to archive   26
Current log sequence           26
SQL> show parameter log_archive_format
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_format                   string      %t_%s_%r.dbf
SQL> alter system switch logfile;
System altered.
--------生成的檔名
[oracle@bys1 arch]$ pwd
/u01/oracle/base/oracle/oradata/arch
[oracle@bys1 arch]$ ls
test1_26_900253622.dbf

1.2 欄位對應的有同名目錄，生成歸檔檔案在同名目錄下，檔名為log_archive_format

檔案在同名目錄下，檔名為log_archive_format

SQL> alter system switch logfile;
System altered.

[oracle@bys1 test]$ pwd
/u01/oracle/base/oracle/oradata/arch/test
[oracle@bys1 test]$ ls
1_40_900253622.dbf

2.log_archive_dest_1指定的目錄不存在--直接報錯
SQL> alter system set log_archive_dest_1='LOCATION=/u01/oracle/base/oracle/oradata/arch/test/';
alter system set log_archive_dest_1='LOCATION=/u01/oracle/base/oracle/oradata/arch/test/'
*
ERROR at line 1:
ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16032: parameter LOG_ARCHIVE_DEST_1 destination string cannot be translated
ORA-07286: sksagdi: cannot obtain device information.
Linux Error: 2: No such file or directory

3.log_archive_dest_1指定目錄
歸檔檔名=log_archive_format
[oracle@bys1 arch]$ mkdir test
[oracle@bys1 arch]$ ls
test  test1_26_900253622.dbf
SQL> alter system set log_archive_dest_1='LOCATION=/u01/oracle/base/oracle/oradata/arch/test/';
System altered.
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/oracle/base/oracle/oradata/arch/test/
Oldest online log sequence     25
Next log sequence to archive   27
Current log sequence           27
SQL> show parameter log_archive_format
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_format                   string      %t_%s_%r.dbf
SQL> alter system switch logfile;
System altered.
---------
[oracle@bys1 arch]$ cd test
[oracle@bys1 test]$ ls -al
total 12
drwxr-xr-x 2 oracle oinstall 4096 Feb  1 16:13 .
drwxr-xr-x 3 oracle oinstall 4096 Feb  1 16:13 ..
-rw-r----- 1 oracle asmadmin 2560 Feb  1 16:13 1_27_900253622.dbf
[oracle@bys1 test]$ pwd
/u01/oracle/base/oracle/oradata/arch/test



相關文章