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>
: