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

SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1218316 bytes
Variable Size              92276980 bytes
Database Buffers           71303168 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.

解决方法详述：（来自一好心的网友）

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 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> 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 rows selected.