Ora-00439:feature not enabled:managed Standby

1. Start Oracle Instance Error:

2, the background alert log TRAC log error as follows:

ORA-00439not0311:39:242015Starting ORACLE instance (normal003infile /oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/powerdes_ora_5717.trc:ORA-00439not enabled: Managed Standby

Analysis: Is the cause of the start parameter error

3. Export the parameter file

sql> create pfile= '/oracle/pfile1203.ora ' from SPFile;

File created.

Sql>

The contents of the parameter file are as follows:

Powerdes.__db_cache_size=3087007744Powerdes.__java_pool_size=67108864Powerdes.__large_pool_size=67108864Powerdes.__oracle_base='/oracle/app/oracle '#ORACLE_BASESet  fromEnvironment powerdes.__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= +*.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= -*.log_archive_start=FALSE*.log_file_name_convert='/home/oradata/powerdes ','/home/oradata/powerdes '*.memory_target=11379146752*.open_cursors= -*.optimizer_index_caching= -*.optimizer_index_cost_adj= -*.optimizer_mode=' First_rows '*.processes= +*.remote_login_passwordfile=' EXCLUSIVE '*.sessions=335*.standby_file_management=' AUTO '*.undo_tablespace=' UNDOTBS1 '

4. Modify the parameter file

Remove 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‘

Remove FAL

*.fal_client=‘PD‘*.fal_server=‘PD_DG‘

Remove standby

*.standby_file_management=‘AUTO‘

Save As Pfile1203_01.ora:

Powerdes.__db_cache_size=3087007744Powerdes.__java_pool_size=67108864Powerdes.__large_pool_size=67108864Powerdes.__oracle_base='/oracle/app/oracle '#ORACLE_BASESet  fromenvironmentpowerdes.__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= +*.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= -*.log_archive_start=FALSE*.log_file_name_convert='/home/oradata/powerdes ','/home/oradata/powerdes '*.memory_target=11379146752*.open_cursors= -*.optimizer_index_caching= -*.optimizer_index_cost_adj= -*.optimizer_mode=' First_rows '*.processes= +*.remote_login_passwordfile=' EXCLUSIVE '*.sessions=335*.undo_tablespace=' UNDOTBS1 '

5. Regenerate the parameter file

6, reboot to 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           

Ora-00439:feature not enabled:managed Standby