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=3087007744    powerdes.__java_pool_size=67108864    powerdes.__large_pool_size=67108864    powerdes.__oracle_base='/oracle/app/oracle'#ORACLE_BASE set from environment    powerdes.__pga_aggregate_target=3959422976    powerdes.__sga_target=7449083904    powerdes.__shared_io_pool_size=0    powerdes.__shared_pool_size=4026531840    powerdes.__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 Size          2216744 bytesVariable Size        8254393560 bytesDatabase Buffers     3087007744 bytesRedo Buffers           13946880 bytesSQL>