Oracle10g之ORA-32004問題

　　今天在學習管理archivelog時遇到了ORA錯誤下面是解決方案

　　
SQL> shutdown immediate;
Database closed
Database dismounted
ORACLE instance shut down
SQL> startup
ORA: obsolete and/or deprecated parameter(s) specified
ORACLE instance started
Total System Global Area  bytes
Fixed Size                  bytes
Variable Size              bytes
Database Buffers           bytes
Redo Buffers                bytes
Database mounted
Database opened

　　查看oracle給出的問題描述

　　 SQL> host oerr ora ;
obsolete and/or deprecated parameter(s) specified
// *Cause:  One or more obsolete and/or parameters were specified in
//          the SPFILE or the PFILE on the server side
// *Action: See alert log for a list of parameters that are obsolete
//          or deprecated Remove them from the SPFILE or the server
//          side PFILE

　　去看看spfile

　　 *log_archive_format=%t_%s_%rdbf
*log_archive_max_processes=
*log_archive_start=FALSE
*log_archive_trace=

　　然後在看看alert log文件裡面會出現以下信息

　　 Deprecated system parameters with specified values:
  log_archive_start
End of deprecated system parameter listing

　　查了查資料說是oracle G已經不支持該參數了當打開歸檔模式（archive log mode） 則 ARCH 進程被隱性的自動設定g 中也就不會出現 i 以前那種數據庫已經在歸檔模式但是自動歸檔沒有被設定的情況了要解決該問題需要重置 log_archive_start 參數

　　
SQL> alter system reset log_archive_start SCOPE=SPFILE SID=*;
System altered
SQL> shutdown immediate;
Database closed
Database dismounted
ORACLE instance shut down
SQL> startup
ORACLE instance started
Total System Global Area  bytes
Fixed Size                  bytes
Variable Size              bytes
Database Buffers           bytes
Redo Buffers                bytes
Database mounted
Database opened

　　重啟後再不報ORA錯誤了！

　　查看g中都有那些參數是 deprecated 的

　　 SQL>select namedescription from v$parameter where isdeprecated = TRUE;

    上面提到的alert log文件位於%ORACLE_BASE%\admin\%ORACLE_SID%\bdump裡
From:http://tw.wingwit.com/Article/program/Oracle/201311/16555.html