关于ORA-32004错误解决办法

来源：互联网发布：merline mac 破解版编辑：程序博客网时间：2024/06/05 04:52

不小心把log_archive_start 设置为true了，结果每次启动数据库都报警：

ORA-32004: obsolete and/or deprecated parameter(s) specified

由于这个参数是oracle10g废弃的参数，以下是处理该问题的方法。

SQL> show parameter log_archive_start

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_start                    boolean     FALSE
SQL> alter system set log_archive_start=true scope=spfile;

System altered.

SQL> show parameter log_archive_start

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_start                    boolean     FALSE
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 608174080 bytes
Fixed Size                  1220820 bytes
Variable Size             213913388 bytes
Database Buffers          385875968 bytes
Redo Buffers                7163904 bytes
Database mounted.
Database opened.
SQL> alter system set log_archive_start=false scope=spfile;（没起作用啊，再次启动还是报警）

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 608174080 bytes
Fixed Size                  1220820 bytes
Variable Size             213913388 bytes
Database Buffers          385875968 bytes
Redo Buffers                7163904 bytes
Database mounted.
Database opened.
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 608174080 bytes
Fixed Size                  1220820 bytes
Variable Size             213913388 bytes
Database Buffers          385875968 bytes
Redo Buffers                7163904 bytes
Database mounted.
Database opened.
SQL>