关于ORA-32004错误解决办法

最新推荐文章于 2024-09-04 09:35:30 发布

dabaishaflyw

最新推荐文章于 2024-09-04 09:35:30 发布

阅读量983

点赞数

分类专栏： oracle 学习笔记

本文链接：https://blog.csdn.net/zhiyuzhe/article/details/8118421

版权

oracle 学习笔记专栏收录该内容

4 篇文章 0 订阅

订阅专栏

不小心把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>