Re: Dataguard Exadata -> Database Appliance

Amrit,
EHCC Decompression can be forced with alter table move . As long as you as physical Standby it is not of relevance . Once you need it read write . you will need to follow the steps in the WP below.

http://www.oracle.com/technetwork/database/features/availability/maa-wp-dr-dbm-130065.pdf discusses HCC decompression on non exadata systems .




________________________________
 From: Amrit Pal. Singh [IT Shared Services – Hub] <singha_at_mtn.co.ug>
To: "Chris.Stephens_at_adm.com" <Chris.Stephens_at_adm.com>; "'oracle-l_at_freelists.org'" <oracle-l@freelists.org> 
Sent: Tuesday, April 15, 2014 10:19 AM
Subject: RE: Dataguard Exadata -> Database Appliance
 


Hi
 
We have a DR on exa to exa setup.
I think there will be issues if you have EHCC (Exadata Hybrid Columnar Compression) is enabled on source machine.
Normal storage will not understand those blocks once you restore those using rman. There are certain storages available by Oracle which understands EHCC but not the regular ones.
 
So if you are not using EHCC; I don’t see any challenge.. but with EHCC I don’t think it will go.
 
Thanks
amrit
 
From:oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Stephens, Chris
Sent: Tuesday, April 15, 2014 6:09 PM
To: 'oracle-l_at_freelists.org'
Subject: Dataguard Exadata -> Database Appliance
 
I was just asked by management whether it would be possible to run Dataguard from Exadata (Primary) to a Database Appliance (Standby).  I can’t think of a reason why that wouldn’t be possible.
 
I’m not sure that’s the question they are actually asking though which is:  Would it be justifiable for us to save some money and run our standby on cheaper hardware (and consequently software licensing)?
 
I don’t think processing power differences will be a problem for quite some time.  The biggest drawback I can think of is that all of a sudden you have to keep OS/GI (running RAC)/RDBMS versions and patching at the same level.
 
What else am I not thinking of?  …how bad of an idea is it?
 
I would have even really considered it as a possibility but then I don’t pay the bills or have to justify them either.
 
Thanks for any help with this.
 
Chris
 
CONFIDENTIALITY NOTICE:
This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient
 or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error,
 please notify us immediately by email reply.

 
________________________________
 NOTE: This e-mail message is subject to the MTN Group disclaimer see http://www.mtn.co.ug/email/Email-disclaimer.aspx

--
http://www.freelists.org/webpage/oracle-l