Infrastructure at your Service

Tag

Data Guard Archives - Blog dbi services

Mouhamadou Diaw

Oracle Data Guard RedoRoutes : What is Priority 8 ?

By | Database Administration & Monitoring, Oracle | No Comments

When dealing with cascading or far sync in a Data Guard environment, it is important to understand how to configure the RedoRoutes property. By default, a primary database sends redo to each transport destination that is configured in the destination. We can create more complex transport topology, depending of our environment, using the RedoRoutes property. Basically the RedoRoutes property has this format (redo_routing_rule_1) [(redo_routing_rule_n)] Where each routing rule contains a redo source field and a…

Read More
Franck Pachot

Some myths about PostgreSQL vs. Oracle

By | Oracle, Postgres | One Comment

By Franck Pachot . I originally wrote this as a comment on the following post that you may find on internet: https://www.2ndquadrant.com/en/blog/oracle-to-postgresql-reasons-to-migrate/ but my comment was not published (many links in it… I suppose it has been flagged as spam?) so I put it there. You should never take any decision on what you read on the internet without verifying. It is totally valid to consider a move to Open Source databases, but doing it…

Read More
Mouhamadou Diaw

Oracle 20c : Create a Far Sync Instance Is Now Easy

By | Database Administration & Monitoring, Oracle | No Comments

A far sync instance is like a standby instance as it can receive redo from the primary database and can ship that redo to other members of the Data Guard configuration. But unlike a physical standby instance, a far sync instance does not contain any datafiles and then can not be open for access. A far sync instance just manages a controlfile. A far sync instance cannot be converted to a primary instance or any…

Read More
Franck Pachot

티베로 – The AWR-like “Tibero Performance Repository”

By | Database Administration & Monitoring | No Comments

By Franck Pachot . In a previous post I introduced Tibero as The most compatible alternative to Oracle Database. Compatibility is one thing but one day you will want to compare the performance. I’ll not do any benchmark here but show you how you we can look at the performance with TPR – the Tibero Performance Repository – as an equivalent of AWR – the Oracle Automatic Workload Repository. And, as I needed to run…

Read More
Jérôme Dubar

6 things Oracle could do for a better ODA

By | Cloud, Database Administration & Monitoring, Database management, Hardware & Storage, Operation systems, Oracle | No Comments

Introduction With the latest ODA X8 range, at least 80% of the customers could find an ODA configuration that fits their needs. For the others, either they can’t afford it, either they are already in the Cloud, or they need extremely large storage or EXADATA performance. Among these 80% of customers, only a few choose ODA. Let’s see how Oracle could improve the ODA to make it a must. 1) Make robust and reliable releases…

Read More
Mouhamadou Diaw

Oracle 20c Data Guard : Validating a Fast Start Failover Configuration

By | Database Administration & Monitoring, Database management, Oracle | No Comments

In Oracle 20c, we can now validate a Fast Start Failover configuration with the new command VALIDATE FAST_START FAILOVER. This command will help identifying issues in the configuration. I tested this new feature. The Fast Start Failover is configured and the observer is running fine as we can see below. DGMGRL> show configuration verbose Configuration – prod20 Protection Mode: MaxPerformance Members: prod20_site1 – Primary database prod20_site2 – (*) Physical standby database (*) Fast-Start Failover target…

Read More
Mouhamadou Diaw

Oracle 20c : The new PREPARE DATABASE FOR DATA GUARD

By | Database Administration & Monitoring, Database management, Oracle | No Comments

As you may know, Oracle 20c is in the cloud with new features. The one I have tested is the PREPARE DATABASE FOR DATA GUARD. This command configures a database for use as a primary database in a Data Guard broker configuration. Database initialization parameters are set to recommended values. Let’s see what this command will do for us The db_unique_name of the primary database is prod20 and in the Data Guard I will build,…

Read More
Mouhamadou Diaw

Dbvisit Standby 9 : Do you know the new snapshot feature?

By | Database Administration & Monitoring, Oracle | No Comments

Dbvisit snapshot option is a new feature available starting from version 9.0.06. I have tested this option and in this blog I am describing the tasks I have done. The configuration I am using is following dbvist1 : primary server dbvist 2 : standby server orcl : oracle 19c database We suppose that the dbvisit environment is already set and the replication is going fine. See previous blog for setting up dbvisit standby First there…

Read More
Mouhamadou Diaw

Oracle 19C : Dynamic Change of Fast-Start Failover Target

By | Database Administration & Monitoring, Oracle | No Comments

Oracle 19C is now available on premise. There are lot of new features. One for the Data Guard Broker is that now we can dynamically change the fast-start failover target to a specified member in the list without disabling the fast-start failover. I have tested this new feature and is describing this in this blog I am using 3 servers with Oracle Linux The Data Guard is already built and the broker is already configured…

Read More
Oracle Team

Recover a corrupted datafile in your DataGuard environment 11G/12C.

By | Database Administration & Monitoring, Database management, Development & Performance, Oracle | No Comments

On a DG environment, a datafile needs to be recovered on the STANDBY site, in two situations : when is deleted or corrupted. Below, I will explain  how to recover a corrupted datafile, in order to be able to repair the Standby database, without to be necessary to restore entire database. Initial situation : DGMGRL> connect / Connected to “PROD_SITE2” Connected as SYSDG. DGMGRL> show configuration; Configuration – CONFIG1 Protection Mode: MaxPerformance Members: PROD_SITE2 -…

Read More