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行。
广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员
