0 Comments

Unable to Add Trandata in Oracle Golden Gate (OGG) 0 (0)

Unable to Add Trandata in Oracle Golden Gate (OGG) In the process of data replication using Oracle GoldenGate (OGG ) the first step and important is assuring that all the needed information and changes have been written to the database redo log files. By default, the database does not write all the information that might […]

 237 Total Views,  4 Views Today

0 Comments

Fixing OGG-05500 Detected Database Metadata Mismatch Between Current Trail File 5 (1)

Fixing OGG-05500 Detected Database Metadata Mismatch Between Current Trail File In this blog we will perform require steps to resolve ERROR OGG-05500 Detected database metadata mismatch between current trail file OGG Setup – Source (Window Server) OGG Setup – Target (Linux Server) Step 1. Replicat Process Abended in Target: As you will notice Replicat RC232 […]

 282 Total Views,  3 Views Today

4 Comments

How to Fix ORA-10458 & ORA-01196 in Standby 11g (Roll Forward a Physical Standby Database) 5 (1)

How to Fix ORA-10458 & ORA-01196 in Standby 11g (Roll Forward a Physical Standby Database) This post presents a quick and efficient alternative to rebuilding a physical standby database in Oracle Database 11g Release 2 by using RMAN incremental backups to roll forward and resynchronize a physical standby database with the primary database or Fix ORA-10458 […]

 210 Total Views,  1 Views Today

0 Comments

Oracle Critical Database Patch IDs for April 2021 5 (1)

Oracle Critical Database Patch IDs for April 2021 An Essential/Critical Patch Update could be a collection of patches for multiple security vulnerabilities. These patches address vulnerabilities in Oracle code and third-party elements enclosed in Oracle merchandise. These patches are sometimes additive, however every informative describes only the protection patches intercalary since the previous essential Patch Update informative. […]

 1,355 Total Views,  15 Views Today

0 Comments

How To Bootstrap MySQL Router For InnoDB Cluster 0 (0)

How To Bootstrap MySQL Router For InnoDB Cluster Bootstrap MySQL Router against an InnoDB Cluster to automatically configure the routing of incoming client connections to mysql instances. To bootstrap MySQL Router at the command-line, pass in the –bootstrap option when you start the mysqlrouter command, and it retrieves the topology information from the metadata and configures routing connections to […]

 415 Total Views,  14 Views Today

0 Comments

Changing InnoDB Cluster Topology in MySQL 0 (0)

Changing InnoDB Cluster Topology in MySQL By default, an InnoDB Cluster runs in single-primary mode, where the cluster has one primary server that accepts read and writes queries (R/W), and all of the remaining instances in the cluster accept only read queries (R/O). When you configure a cluster to run in multi-primary mode, all of […]

 261 Total Views,  1 Views Today

0 Comments

How to Setup MySql InnoDB Cluster 0 (0)

How to Setup MySql InnoDB Cluster MySQL InnoDB Cluster provides a complete high availability solution for MySQL. By using the AdminAPI included with MySql Shell, you can easily configure and administer a group of at least three MySQL server instances to function as an InnoDB Cluster. Each MySQL server instance runs MySQL Group Replication, which […]

 230 Total Views,  4 Views Today

0 Comments

Adopting a Group Replication Deployment into InnoDB Cluster 0 (0)

Adopting a Group Replication Deployment into InnoDB Cluster in MySQL If you have an existing deployment of Group Replication and you want to use it to create a cluster, pass the adoptFromGR option to the dba.createCluster() function. The created InnoDB Cluster matches whether the replication group is running as single-primary or multi-primary. To adopt an […]

 281 Total Views,  2 Views Today

0 Comments

Add & Drop Standby Redolog Files on Standby (Dataguard) in Oracle 0 (0)

Add & Drop Standby Redolog Files on Standby (Dataguard) in Oracle In this article, we are going to demonstrate add & drop standby redolog files on standby (dataguard) in Oracle. Drop or add standby redolog files require in case we resized/recreate redolog in PRIMARY so need to follow same on STANDBY database or some times […]

 443 Total Views,  2 Views Today

0 Comments

How to change Group Replication Mode in MySQL 0 (0)

How to change Group Replication Mode in MySQL In this blog, we will see How to change the mode in which a group is running in, either single or multi-primary. For this we will use two functions group_replication_switch_to_multi_primary_mode() & group_replication_switch_to_single_primary_mode(). These functions used to change a group’s mode can be run on any member. In […]

 369 Total Views,  4 Views Today