How to configuration physical dataguard within an Exadata?

原创 2015年11月21日 13:58:33
Problem Summary 
--------------------------------------------------- 
How to configuration physical dataguard within an Exadata? What needs to be noted? 

Problem Description 
--------------------------------------------------- 
How to configuration physical dataguard within an Exadata? What needs to be noted? 

Error Codes 
--------------------------------------------------- 
Problem Category/Subcategory 
--------------------------------------------------- 

Database Backup/Recovery and RMAN, Duplicate and DataGuard StandBy setup, GDS, OSB/Data Guard (Create Standby, Redo Transport & Apply, Role Changes, Broker, etc)

Solution:

oracle不建议在standby是non-exadata的情况下使用EHCC,具体可以参考下面文档 
http://www.oracle.com/technetwork/database/features/availability/maa-wp-dr-dbm-130065.pdf 
Data Guard Primary using HCC and Standby Database on Third-Party Storage 
除了EHCC外,其他方面不会影响Exadata和Non-Exadata的dataguard组合。 
Regarding your question, please refer to below URL 
http://www.oracle.com/technetwork/database/features/availability/maa-wp-dr-dbm-130065.pdf 
Data Guard Primary using HCC and Standby Database on Third-Party Storage 
...... 
How to check which object uses the HCC? 
Please run the below SQL to query. 
If the results show Query High, Query Low,Archive High and Archive Low, that indicates the object used the EHCC. 
SQL>select s.owner,segment_name,s.bytes/1024/1024 t_size,compress_for 
from dba_segments s,dba_tables t 
where s.owner=t.owner and t.table_name=s.segment_name and compress_for is not null; 

Note: This is INTERNAL ONLY research. No action should be taken by the customer on this information. This is research only, and may NOT be applicable to your specific situation. 

Searched on:Exadata standby hcc 

http://www.oracle.com/technetwork/database/features/availability/maa-wp-dr-dbm-130065.pdf 

For example, an Exadata primary database using HCC can have a standby database deployed on a non-Exadata system that uses SUN ZFS or AXIOM storage (see My Oracle Support Note 413484.1 for limitations to support for heterogeneous Data Guard configurations). 

In a second example where the primary database is on Exadata but HCC is not used, a standby database may be hosted on any third party storage and system (subject to the heterogeneous support limitations defined in My Oracle Support Note 413484.1 ). 

Data Guard Primary using HCC and Standby Database on Third-Party Storage 
...... 


 

版权声明:本文为博主原创文章,未经博主允许不得转载。

How to Setup Active DataGuard on Exadata (Doc ID 1580796.1)

APPLIES TO: Oracle Exadata Storage Server Software - Version 11.2.2.3.5 to 11.2.3.2.1 [Release 11.2...

Exadata to Non-Exadata Active Dataguard Configuration

在以前的文档的基础上修改的,也是直接复制黏贴的,懒得排版了。 注:在里面的某些步骤并没有做。   Exadata to Non-Exadata Active Dataguard Configur...
  • mrluoe
  • mrluoe
  • 2012年08月10日 15:29
  • 1231

Configuring Oracle 11.2.0.3 3-Nodes RAC Primary to 2-Nodes RAC Physical Standby DataGuard on OL

操作环境 Primary Standby Clusterware 11.2.0.3 Grid Infrastructure ...

Layout inflation is the term used within the context of Android to indicate when an XML layout resou

Layout inflation is the term used within the context of Android to indicate when an XML layout resou...
  • xyz_fly
  • xyz_fly
  • 2014年11月17日 16:00
  • 3581

How To…Consume BIData within Yahoo Widgets

  • 2010年11月21日 16:40
  • 1.72MB
  • 下载

How to read/write files within a Linux kernel module?

You should be aware that that you should avoid file I/O when possible. The main idea is to go "one l...
  • fzs333
  • fzs333
  • 2016年01月26日 10:55
  • 717

Oracle 11g Active Data Guard step by step: How to create a Physical Standby Database using RMAN

Database IP DB_UNIQUE_NAME Oracle Net Service Name  Primary 192.168.8.1...

How to create physical standby database with 11g RMAN DUPLICATE FROM ACTIVE DATABASE [ID 747250.1]

How to create physical standby database with 11g RMAN DUPLICATE FROM ACTIVE DATABASE [ID 747250.1] M...

How To Check Whether Physical Standby is in Sync with the Primary or Not?

The following tips will help you in monitoring sync between primary and standby databases. How To C...

How to Add/Drop/Resize Redo Log with Physical Standby in place. [ID 473442.1]

How to Add/Drop/Resize Redo Log with Physical Standby in place. [ID 473442.1] ...
内容举报
返回顶部
收藏助手
不良信息举报
您举报文章:How to configuration physical dataguard within an Exadata?
举报原因:
原因补充:

(最多只允许输入30个字)