Usage Notes for Advanced Redo Transport Settings

简介: Usage Notes for Advanced Redo Transport Settings

The RedoRoutes property has a default value of NULL, which is treated as (LOCAL : ALL) at a primary database.

默认规则是:主库同步日志到所有备库。

The ASYNC redo transport attribute must be explicitly specified for a cascaded destination to enable real-time cascading to that destination.
@开始实时级联备库需要指定ASYNC。
ASYNC = Real-Time Cascading
SYNC = Non Real-Time Cascading

# Real-Time Cascading
DGMGRL> edit database sborcl set property redoroutes='(orcl : orcl03 ASYNC)';
Property "redoroutes" updated
DGMGRL>  show configuration;

Configuration - dg_orcl

  Protection Mode: MaxPerformance
  Members:
  orcl   - Primary database
    sborcl - Physical standby database 
      orcl03 - Physical standby database (receiving current redo)


# Non Real-Time Cascading

DGMGRL> edit database sborcl set property LogXptMode = 'SYNC'; 
Property "logxptmode" updated
DGMGRL> edit database sborcl set property redoroutes='(orcl : orcl03)';
Property "redoroutes" updated
DGMGRL> show configuration;

Configuration - dg_orcl

  Protection Mode: MaxPerformance
  Members:
  orcl   - Primary database
    sborcl - Physical standby database 
      orcl03 - Physical standby database (receiving archived redo)

Fast-Start Failover:  Disabled

Configuration Status:
DISABLED

--Cascaded Standby Databases in Oracle 12c (文档 ID 1542969.1)

A redo routing rule is active if its redo source field specifies the current primary database. If a rule is active, primary database redo is sent by the database at which the rule is defined to each destination specified in the redo destination field of that rule.

The RedoRoutes property cannot be configured such that when a physical standby database is converted to a snapshot standby, the snapshot standby would send redo data to another member.

The RedoRoutes property can be set for a logical standby database only if the redo source field is set to LOCAL

相关文章
|
6月前
|
Oracle 关系型数据库 Linux
Disable NUMA on database servers to improve performance of Linux file system utilities
Disable NUMA on database servers to improve performance of Linux file system utilities
45 3
SAP Fiori application do filtering will real delete note in DB
SAP Fiori application do filtering will real delete note in DB
120 0
SAP Fiori application do filtering will real delete note in DB
|
数据库
Symantec Backup Exec Agent 推送错误Error connecting to the remote computer. Ensure that the computer is available, has WMI enabled and is not blocked by a
如果在Symantec Backup Server上推送Symantec Backup Exec Agent到数据库服务器遇到“"Error connecting to the remote computer. Ensure that the computer is available, has WMI enabled and is not blocked by a firewall"这个错误, 如下截图所示     那么完全可以参考下面官方提供的三个解决方案解决问题,几次碰到这个问题,每次都要搜索一下,特此记录一下,方便以后查找。
1346 0
|
关系型数据库 测试技术 Oracle
[20180102]statistics_level=BASIC.txt
[20180102]statistics_level=BASIC.txt --//一个测试环境不知道谁设置statistics_level=BASIC,导致重启出现错误,自己在测试环境模拟看看: SYS@book> create pfile='/tmp/@.
1249 0