今天研究log_archive_desc与log_archive_desc_n，发现不能同时启动；间引用的文章链接。感谢我的blog朋友

http://www.dbasupport.com/forums/printthread.php?t=22578

[@more@]

ORA-16032: parameter LOG_ARCHIVE_DEST destination

我想修改歸檔日志的路徑時
alter system set log_archive_dest="location=f:oracleoradataarchivelog" scope=spfile;
沒有用
後來又執行
alter system set log_archive_dest_1="location=f:oracleoradataarchivelog" scope=both;
看到該路徑下有日志產生了
重起後startup mount報錯
ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated
ORA-09291: sksachk: invalid device specified for archive destination
OSD-04018: Ξ???？？????？?？??？????
O/S-Error: (OS 123) ？??？??？？？???？？????？？??

怎樣將數據庫起來?
alter system set log_archive_dest="location=f:oracleoradataarchivelog" scope=spfile;

location去掉

startup mount報錯
怎麼執行
alter system set log_archive_dest="f:oracleoradataarchivelog" scope=spfile;

create pfile from spfile
edit pfile
create spfile from pfile

pfile文件裡面為什麼看不到這幾個參數
log_archive_start
log_archive_dest
log_archive_format

ITPub博客

log_archive_desc与log_archive_desc_n的使用

最新文章