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

转：http://space.itpub.net/23163255/viewspace-662279
log_archive_start参数在10g中已经被抛弃，无意间给设置后：

SQL> show parameter log_archive_start;

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

系统已更改。

SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE 例程已经启动。

Total System Global Area  452984832 bytes
Fixed Size                  1979360 bytes
Variable Size             130026528 bytes
Database Buffers          314572800 bytes
Redo Buffers                6406144 bytes
数据库装载完毕。
数据库已经打开。

每次启动都会出现这个提示信息：ORA-32004: obsolete and/or deprecated parameter(s) specified

采用这个方法修改后重启是无法消除的，因为数据库还是默认该参数被启用过：

alter system set log_archive_start=false scope=spfile;

SQL> show parameter log_archive_start

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_start                    boolean     FALSE
SQL> alter system reset  log_archive_start scope=spfile;
alter system reset  log_archive_start scope=spfile
                                                 *
第 1 行出现错误:
ORA-00905: 缺失关键字

SQL> alter system reset  log_archive_start scope=spfile sid='*';

系统已更改。

SQL> shutdown immediate
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。

Total System Global Area  452984832 bytes
Fixed Size                  1979360 bytes
Variable Size             130026528 bytes
Database Buffers          314572800 bytes
Redo Buffers                6406144 bytes
数据库装载完毕。
数据库已经打开。

那么，怎么查看那些参数被抛弃了呢：

SQL> set pagesize 2000
SQL> select name,description from v$parameter where isdeprecated='TRUE';

NAME                                                                             DESCRIPTION
-------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
lock_name_space                                                                  lock name space used for generating lock names for standby/clone database
buffer_pool_keep                                                                 Number of database blocks/latches in keep buffer pool
buffer_pool_recycle                                                              Number of database blocks/latches in recycle buffer pool
max_commit_propagation_delay                                                     Max age of new snapshot in .01 seconds
remote_archive_enable                                                            remote archival enable setting
log_archive_start                                                                start archival process on SGA initialization
parallel_server                                                                  if TRUE startup in parallel server mode
parallel_server_instances                                                        number of instances to use for sizing OPS SGA structures
fast_start_io_target                                                             Upper bound on recovery reads
logmnr_max_persistent_sessions                                                   maximum number of threads to mine
serial_reuse                                                                     reuse the frame. segments
max_enabled_roles                                                                max number of roles a user can have enabled
global_context_pool_size                                                         Global Application Context Pool Size in Bytes
plsql_compiler_flags                                                             PL/SQL compiler flags
sql_trace                                                                        enable SQL trace
parallel_automatic_tuning                                                        enable intelligent defaults for parallel execution parameters
drs_start                                                                        start DG Broker monitor (DMON process)

已选择17行。