How to configuration physical dataguard within an Exadata?

来源:互联网 发布:淘宝返利网哪个最好 编辑:程序博客网 时间:2024/05/14 19:23
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 
...... 


 

0 0