oracle startup 00439,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) spe

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>

更多Oracle相关信息见Oracle专题页面http://www.68idc.cn/topicnews.aspx?tid=12