Download Brave : Secure, Fast & Private Browser with Adblocker This post provides help troubleshooting a standby database (dataguard). This article covers the following problems: Troubleshooting Log transport services Troubleshooting Redo Apply services Troubleshooting SQL Apply services Common Problems Log File Destination Failures Handling Logical Standby Database Failures Problems Switching Over to a Standby Database […]
Category: Dataguard
Data guard start/stop restart redo apply
I want to start or stop redo apply without dgbroker. I also want to know other queries to check Dataguard and standby status. These commands are compatible with Oracle 18c, 12c, 11g, 10g, 9i. Starting Redo Apply on standby database The managed recovery can be started as a background or foreground process. FYI :) today, […]
Activation of dgbroker in a Oracle 12c r2 RAC
Activation of dgbroker in a Oracle 12.2 configuration – Primary RAC 2 nodes: servers: PRIMARY-HOST-NODE1 and PRIMARY-HOST-NODE2 database: PRIMARY-DB-UNIQ-NAME1 and PRIMARY-DB-UNIQ-NAME2 – Standby: RAC 1 node server: STANDBY-HOST-NODE1 database: STANDBY-DB-UNIQ-NAME1 (here SID has the same name as primary) Pre-requisites for the dgbroker configuration Network configuration Prepare a dedicated local listener on each node All Data […]
Resize online redo log in a dataguard configuration
One of my clients in Montreal wants to resize the online redologs in a dataguard configuration. The technique used by the Oracle DBA comprises: – On the primary database: drop and re-create the online redologs and the standby online redologs – On the standby database: after stopping the replication, drop and re-create the online redologs […]