ORA-32004 的错误处理

启动数据库时，收到了ORA-32004 的错误，错误多是一些过时且在当前版本中不在使用的参数，如果碰到类似的错误，只需要将其

reset即可。

SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 672256000 bytes
Fixed Size 2216384 bytes
Variable Size 457182784 bytes
Database Buffers 209715200 bytes
Redo Buffers 3141632 bytes
Database mounted.
Database opened.

查看错误原因：

———分析错误

SQL> ho oerr ora 32004
32004, 00000, "obsolete or deprecated parameter(s) specified for %s instance"
// *Cause: Obsolete or deprecated parameters for this instance type
// 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.  

 

--从告警日志中获得如下信息

Deprecated system parameters with specified values:
log_archive_start

 

解决办法：SQL> alter system reset log_archive_start scope=spfile sid='*';