今天在学习管理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里
