Infrastructure at your Service

Standby Archives - Blog dbi services

Daniel Westermann

How to patch Postgres Plus Advanced Server in a Standby configuration

By | Database Administration & Monitoring | No Comments

In the last post we looked at how you can patch a Postgres Plus Advanced server. Wouldn’t it be nice, in a standby configuration, to patch the standby first without touching the master, then do a controlled switchover and finally patch the old master? In case this is a configuration with EDB Failover Manager the only downtime which would happen is the relocation of the VIP from one node to another (if you use a…

 
Read More
Daniel Westermann

Maintenance scenarios with EDB Failover Manager (3) – Witness node

By | Database Administration & Monitoring | 2 Comments

In the last posts ( Maintenance scenarios with EDB Failover Manager (1) – Standby node , Maintenance scenarios with EDB Failover Manager (2) – Primary node ) we looked at how to perform maintenance operations on the master as well as on the standby node in a failover cluster managed by EDB Failober Manager. What is still open is how to perform maintenance operations on the witness node. So, lets go.  

 
Read More
Daniel Westermann

Maintenance scenarios with EDB Failover Manager (2) – Primary node

By | Database Administration & Monitoring | 4 Comments

In the last post I looked at how you can do maintenance operations on the standby node when you are working in a PostgreSQL cluster protected by EDB Failover Manager. In this post I’ll look on how you can do maintenance on the primary node (better: the node where the primary instance currently runs on). This requires slightly more work and attention. Lets go.  

 
Read More
Franck Pachot

12c Multitenant: PDB spfile parameters for standby database

By | Database Administration & Monitoring | 2 Comments

In multitenant, the spfile parameters at pluggable database level are not stored in the spfile but in the CDB$ROOT table SYS.PDB_SPFILE$ If you open the standby database in read only for reporting, which is one reason to get Active Data Guard option, you may want different optimizer settings suited for reporting. In non-CDB it’s easy: the standby has its own spfile where parameters can be changed. But for a pluggable database, it’s stored in a…

 
Read More
Jérôme Witt

OOW Day 1: Oracle 12c – Data Guard new features

By | Technology Survey | One Comment

What a sunny day at the Oracle OpenWorld in San Francisco, temperatures over 30 degrees Celsius … don’t be jealous ;=) What should I start speaking about? Oracle Entreprise Manager Cloud Control 12c? Oracle VM or Oracle Database 12c? Well, let me summarize some of the Oracle Database 12c Data Guard new features from Joseph Meeks’s session “Oracle Data Guard Zero-Data-Loss Protection at Any Distance”. Oracle Data Guard is a high available, data protection, disaster…

 
Read More
Yann Neuhaus

“ORA-01665: control file is not a standby control file”: what can I do?

By | Database management | One Comment

You have certainly also received this error once in you Oracle DBA career: “ORA-01665: control file is not a standby control file” while trying to create a standby database with RMAN through a full database backup. In fact, the feature itself is not very new. It exists since at least RMAN 10g, it is called the “Restore Failover”. In order to create a Data Guard configuration, you need a standby database on the standby server….

 
Read More
Grégory Steulet

MySQL Data High Availability with semi-synchronous replication

By | Hardware & Storage | No Comments

Starting with MySQL 5.5 it is possible to configure semi-synchronous replication. As you probably know, by default, MySQL replication is asynchronous.  Asynchronous replication means that events/transactions applied on one server are not immediately applied on the other one. In the specific context of MySQL such behavior means that the MySQL Master writes transactions/events to the local binary logs, however it has no idea when the slave(s) will get and process them. Of course such configuration can lead, in case of failover, to some transaction loss since there is no guaranty that the transactions have been transmitted on the standby server(s).

 
Read More