standby

How to open postgres standby database for read write(snapshot standby)

There is no technical term called snapshot standby in postgres. If you have knowledge of oracle database, then this  snapshot standby method is there in dataguard. I.e you can open the standby databa...

How to do switchover in postgres

In this article we will explain how to do switchover manually . Switchover means, change of role between master and slave. postgres doesn’t provide any inbuilt command to do switchover . We will...

Convert physical standby to snapshot standby using dgmgrl

In our earlier article, we explained how to convert physical standby to snapshot standby manually . Convert Physical standby to snapshot standby manually(Without DGMGRL) However in this article, I wil...

Recover standby database from primary using service in oracle 18c

If your standby database is out of sync from primary or some archive logs got deleted before it is being shipped or applied to standby ,then you can follow below method to sync standby database with p...

edb efm start failed with authentication failed error on standby

PROBLEM: We have rebooted both the primary and standby postgres nodes. After the reboot , the enterprise failover manager(EFM) , was not getting started on the standby node. PRIMARY NODE – 10.20...

Trigger file validation failed. Could not start agent as standby

PROBLEM: I have received below error , while starting efm agent on standby server. [root@dbhost41 edbdata]# systemctl start edb-efm-3.9 Job for edb-efm-3.9.service failed because the control process e...

How to disable enable log shipping in standby using dgmgrl

Sometimes OS team may request for outage on standby database server for maintenance activites. In that we need to stop the log shipping to avoid error in the alert log. Run below commands to disable a...

Oracle dataguard – Interview Questions

1. What is the use of standby redolog? The Advantage of having Standby Redo Logs is that every records written into the Online RedoLogs of the Primary Database is transferred to the Standby database a...

How to add a tempfile in primary database in dataguard

If standby_file_management is set to AUTO, as soon as we add a datafile on primary database, same will be created automatically on standby database. But will the same valid for tempfile?? Answer is NO...

Standby redologs in oracle dataguard

The Advantage of having Standby Redo Logs (SLR) is that every records written into the Online RedoLogs of the Primary Database is transferred to the Standby database and written into the Standby Redo ...