12.1,DataGuard,配置,DGMGRL,遇到,OR
数据库-mysql教程
wms仓储管理系统 源码,安装ubuntu 保留分区,tomcat配置局域网,py爬虫实战,php开发适合女生吗,SEO slzw
为12.1.0.2 DataGuard配置DGMGRL时遇到了ORA-16698错误： BANNER CON_ID—————————————————————————————— ———-Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Produ微募捐源码,vscode 脚本,ubuntu opt目录,tomcat 包,sqlite驱动qt,在dns服务器中添加mx记录,jquery 实时编辑插件,2017前端布局框架,python 爬虫 论文,php课程设计报告,网站公司seo,网站源代码 格式,手机网页禁止旋转,苹果模板,简单页面加载等待动画,php客户管理系统 下载,b2b程序源码lzw
小说网站 源码,ubuntu盘无法安装,爬虫认识主人的,php ${},陈枫seolzw
为12.1.0.2 DataGuard配置DGMGRL时遇到了ORA-16698错误：BANNER CON_ID------------------------------------------------------------------------------------------ ----------Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0PL/SQL Release 12.1.0.2.0 - Production 0CORE 12.1.0.2.0 Production 0TNS for Linux: Version 12.1.0.2.0 - Production 0NLSRTL Version 12.1.0.2.0 - Production 0DGMGRL> DGMGRL> [oracle@PD009 ~]$ oerr ora 1669816698, 0000, "LOG_ARCHIVE_DEST_n parameter set for object to be added"// *Cause: One or more LOG_ARCHIVE_DEST_n initialization parameters that// contain a SERVICE attribute but not the NOREGISTER attribute were// set when attempting to create a configuration or add a standby or// far sync instance to the configuration. askmaclean.com// *Action: If creating a configuration, clear all LOG_ARCHIVE_DEST_n// initialization parameters that contain a SERVICE attribute but not// the NOREGISTER attribute. If adding a standby database or far sync// instance, clear the LOG_ARCHIVE_DEST_n initialization parameter// that specifies the database or far sync instance to be added.
这个错误可以通过在Primary 和 Standby上取消log_archive_dest_n参数来解决，实际这一块的参数应当是交给DG broker 来管理了，不再需要人为介入设置。
primary:SQL> alter system reset log_archive_dest_2 scope=spfile sid='*';System altered.SQL> alter system reset log_archive_dest_1 scope=spfile sid='*';System altered.SQL> startup force;ORACLE instance started.standby:SQL> alter system reset log_archive_dest_2 scope=spfile sid='*';System altered.SQL> alter system reset log_archive_dest_1 scope=spfile sid='*';System altered.重启primary和standby实例[oracle@PD009 ~]$ dgmgrl sys/oracle@PDPRODDGMGRL for Linux: Version 12.1.0.2.0 - 64bit ProductionCopyright (c) 2000, 2013, Oracle. All rights reserved.Welcome to DGMGRL, type "help" for information.Connected as SYSDBA.DGMGRL> create CONFIGURATION PDPROD as primary database is PDPROD CONNECT IDENTIFIER IS PDPROD;Configuration "pdprod" created with primary database "pdprod"add database PDSTBY as CONNECT IDENTIFIER IS PDSTBY MAINTAINED AS PHYSICAL;Database "pdstby" addedConnected as SYSDBA.DGMGRL> enable configuration;Enabled.DGMGRL> DGMGRL> show configuration;Configuration - pdprod Protection Mode: MaxPerformance Members: pdprod - Primary database pdstby - Physical standby database Fast-Start Failover: DISABLEDConfiguration Status:SUCCESS (status updated 5 seconds ago)
Related posts:
Recreate failovered primary database using Flashback Database
Duplicate standby database from active database
解决DGMGRL Unable to connect to database ORA-12541: TNS:no listener问题
11gR2新特性:STANDBY_MAX_DATA_DELAY
关于参数log_file_name_convert
如何重置Exadata cell上的flash cache的内容
11gR2游标共享新特性带来的一些问题以及_cursor_features_enabled、_cursor_obsolete_threshold和106001 event
DataGuard与异构平台
如何绕过ORA-00701错误和降低bootstrap对象的高水位
_shared_pool_reserved_pct or shared_pool_reserved_size with ASMM
原文地址：为12.1 DataGuard配置DGMGRL遇到ORA-16698, 感谢原作者分享。