Dataguard: Copy of primary database used mainly for disaster recovery. There are two types of dataguard
- Physical dataguard: Physically identical to primary database on a block-block basis.
- Logical dataguard: Same logical data as primary; physical organization and structure can be different.
Streams: Propagates data and events from one database to another or within same database
GoldenGate: Capture, transform, and deliver data. Supports heterogeneous databases.
RAC: Real Application Clusters is cluster database with shared cache architecture to overcome the limitations of traditional shared-nothing and shared-disk. In simple terms, it is multiple instances of Oracle sharing the same database. To avoid confusion, please note an instance is defined as of SGA and Oracle background process.
|-Data Replication-Data Sharing||-Data Replication
-Must be same
|-Can be Different||-Can be Different||-Must be same|
|Heterogeneous DB Support||
|Replicate Data Subset||
-Yes (Logical Only)
|Near Zero Upgrade||
**Platform: Depending on definition of platform, they can be different. For example P550 can be used instead of P560 for Dataguard