做多元化控制文件时遇到了以下问题:
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area  285212672 bytes
Fixed Size                  1218992 bytes
Variable Size              88082000 bytes
Database Buffers          192937984 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.
 
查看oracle给出的问题描述:
SQL> host oerr ora 32004;
32004, 00000, "obsolete and/or deprecated parameter(s) specified"
// *Cause:  One or more obsolete and/or parameters were specified in
//          the SPFILE or the PFILE on the server side.
// *Action: See alert log for a list of parameters that are obsolete.
//          or deprecated. Remove them from the SPFILE or the server
//          side PFILE.
查了查资料说是oracle 10G已经不支持该参数了,当打开归档模式(archive log mode) ,则 ARCH 进程被隐性的自动设定。10g 中也就不会出现 9i 以前那种数据库已经在归档模式,但是自动归档没有被设定的情况了。要解决该问题需要重置 log_archive_start 参数。
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  285212672 bytes
Fixed Size                  1218992 bytes
Variable Size              88082000 bytes
Database Buffers          192937984 bytes
Redo Buffers                2973696 bytes
Database mounted.
Database opened.
重启后再不报ORA-32004错误了!
查看10g中都有那些参数是 deprecated 的:
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
NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
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
NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
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
NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
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
NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
global_context_pool_size
Global Application Context Pool Size in Bytes
plsql_compiler_flags
PL/SQL compiler flags
sql_trace
enable SQL trace
NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
parallel_automatic_tuning
enable intelligent defaults for parallel execution parameters
drs_start
start DG Broker monitor (DMON process)
17 rows selected.