ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-32004: obsolete and/or deprecated parameter(s) specified

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

原创 Linux操作系统 作者:it_newbalance 时间:2011-07-01 12:21:23 0 删除 编辑

oracle 10g 启动自动归档模式,通过设置 log_archive_start 并不会起到自动归档的作用反而数据库启动时会报出ORA-32004: obsolete and/or deprecated parameter(s) specified,操作如下(测试数据库已是自动归档模式)该方式适合9i数据库开通数据库归档和自动归档模式。

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/oracle/product/dbs/arch
Oldest online log sequence     745
Next log sequence to archive   747
Current log sequence           747
SQL> !ps -ef | grep oracle

SQL> show parameter archive

NAME                                 TYPE                                      
------------------------------------ ----------------------                    
VALUE                                                                          
------------------------------                                                 
archive_lag_target                   integer                                   
0                                                                              
log_archive_config                   string                                    
                                                                               
log_archive_dest                     string                                    
                                                                               
log_archive_dest_1                   string                                    
                                                                               
log_archive_dest_10                  string                                    

NAME                                 TYPE                                      
------------------------------------ ----------------------                    
VALUE                                                                          
------------------------------                                                 
                                                                               
log_archive_dest_2                   string                                    
                                                                               
log_archive_dest_3                   string                                    
                                                                               
log_archive_dest_4                   string                                    
                                                                               
log_archive_dest_5                   string                                    
                                                                               

NAME                                 TYPE                                      
------------------------------------ ----------------------                    
VALUE                                                                          
------------------------------                                                 
log_archive_dest_6                   string                                    
                                                                               
log_archive_dest_7                   string                                    
                                                                               
log_archive_dest_8                   string                                    
                                                                               
log_archive_dest_9                   string                                    
                                                                               
log_archive_dest_state_1             string                                    

NAME                                 TYPE                                      
------------------------------------ ----------------------                    
VALUE                                                                          
------------------------------                                                 
enable                                                                         
log_archive_dest_state_10            string                                    
enable                                                                         
log_archive_dest_state_2             string                                    
enable                                                                         
log_archive_dest_state_3             string                                    
enable                                                                         
log_archive_dest_state_4             string                                    
enable                                                                         

NAME                                 TYPE                                      
------------------------------------ ----------------------                    
VALUE                                                                          
------------------------------                                                 
log_archive_dest_state_5             string                                    
enable                                                                         
log_archive_dest_state_6             string                                    
enable                                                                         
log_archive_dest_state_7             string                                    
enable                                                                         
log_archive_dest_state_8             string                                    
enable                                                                         
log_archive_dest_state_9             string                                    

NAME                                 TYPE                                      
------------------------------------ ----------------------                    
VALUE                                                                          
------------------------------                                                 
enable                                                                         
log_archive_duplex_dest              string                                    
                                                                               
log_archive_format                   string                                    
ora_%t_%s_%r.arc                                                               
log_archive_local_first              boolean                                   
TRUE                                                                           
log_archive_max_processes            integer                                   
2                                                                              

NAME                                 TYPE                                      
------------------------------------ ----------------------                    
VALUE                                                                          
------------------------------                                                 
log_archive_min_succeed_dest         integer                                   
1                                                                              
log_archive_start                    boolean                                   
FALSE                                                                          
log_archive_trace                    integer                                   
0                                                                              
remote_archive_enable                string                                    
true                                                                           
standby_archive_dest                 string                                    

NAME                                 TYPE                                      
------------------------------------ ----------------------                    
VALUE                                                                          
------------------------------                                                 
?/dbs/arch                                                                     
SQL> alter system set log_archive_start=true scope=both;
alter system set log_archive_start=true scope=both
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified


SQL> alter system set log_archive_start=true;
alter system set log_archive_start=true
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified


SQL> alter system set log_archive_start=true scope=spfile;

System altered.

SQL> !mkdir /oratest/arch

SQL> alter system archive log start to '/oratest/arch';

System altered.

SQL> !ps -ef | grep oracle

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> alter system switch logfile;

System altered.

SQL> !cd /oratest/arch

SQL> !ls

SQL> alter system archive log stop;

System altered.

SQL> !ps -ef | grep oracle

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/oracle/product/dbs/arch
Oldest online log sequence     749
Next log sequence to archive   751
Current log sequence           751
SQL> alter system archive log start to '/oratest/arch';

System altered.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/oracle/product/dbs/arch
Oldest online log sequence     749
Next log sequence to archive   751
Current log sequence           751
SQL> !ps -ef | grep oracle

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area  591396864 bytes                                      
Fixed Size                  2022536 bytes                                      
Variable Size             142607224 bytes                                      
Database Buffers          440401920 bytes                                      
Redo Buffers                6365184 bytes                                      
Database mounted.
Database opened.
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u01/oracle/product/dbs/arch
Oldest online log sequence     749
Next log sequence to archive   751
Current log sequence           751
SQL> show parameter archive

NAME                                 TYPE                                      
------------------------------------ ----------------------                    
VALUE                                                                          
------------------------------                                                 
archive_lag_target                   integer                                   
0                                                                              
log_archive_config                   string                                    
                                                                               
log_archive_dest                     string                                    
                                                                               
log_archive_dest_1                   string                                    
                                                                               
log_archive_dest_10                  string                                    

NAME                                 TYPE                                      
------------------------------------ ----------------------                    
VALUE                                                                          
------------------------------                                                 
                                                                               
log_archive_dest_2                   string                                    
                                                                               
log_archive_dest_3                   string                                    
                                                                               
log_archive_dest_4                   string                                    
                                                                               
log_archive_dest_5                   string                                    
                                                                               

NAME                                 TYPE                                      
------------------------------------ ----------------------                    
VALUE                                                                          
------------------------------                                                 
log_archive_dest_6                   string                                    
                                                                               
log_archive_dest_7                   string                                    
                                                                               
log_archive_dest_8                   string                                    
                                                                               
log_archive_dest_9                   string                                    
                                                                               
log_archive_dest_state_1             string                                    

NAME                                 TYPE                                      
------------------------------------ ----------------------                    
VALUE                                                                          
------------------------------                                                 
enable                                                                         
log_archive_dest_state_10            string                                    
enable                                                                         
log_archive_dest_state_2             string                                    
enable                                                                         
log_archive_dest_state_3             string                                    
enable                                                                         
log_archive_dest_state_4             string                                    
enable                                                                         

NAME                                 TYPE                                      
------------------------------------ ----------------------                    
VALUE                                                                          
------------------------------                                                 
log_archive_dest_state_5             string                                    
enable                                                                         
log_archive_dest_state_6             string                                    
enable                                                                         
log_archive_dest_state_7             string                                    
enable                                                                         
log_archive_dest_state_8             string                                    
enable                                                                         
log_archive_dest_state_9             string                                    

NAME                                 TYPE                                      
------------------------------------ ----------------------                    
VALUE                                                                          
------------------------------                                                 
enable                                                                         
log_archive_duplex_dest              string                                    
                                                                               
log_archive_format                   string                                    
ora_%t_%s_%r.arc                                                               
log_archive_local_first              boolean                                   
TRUE                                                                           
log_archive_max_processes            integer                                   
2                                                                              

NAME                                 TYPE                                      
------------------------------------ ----------------------                    
VALUE                                                                          
------------------------------                                                 
log_archive_min_succeed_dest         integer                                   
1                                                                              
log_archive_start                    boolean                                   
TRUE                                                                           
log_archive_trace                    integer                                   
0                                                                              
remote_archive_enable                string                                    
true                                                                           
standby_archive_dest                 string                                    

NAME                                 TYPE                                      
------------------------------------ ----------------------                    
VALUE                                                                          
------------------------------                                                 
?/dbs/arch                                                                     
SQL> !ps -ef | grep oracle


SQL> alter system reset log_archive_start scope=spfile;
alter system reset log_archive_start scope=spfile
                                                *
ERROR at line 1:
ORA-00905: missing keyword


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  591396864 bytes
Fixed Size                  2022536 bytes
Variable Size             155190136 bytes
Database Buffers          427819008 bytes
Redo Buffers                6365184 bytes
Database mounted.
Database opened.
SQL> show parameter log_archive_start

NAME                                 TYPE
------------------------------------ ----------------------
VALUE
------------------------------
log_archive_start                    boolean
FALSE
SQL>

SQL> exit

 

启动数据库时,报如下错误:
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE 例程已经启动。

Total System Global Area  171966464 bytes
Fixed Size                   787988 bytes
Variable Size             145488364 bytes
Database Buffers           25165824 bytes
Redo Buffers                 524288 bytes
数据库装载完毕。
数据库已经打开。
SQL> ALTER SYSTEM RESET log_archive_start SCOPE=SPFILE SID='*';

系统已更改。

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

Total System Global Area  171966464 bytes
Fixed Size                   787988 bytes
Variable Size             145488364 bytes
Database Buffers           25165824 bytes
Redo Buffers                 524288 bytes
数据库装载完毕。
数据库已经打开。


知所以然:见下文[url]http://www.dbanotes.net/archives/2004/12/caecora32004.html[/url]

在 Oracle 10g 中,以前熟悉的一些参数已经 deprecated 了,有的时候很烦人。
SQL> STARTUP;
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.

Total System Global Area 213909504 bytes
Fixed Size 778156 bytes
Variable Size 128983124 bytes
Database Buffers 83886080 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.
SQL>
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.
SQL>
告诉我们去 alert log 中查看信息。查找...
Deprecated system parameters with specified values:
log_archive_start
End of deprecated system parameter listing
oops ,10g 不支持该参数了? 原来在 10g 中,当打开归档模式(archive log mode) ,则 ARCH 进程被隐性的自动设定。10g 中也就不会出现 9i 以前那种数据库已经在归档模式,但是自动归档没有被设定的情况了。这也算是 Oracle 修正的一个小Bug。如果是从 9i 升级到 10g 的话,不注意可能会有点小问题的。要解决该问题,需要重置 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 213909504 bytes
Fixed Size 778156 bytes
Variable Size 128983124 bytes
Database Buffers 83886080 bytes
Redo Buffers 262144 bytes
Database mounted.
Database opened.
SQL>
It's OK now. 查看一下 10g 中都有那些参数是 deprecated 的:
SQL> SELECT NAME, description
2 FROM v$parameter
3 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
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
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
parallel_automatic_tuning enable intelligent defaults for parallel execution parameters
drs_start start DG Broker monitor (DMON process)

12 rows selected.

SQL>
参数替代情况
Deprecated parameters in release 10g: 
------------------------------------------------

BUFFER_POOL_KEEP (replaced by DB_KEEP_CACHE_SIZE)
BUFFER_POOL_RECYCLE (replaced by DB_RECYCLE_CACHE_SIZE)
PLSQL_COMPILER_FLAGS (replaced by PLSQL_CODE_TYPE and PLSQL_DEBUG)
DRS_START (replaced by DG_BROKER_START)
FAST_START_IO_TARGET (replaced by FAST_START_MTTR_TARGET)
MTS_CIRCUITS (replaced by CIRCUITS)
MTS_DISPATCHERS (replaced by DISPATCHERS)
MTS_MAX_DISPATCHERS (replaced by MAX_DISPATCHERS)
MTS_MAX_SERVERS (replaced by MAX_SHARED_SERVERS)
MTS_SERVERS (replaced by SHARED_SERVERS)
MTS_SESSIONS (replaced by SHARED_SERVER_SESSIONS)
PARALLEL_SERVER (replaced by CLUSTER_DATABASE)
PARALLEL_SERVER_INSTANCES (replaced by CLUSTER_DATABASE_INSTANCES)

废弃的参数:
Obsolete parameters in 10g: 
---------------------------------------

DBLINK_ENCRYPT_LOGIN
HASH_JOIN_ENABLED
LOG_PARALLELISM
MAX_ROLLBACK_SEGMENTS
MTS_CIRCUITS
MTS_DISPATCHERS
MTS_LISTENER_ADDRESS
MTS_MAX_DISPATCHERS
MTS_MAX_SERVERS
MTS_MULTIPLE_LISTENERS
MTS_SERVERS
MTS_SERVICE
MTS_SESSIONS
OPTIMIZER_MAX_PERMUTATIONS
ORACLE_TRACE_COLLECTION_NAME
ORACLE_TRACE_COLLECTION_PATH
ORACLE_TRACE_COLLECTION_SIZE
ORACLE_TRACE_ENABLE
ORACLE_TRACE_FACILITY_NAME
ORACLE_TRACE_FACILITY_PATH
PARTITION_VIEW_ENABLED
PLSQL_NATIVE_C_COMPILER
PLSQL_NATIVE_LINKER
PLSQL_NATIVE_MAKE_FILE_NAME
PLSQL_NATIVE_MAKE_UTILITY
ROW_LOCKING
SERIALIZABLE
TRANSACTION_AUDITING
UNDO_SUPPRESS_ERRORS
DISTRIBUTED_TRANSACTIONS
MAX_TRANSACTION_BRANCHES
PARALLEL_BROADCAST_ENABLED
STANDBY_PRESERVES_NAMES
ALWAYS_ANTI_JOIN
ALWAYS_SEMI_JOIN
DB_BLOCK_LRU_LATCHES
DB_BLOCK_MAX_DIRTY_TARGET
DB_FILE_DIRECT_IO_COUNT
GC_DEFER_TIME
GC_RELEASABLE_LOCKS
GC_ROLLBACK_LOCKS
HASH_MULTIBLOCK_IO_COUNT
INSTANCE_NODESET
JOB_QUEUE_INTERVAL
OPS_INTERCONNECTS
OPTIMIZER_PERCENT_PARALLEL
SORT_MULTIBLOCK_READ_COUNT
TEXT_ENABLE

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24558279/viewspace-701121/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-03-28

  • 博文量
    143
  • 访问量
    704593