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

相关文章
|
2月前
|
SQL Java Maven
flywa报错Migration checksum mismatch for migration version 1.1 -> Applied to database : 1332862643 ->
flywa报错Migration checksum mismatch for migration version 1.1 -> Applied to database : 1332862643 ->
38 1
|
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
AS 3.6 之前和之后No cached version available for offline mode 解决方法
AS 3.6 之前和之后No cached version available for offline mode 解决方法
139 0
AS 3.6 之前和之后No cached version available for offline mode 解决方法
PAT (Advanced Level) Practice:1~3题
​ ✨欢迎您的订阅✨ PAT乙级专栏(更新完毕): 👉🏻【Basic Level】👈🏻 PAT甲级专栏(更新ing): 👉🏻【Advanced Level】👈🏻 ​
PAT (Advanced Level) Practice:1~3题
|
SQL Oracle 关系型数据库
Troubleshooting: Missing Automatic Workload Repository (AWR) Snapshots and Other Collection Issues (Doc ID 1301503.1)
Troubleshooting: Missing Automatic Workload Repository (AWR) Snapshots and Other Collection Issues (Doc ID 1301503.1)
751 0
|
Oracle 关系型数据库
Mandatory Patching Requirement for Database Versions 11.2.0.3 or Earlier, Using DB Links (DOC ID 2335265.1)
Mandatory Patching Requirement for Database Versions 11.2.0.3 or Earlier, Using DB Links (DOC ID 2335265.
2806 0
|
关系型数据库 测试技术 Oracle
[20180102]statistics_level=BASIC.txt
[20180102]statistics_level=BASIC.txt --//一个测试环境不知道谁设置statistics_level=BASIC,导致重启出现错误,自己在测试环境模拟看看: SYS@book> create pfile='/tmp/@.
1250 0