[20170625]参数LOG_ARCHIVE_DEST_1.txt
--//昨天帮别人解决问题时再次遇到,在测试环境重复测试.
1.环境:
SCOTT@book> @ &r/ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
SCOTT@book> show parameter log_archive_dest_1
NAME TYPE VALUE
------------------ ------ ---------------------------------------------------------------------------------------------------------
log_archive_dest_1 string LOCATION=/u01/app/oracle/archivelog/book MANDATORY VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=book
--//别人的环境没有建立book目录.
$ mv /u01/app/oracle/archivelog/book /u01/app/oracle/archivelog/bookx
2.现在做日志切换看看.
SCOTT@book> alter system archive log current ;
System altered.
--//一样ok.
$ ls -l /u01/app/oracle/archivelog/
total 13896
-rw-r--r-- 1 oracle oinstall 6 2017-04-12 10:58:26 a.txt
-rw-r----- 1 oracle oinstall 14199296 2017-06-26 09:23:22 book1_710_896605872.dbf
drwxr-xr-x 2 oracle oinstall 4096 2017-06-23 15:24:55 bookx
--//你可以发现归档放在/u01/app/oracle/archivelog目录,文件命令为book1_710_896605872.dbf.
SCOTT@book> show parameter log_archive_format
NAME TYPE VALUE
------------------ ------ ------------
log_archive_format string %t_%s_%r.dbf
--//有一种说法,最好在book尾部加入斜线.
SCOTT@book> alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/archivelog/book/ MANDATORY VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=book';
alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/archivelog/book/ MANDATORY VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=book'
*
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-x86_64 Error: 2: No such file or directory
--//你可以发现这样问题很容易暴露.
$ mv /u01/app/oracle/archivelog/bookx /u01/app/oracle/archivelog/book
--//再次执行就ok了.
SCOTT@book> alter system set log_archive_dest_1='LOCATION=/u01/app/oracle/archivelog/book/ MANDATORY VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=book';
System altered.
SCOTT@book> alter system archive log current ;
System altered.
$ ls -l /u01/app/oracle/archivelog/book/ | grep 2017-06-26
-rw-r----- 1 oracle oinstall 837120 2017-06-26 09:30:01 1_711_896605872.dbf
--//关于斜线的问题,最突出的是$ORACLE_HOME.
$ echo $ORACLE_HOME
/u01/app/oracle/product/11.2.0.4/dbhome_1
--//不过11.2.0.4这个问题已经不存在了.参考链接:blog.itpub.net/267265/viewspace-2055052/ =>[20160310]神奇的斜线.txt
