Feature not enabled: Managed Standby ORA-00439:

Label ORA-00439
1366 people read comment(0) Collection Report
Classification:

1, start Oracle instance error:

Startup nomount SQL>
Obsolete or deprecated parameter ORA-32004: (s) for RDBMS instance specified
Feature not enabled: Managed Standby ORA-00439:
SQL>

Startup nomount SQL>;
Obsolete or deprecated parameter ORA-32004: (s) for RDBMS instance specified
Feature not enabled: Managed Standby ORA-00439:
SQL>

2, the background trac log alert log is as follows:

ORA-00439FeatureNotManaged Standby enabled:
Dec Thu03 Eleven:Thirty-nine:Twenty-four Two thousand and fifteen
ORACLE instance Starting (Normal)
LICENSE_MAX_SESSION =Zero
LICENSE_SESSIONS_WARNING =Zero
Latch-free SCN scheme PickedThree
ErrorsIn File/oracle/app/oracle/diag/rdbms/pdunq/powerdes/trace/powerdes_ora_5717.trc:
ORA-00439FeatureNotManaged Standby enabled:

Analysis: is the reason for starting the error of the parameters


3, export parameter file

Create pfile= /oracle/pfile1203.ora 'from' SPFILE SQL>;

Created. File

SQL>

The contents of the parameters are as follows:

Powerdes.__db_cache_size=Three billion eighty-seven million seven thousand seven hundred and forty-four
Powerdes.__java_pool_size=Sixty-seven million one hundred and eight thousand eight hundred and sixty-four
Powerdes.__large_pool_size=Sixty-seven million one hundred and eight thousand eight hundred and sixty-four
Powerdes.__oracle_base='/oracle/app/oracle'#ORACLE_BASESet FromEnvironment
Powerdes.__pga_aggregate_target=Three billion nine hundred and fifty-nine million four hundred and twenty-two thousand nine hundred and seventy-six
Powerdes.__sga_target=Seven billion four hundred and forty-nine million eighty-three thousand nine hundred and four
Powerdes.__shared_io_pool_size=Zero
Powerdes.__shared_pool_size=Four billion twenty-six million five hundred and thirty-one thousand eight hundred and forty
Powerdes.__streams_pool_size=One hundred and thirty-four million two hundred and seventeen thousand seven hundred and twenty-eight
*.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=Eight thousand one hundred and ninety-two
*.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=Sixteen billion one hundred and six million one hundred and twenty-seven thousand three hundred and sixty
*.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=One thousand
*.log_archive_config='DG_CONFIG= (pdunq, pddgunq)
*.log_archive_dest_1=VALID_FOR='LOCATION=/oracle/app/oracle/flash_recovery_area/archivelog (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME=pdunq'
*.log_archive_dest_2=VALID_FOR='SERVICE=PD_DG (ONLINE_LOGFILES, PRIMARY_ROLE) LGWR sync affirm'DB_UNIQUE_NAME=pddgunq
*.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=Twenty
*.log_archive_start=FALSE
*.log_file_name_convert='/home/oradata/powerdes','/home/oradata/powerdes'
*.memory_target=Eleven billion three hundred and seventy-nine million one hundred and forty-six thousand seven hundred and fifty-two
*.open_cursors=Three hundred
*.optimizer_index_caching=Ninety
*.optimizer_index_cost_adj=Twenty-five
*.optimizer_mode='FIRST_ROWS'
*.processes=One thousand
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=Three hundred and thirty-five
*.standby_file_management='AUTO'
*.undo_tablespace='UNDOTBS1'

4, modify the parameter file

Get rid of archive_dest

*.log_archive_config='DG_CONFIG= (pdunq, pddgunq)
*.log_archive_dest_1=VALID_FOR='LOCATION=/oracle/app/oracle/flash_recovery_area/archivelog (ALL_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME=pdunq'
*.log_archive_dest_2=VALID_FOR='SERVICE=PD_DG (ONLINE_LOGFILES, PRIMARY_ROLE) LGWR sync affirm'DB_UNIQUE_NAME=pddgunq
*.log_archive_dest_3='
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='defer'
*.log_archive_dest_state_3='ENABLE'

Get rid of fal

* fal_client =。“钯”
* fal_server =。“pd_dg”

去掉备用

* standby_file_management =。“自动”

保存为pfile1203_01.ora:

powerdes __db_cache_size =。三十亿八千七百万七千七百四十四
powerdes __java_pool_size =。六千七百一十万八千八百六十四
powerdes __large_pool_size =。六千七百一十万八千八百六十四
powerdes __oracle_base =。/甲骨文/应用/甲骨文# oracle_base 环境
powerdes __pga_aggregate_target =。三十九亿五千九百四十二万二千九百七十六
powerdes __sga_target =。七十四亿四千九百零八万三千九百零四
powerdes __shared_io_pool_size =。
powerdes __shared_pool_size =。四十亿二千六百五十三万一千八百四十
powerdes __streams_pool_size =。一亿三千四百二十一万七千七百二十八
* audit_file_dest =。“/数据库/应用程序/ Oracle /管理/ powerdes / adump”
* audit_sys_operations =。真的
* audit_trail =。'没有'
*兼容=“11.2.0.0.0”
* control_files =。“/家/ oradata / powerdes / control01 CTL”。
* db_block_size =。八千一百九十二
* db_domain =。' '
* db_file_name_convert =。“/家/ oradata / powerdes”“/家/ oradata / pwerdes”
* db_name =。“powerdes”
* db_recovery_file_dest =。“/甲骨文/应用程序/ Oracle / flash_recovery_area”
* db_recovery_file_dest_size =。一百六十一亿零六百一十二万七千三百六十
* db_unique_name =。“pdunq”
* diagnostic_dest =。/甲骨文/应用/甲骨文
*。调度员=“(协议为TCP)(服务= powerdesxdb)”
* global_names =。
* job_queue_processes =。一千
* log_archive_dest_1 =。位置= /甲骨文/应用程序/ Oracle / flash_recovery_area /归档valid_for =(all_logfiles,all_roles)db_unique_name = pdunq”
* log_archive_dest_state_1 =。“启用”
* log_archive_format =。“% % % t_ s_ r.dbf”
* log_archive_max_processes =。二十
* log_archive_start =。
* log_file_name_convert =。“/家/ oradata / powerdes”“/家/ oradata / powerdes”
* memory_target =。一百一十三亿七千九百一十四万六千七百五十二
* open_cursors =。三百
* optimizer_index_caching =。九十
* optimizer_index_cost_adj =。二十五
* optimizer_mode =。“first_rows”
*过程=一千
* remote_login_passwordfile =。'独家'
*会议=三百三十五
* undo_tablespace =。“undotbs1”

5、重新生成参数文件

SQL >创建pfile = /深圳/博客/甲骨文/ pfile1203_01 SPFILE。吾”;

创建文件。

SQL >

6、重新启动到安装

警告:安装启动;
ora-32004:过时或废弃的参数(S)数据库的实例指定
实例开始。

总的系统全局区1.1358e + 10字节
固定大小2216744字节
可变大小8254393560字节
数据库缓冲区3087007744字节
重做缓冲区13946880字节
SQL >
猜你在找
查看评论
*以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:99999 7次
    • 积分:一万六千零四十九
    • 等级:
    • 排名:319名第
    • 原创:438篇
    • 转载:3篇
    • 译文:2篇
    • 评论:523条
    我的课程
    博客专栏
    技术网址连接
    http://dev.mysql.com/doc/
    文章分类
    文章存档
    最新评论