Can you use Active Data Guard effectively between an Oracle Exadata Database Machine and a
standard database server?
A.
Yes, but only If you use Hybrid Columnar Compression.
B.
Yes, but tables or paritions that use Hybrid Columnar Compression will not be immediately
accessible.
C.
Yes, but only if you do not allow Smart Scans with the Oracle Exadata Database Machine.
D.
No.
Explanation:
The HCC (Hybrid Columnar Compression) compressed columns get actualized on the Standby by
Redo Apply – they cannot be accessed by select statements, though. This will compromise the
Availability of these tables in case of a failover accordingly – you probably should not go with that
strategy
https://uhesse.wordpress.com/2011/01/21/exadata-part-iii-compression/