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;
------------------------------------ ----------- ------------------------------
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 例程已经启动。
数据库已经关闭。
已经卸载数据库。
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
数据库装载完毕。
数据库已经打开。
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: 缺失关键字
------------------------------------ ----------- ------------------------------
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 例程已经启动。
数据库已经关闭。
已经卸载数据库。
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
数据库装载完毕。
数据库已经打开。
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';
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)
-------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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行。