Oracle 参数 ENABLED_PDBS_ON_STANDBY 官方解释,作用,如何配置最优化建议
_SITE
ENABLED_PDBS_ON_STANDBY_SITE参数定义了主备环境中可以激活的pluggable数据库的数量。
在设置ENABLED_PDBS_ON_STANDBY_SITE参数时,需要考虑的几点:
1. ENABLED_PDBS_ON_STANDBY_SITE参数在11g版本及以上才有,而在11g版本以下,必须要在两个实例里分别设置MAX_ENABLED_PDBS参数来控制可以激活的pluggable数据库的数量;
2. 要根据可用的计算资源来设置ENABLED_PDBS_ON_STANDBY_SITE参数,过多的pluggable数据库激活会影响数据库性能及稳定性;
3. 将ENABLED_PDBS_ON_STANDBY_SITE参数设置为1或2比较安全;
4. 能够保证高可用数据库,多设置几个比较安全,但是也要考虑性能及服务器资源;
5. 要特别注意,EMD必须设置成1,这能起到节省资源的作用 来降低数据库的计算资源消耗。
官方英文解释ENABLED_PDBS_ON_STANDBY specifies which pluggable databases (PDBs) to replicate on an Oracle Data Guard standby database.
Note:
This parameter is meaningful only on standby databases. Its settings are ignored on a primary database.
PDB-list accepts a list of PDB names represented by glob patterns such as “PDB?” or “PDB*a”, “PDB2”. The glob pattern rules are like those of UNIX shells. The asterisk (*) and question mark (?) wildcard characters are supported. The ? wildcard character matches exactly one unknown character, and the * wildcard character matches any number of unknown characters. Also, the minus sign (-) character can be used as the first character in a PDB name to indicate that the PDB should be excluded on the standby database.
The following characters are valid in a PDB name: alphanumeric characters, underscore (_), number sign (#), and dollar sign ($). No other characters are valid. Oracle removes double quotation before processing the PDB name. Therefore you cannot use double quotation marks to embed other characters in the name. The PDB name is case insensitive. These are the same naming conventions as for a database name (as described in the DB_NAME initialization parameter description).
These rules apply for the ENABLED_PDBS_ON_STANDBY parameter:
Any PDB names that match glob patterns starting with minus sign (-) will not be part of the standby database.
If a PDB name matches several patterns in the PDB-list at the same time, the rightmost matched pattern has the highest precedence.
If this parameter is not specified in the init.ora file, it is assumed that “*” is specified by default.
If one or more patterns are specified in this parameter, it is assumed that “-*” is implicitly specified in the leftmost position. For example, ENABLED_PDBS_ON_STANDBY=“PDB1”, “PDB2” is equivalent to ENABLED_PDBS_ON_STANDBY=“-*”, “PDB1”, “PDB2”. It means that a PDB name that does not match any patterns is not allowed to be part of the standby.
Examples
These examples assumes that nine new PDBs named PDB1A, PDB1B, PDB1C, PDB2A, PDB2B, PDB2C, PDB3A, PDB3B, and PDB3C are being added to the primary database.
If STANDBY1 sets ENABLED_PDBS_ON_STANDBY=“*” on STANDBY1, then all nine PDBs will be created on STANDBY1.
If STANDBY1 sets ENABLED_PDBS_ON_STANDBY=“PDB1*” on STANDBY1, then PDB1A, PDB1B, and PDB1C will be created on STANDBY1.
If STANDBY1 sets ENABLED_PDBS_ON_STANDBY=“PDB*A” on STANDBY1, then PDB1A, PDB2A, and PDB3A will be created on STANDBY1.
If STANDBY1 sets ENABLED_PDBS_ON_STANDBY=“PDB1*”, “-PDB*A” on STANDBY1, then PDB1B and PDB1C will be created on STANDBY1.
If STANDBY1 sets ENABLED_PDBS_ON_STANDBY=“*”, “-PDB*A”, “-PDB*B” on STANDBY1, then PDB1C, PDB2C and PDB3C will be created on STANDBY1. All other PDBs match “*”, and the rightmost pattern has the higher precedence, so they are excluded on the standby.
If STANDBY1 sets ENABLED_PDBS_ON_STANDBY=“*”, “-PDB*A”, “PDB2A” on STANDBY1, then PDB1A and PDB3A are excluded, but all other PDBs including PDB2A will be created.
我想要获取技术服务或软件
服务范围:MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式:远程服务、电话支持、现场服务,沟通指定方式服务
技术标签:数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题
本站部分文章参考或来源于网络,如有侵权请联系站长。
数据库远程运维 Oracle 参数 ENABLED_PDBS_ON_STANDBY 官方解释,作用,如何配置最优化建议
相关文章
- ORA-16274: failure to perform operation on all Oracle RAC instances ORACLE 报错 故障修复 远程处理
- 支持Oracle官方电话支持:尽在其中!(oracle官方电话)
- 掌握Oracle性能优化技巧:品悟其中变化!(品悟oracle性能优化)
- Oracle 官方授权培训:学以致用(oracle官方授权培训)
- 课程认证北京尚学堂 Oracle 课程官方认证(北京尚学堂oracle)
- Oracle官方在线文档:构建技术知识库(oracle官方在线文档)
- Oracle数据库的触发器类型简介(oracle触发器类型)
- Oracle恢复之路:误删数据的有效恢复方式(oracle恢复误删数据)
- Oracle官方中文版下载—随时随地!(oracle中文官网下载)
- 不够Oracle数据库运行体验分享(oracle长度)
- 掌握Oracle中当前年月日的技巧(oracle当前年月日)
- Oracle官方公布最新产品报价清单,一览众多方案与价格(oracle官方报价)
- 探访Oracle官方认证培训中心,精益求精,成就技能新高度(oracle官方培训机构)
- 深入探究Oracle事务级临时表:提高数据处理效率(oracle事务级临时表)
- Oracle复制行:加快数据入库的速度(oracle 复制行)
- volving on Oracle数据库中的减法操作(oracle减法结果E)
- 轻松搭建Nav连接Oracle数据库(nav连接oracle)
- Oracle数据库中的绑定变量使用指南(oracle中的绑定变量)
- 走上迈向未来的路Oracle云应用程序(oracle云应用程序)
- 解决Oracle乱码问题,快速简便(oracle乱码解决方法)
- Oracle中取消授权的正确方式(oracle 中取消授权)
- Oracle中取出前十名排名简单而强大的实现方式(oracle中取排名前十)
- Oracle数据库双向去重查询(oracle两边去重查询)
- 攀上Oracle专业认证获得成功的利器(oracle专业认证)
- Oracle不更新时还能用吗(oracle不更新能用吗)
- 检查掌握Oracle RAC官方检查指导(oracle rac官方)
- 使用Oracle EM管理档案库,提高效率(oracle em档案库)
- 使用Oracle ADR保护好你的应用探究故障管理之路(oracle adr路径)
- 发布Oracle 12c开启新纪元,官方发布(oracle 12c官方)