当前位置:  数据库>oracle

ORA-00439: feature not enabled: Managed Standby

    来源: 互联网  发布时间:2017-06-21

    本文导语: 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: ...

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> 


    
 
 

您可能感兴趣的文章:

 
本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • 出现ORA-01401和ORA-01008错误?
  • Eclipse连接Oracle数据库的ORA-00604 ORA-12705错误
  • oracle ORA-01114、ORA-27067错误解决方法
  • Oracle不能删除表 ORA-00604 ORA-01422 错误
  • 如何得到带有ora的行的下一行
  • ORA-12514及ORA-28547错误解决方案
  • 如何配置 linux 下 oracle 的 listener .ora 和
  • 浅析如何在tnsnames.ora中配置监听
  • Orcle的package中访问其它Schema的表报错ORA-00942解决方法
  • oracle远程连接服务器出现 ORA-12170 TNS:连接超时 解决办法
  • [Oracle] 浅析令人抓狂的ORA-01555问题
  • 解决报错ora-32035的方法分析
  • aq.executeQuery: ORA-00020: maximum number of processes (59) exceeded
  • Oracle 数据库闪回功能设置出现ORA-19809和ORA-19804错误
  • ORA-00947:Not enough values (没有足够的值)的深入分析
  • solaris10 安装 ora9.2.0.1 时报错
  • 在UNIX下,我的ORA817该怎么样才可以自己启动呀?
  • 基于ORA-12170 TNS 连接超时解决办法详解
  • plsql连接oracle数据库报ora 12154错误解决方法
  • 安装oracle出现error:ora-01031:insufficient privilleges的解决


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,,E-mail:www_#163.com(请将#改为@)

    浙ICP备11055608号-3