ORACLE GG VS ORACLE DR

-

 ORACLE GG VS DATAGAURD 


Query offloading - ORACLE GG(supported) DATAGAURD (supported)

High availability - ORACLE GG(supported) DATAGAURD (supported)

Unidirection ful replication - ORACLE GG(supported) DATAGAURD (supported)

Heterogenious replication - ORACLE GG (supported ) DATAGAURD (not supported)

Data transformation - ORACLE GG  (supported) DATAGAURD (not supported)

Set of data for replication - ORACLE  GG (supported) DATAGAURD (not supported)

Bidirectional replication - ORACLE GG  (supported) DATAGAURD (not supported)

Alter database and alter system  -  ORACLE GG (not supported) DATAGAURD (supported) - (Whatever the sys user is doing everything capture by DG)

Comments

Post a Comment

Popular posts from this blog

RAC NOTES

-
================================== Oracle Clusterware Startup Process : =================================== 1.File Read Order: - OLR (Oracle Local Registry) - VD (Voting Disk) - OCR (Oracle Cluster Registry) 2.Process Start Order: - OHASD (Oracle High Availability Services Daemon) - Main Wrapper script (etc/inittab) , OLR  - CSSD (Cluster Synchronization Services Daemon) - Main  Voting disk - GPNP profile - KFED/KFOD - CRSD (Cluster Ready Services Daemon)  - Main look for OCR and GPNP profile  Since Oracle 11g Release 2, the ASM spfile (Automatic Storage Management Server Parameter File) is automatically stored in the first disk group created during Grid Infrastructure installation. However, because the Voting Disk and OCR are stored in ASM, ASM must be started for Clusterware to function. This creates a challenge: how do you start ASM if its spfile is also stored on an ASM disk group? Clusterware Startup Sequence and Resolution: =====================================...
Read more

ORACLE CLOUD INFRASTRUCTURE

-
OCI : ======= Oracle Cloud Infrastructure (OCI) is Oracle's cloud computing platform that provides a wide range of cloud services, including computing, storage, networking, databases, and security. It is designed for running enterprise workloads with high performance, security, and reliability. OCI Service Models OCI offers services across three major cloud models: 1)Infrastructure as a Service (IaaS) ------------------------------------- Provides fundamental cloud resources like compute, storage, and networking. Examples: Compute (Bare Metal, Virtual Machines, GPUs) Block, File & Object Storage Networking (Load Balancers, VPN, FastConnect) Oracle Cloud VMware Solution Dedicated Bare Metal Servers 2)Platform as a Service (PaaS) : ------------------------------- Provides managed services for databases, application development, and AI/ML without managing underlying infrastructure. Examples: Oracle Autonomous Database (Self-driving, self-securing, and self-repairing DB) Oracle Dat...
Read more

DATAPUMP (export import) IN ORACLE

-
----------------------------------- EXPDP (Data Pump Export) Parameters : ------------------------------------ Parameter       Description                                                   Example DIRECTORY   Specifies the directory object where dump files are written. DIRECTORY=DATA_PUMP_DIR DUMPFILE   Specifies the name(s) of the dump file(s).                  DUMPFILE=expdp_dump_%U.dmp (for parallel) LOGFILE       Specifies the name of the log file.                          LOGFILE=expdp.log SCHEMAS       Exports one or more schemas.                                  SCHEMAS=HR,SCOTT TABLES ...
Read more