ORA-00439: feature not enabled: Managed Standby

1，启动Oracle实例报错：

SQL> startup nomountORA-32004: obsolete or deprecated parameter（s） specified for RDBMS instanceORA-00439: feature not enabled: Managed StandbySQL> SQL> startup nomount;ORA-32004: obsolete or deprecated parameter（s） specified for RDBMS instanceORA-00439: feature not enabled: Managed StandbySQL>

2，后台alert日志trac日志报错如下：

ORA-00439: feature not enabled: Managed StandbyThu Dec 03 11:39:24 2015Starting ORACLE instance （normal）LICENSE_MAX_SESSION = 0LICENSE_SESSIONS_WARNING = 0Picked latch-free SCN scheme 3Errors in file /oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/powerdes_ora_5717.trc:ORA-00439: feature not enabled: Managed Standby

分析：是启动参数报错的缘故

3，导出参数文件

SQL> create pfile=’/oracle/pfile1203.ora’ from spfile;File created.SQL>参数文件内容如下：

powerdes.__db_cache_size=3087007744powerdes.__java_pool_size=67108864powerdes.__large_pool_size=67108864powerdes.__oracle_base="/oracle/app/oracle"#ORACLE_BASE set from environmentpowerdes.__pga_aggregate_target=3959422976powerdes.__sga_target=7449083904powerdes.__shared_io_pool_size=0powerdes.__shared_pool_size=4026531840powerdes.__streams_pool_size=134217728*.audit_file_dest="/oracle/app/oracle/admin/powerdes/adump"*.audit_sys_operations=TRUE*.audit_trail="NONE"*.compatible="11.2.0.0.0"*.control_files="/home/oradata/powerdes/control01.ctl","/oracle/app/oracle/flash_recovery_area/powerdes/control02.ctl"*.db_block_size=8192*.db_domain=""*.db_file_name_convert="/home/oradata/powerdes","/home/oradata/pwerdes"*.db_name="powerdes"*.db_recovery_file_dest="/oracle/app/oracle/flash_recovery_area"*.db_recovery_file_dest_size=16106127360*.db_unique_name="pdunq"*.diagnostic_dest="/oracle/app/oracle"*.dispatchers="（PROTOCOL=TCP） （SERVICE=powerdesXDB）"*.fal_client="PD"*.fal_server="PD_DG"*.global_names=FALSE*.job_queue_processes=1000*.log_archive_config="DG_CONFIG=（pdunq,pddgunq）"*.log_archive_dest_1="LOCATION=/oracle/app/oracle/flash_recovery_area/archivelog VALID_FOR=（ALL_LOGFILES,ALL_ROLES） DB_UNIQUE_NAME=pdunq"*.log_archive_dest_2="SERVICE=PD_DG VALID_FOR=（ONLINE_LOGFILES,PRIMARY_ROLE） DB_UNIQUE_NAME=pddgunq lgwr sync affirm"*.log_archive_dest_3=""*.log_archive_dest_state_1="ENABLE"*.log_archive_dest_state_2="defer"*.log_archive_dest_state_3="ENABLE"*.log_archive_format="%t_%s_%r.dbf"*.log_archive_max_processes=20*.log_archive_start=FALSE*.log_file_name_convert="/home/oradata/powerdes","/home/oradata/powerdes"*.memory_target=11379146752*.open_cursors=300*.optimizer_index_caching=90*.optimizer_index_cost_adj=25*.optimizer_mode="FIRST_ROWS"*.processes=1000*.remote_login_passwordfile="EXCLUSIVE"*.sessions=335*.standby_file_management="AUTO"*.undo_tablespace="UNDOTBS1"

4，修改参数文件

去掉archive_dest

*.log_archive_config="DG_CONFIG=（pdunq,pddgunq）"*.log_archive_dest_1="LOCATION=/oracle/app/oracle/flash_recovery_area/archivelog VALID_FOR=（ALL_LOGFILES,ALL_ROLES） DB_UNIQUE_NAME=pdunq"*.log_archive_dest_2="SERVICE=PD_DG VALID_FOR=（ONLINE_LOGFILES,PRIMARY_ROLE） DB_UNIQUE_NAME=pddgunq lgwr sync affirm"*.log_archive_dest_3=""*.log_archive_dest_state_1="ENABLE"*.log_archive_dest_state_2="defer"*.log_archive_dest_state_3="ENABLE"

去掉fal*.fal_client="PD"*.fal_server="PD_DG"去掉standby*.standby_file_management="AUTO"保存为pfile1203_01.ora：

powerdes.__db_cache_size=3087007744powerdes.__java_pool_size=67108864powerdes.__large_pool_size=67108864powerdes.__oracle_base="/oracle/app/oracle"#ORACLE_BASE set from environmentpowerdes.__pga_aggregate_target=3959422976powerdes.__sga_target=7449083904powerdes.__shared_io_pool_size=0powerdes.__shared_pool_size=4026531840powerdes.__streams_pool_size=134217728*.audit_file_dest="/oracle/app/oracle/admin/powerdes/adump"*.audit_sys_operations=TRUE*.audit_trail="NONE"*.compatible="11.2.0.0.0"*.control_files="/home/oradata/powerdes/control01.ctl"*.db_block_size=8192*.db_domain=""*.db_file_name_convert="/home/oradata/powerdes","/home/oradata/pwerdes"*.db_name="powerdes"*.db_recovery_file_dest="/oracle/app/oracle/flash_recovery_area"*.db_recovery_file_dest_size=16106127360*.db_unique_name="pdunq"*.diagnostic_dest="/oracle/app/oracle"*.dispatchers="（PROTOCOL=TCP） （SERVICE=powerdesXDB）"*.global_names=FALSE*.job_queue_processes=1000*.log_archive_dest_1="LOCATION=/oracle/app/oracle/flash_recovery_area/archivelog VALID_FOR=（ALL_LOGFILES,ALL_ROLES） DB_UNIQUE_NAME=pdunq"*.log_archive_dest_state_1="ENABLE"*.log_archive_format="%t_%s_%r.dbf"*.log_archive_max_processes=20*.log_archive_start=FALSE*.log_file_name_convert="/home/oradata/powerdes","/home/oradata/powerdes"*.memory_target=11379146752*.open_cursors=300*.optimizer_index_caching=90*.optimizer_index_cost_adj=25*.optimizer_mode="FIRST_ROWS"*.processes=1000*.remote_login_passwordfile="EXCLUSIVE"*.sessions=335*.undo_tablespace="UNDOTBS1"

5，重新生成参数文件

SQL> create spfile from pfile="/oracle/pfile1203_01.ora";File created.SQL>

6，重新启动到nomount

SQL> startup nomount;ORA-32004: obsolete or deprecated parameter（s） specified for RDBMS instanceORACLE instance started.Total System Global Area 1.1358E+10 bytesFixed Size2216744 bytesVariable Size8254393560 bytesDatabase Buffers 3087007744 bytesRedo Buffers 13946880 bytesSQL>

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址