ORA-00439: feature not enabled: Managed Standby

最新推荐文章于 2025-09-09 14:54:38 发布

原创最新推荐文章于 2025-09-09 14:54:38 发布 · 1w 阅读

0 ·

CC 4.0 BY-SA版权

oracle problem 同时被 2 个专栏收录

61 篇文章

订阅专栏

oracle dataguard

27 篇文章

订阅专栏

博客围绕Oracle实例启动报错展开，分析得知是启动参数报错。详细介绍了解决步骤，包括导出参数文件、修改参数文件（去掉archive_dest、fal、standby）、重新生成参数文件，最后重新启动到nomount。

1，启动oracle实例报错：

SQL> startup nomount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-00439: feature not enabled: Managed Standby
SQL> 

SQL> startup nomount;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORA-00439: feature not enabled: Managed Standby
SQL>

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

ORA-00439: feature not enabled: Managed Standby
Thu Dec 03 11:39:24 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Errors 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=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'
*.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 instance
ORACLE instance started.

Total System Global Area 1.1358E+10 bytes
Fixed Size		    2216744 bytes
Variable Size		 8254393560 bytes
Database Buffers	 3087007744 bytes
Redo Buffers		   13946880 bytes
SQL>