Showing posts with label Standby databases. Show all posts
Showing posts with label Standby databases. Show all posts
Tuesday, December 6, 2022

SWITCHOVER VERIFY WARNING: switchover target has no standby database defined in LOG_ARCHIVE_DEST_n parameter.

›
When performing a switchover verificaton from your primary database, in your Data Guard setup, you may see the following: sqlplus / as sys...

What is an Oracle snapshot standby database?

›
A snapshot standby database is a fully updatable standby database. Redo data is still received from the primary database, but it is not ap...
Monday, December 5, 2022

How to avoid redo logs and standby redo logs being created as OMF files during a DUPLICATE ... FOR STANDBY operation

›
Recently I had to create a Data Guard physical standby database, and I used RMAN active database duplication ( "duplicate target datab...
Tuesday, May 3, 2022

How to take a standby database out of a data guard configuration and convert it to a standalone read/write database using the Data Guard Broker

›
Deactive the Data Guard Broker configuration: dgmgrl / show configuration # disable log shipping edit database 'stdb' SET STATE=...

The cause for and solution to the error message "Database mount ID mismatch" in your previously configured standby database

›
If you have a previously configured standby database, and you have converted it to a free standing database, no longer a part of a data gu...
Thursday, March 17, 2022

How to solve message from broker Warning: standby redo logs not configured for thread 1 on primary

›
DGMGRL> validate database 'proddb01'; Database Role: Primary database Ready for Switchover: Yes Flashback Database...

How to use active database duplication for creating a physical standby

›
When you use active database duplication for creating a physical standby database, make sure of the following: 1. keep your pfile used to...
Thursday, May 27, 2021

How to fix error message from data guard broker "Property 'DbFileNameConvert' has inconsistent values"

›
After a rebuild of a physical standby database, I was tailing the broker log file drcSALES.log, and noticed the following warning: Proper...
Wednesday, May 12, 2021

How to clear a standby redo logfile and then dropping it

›
During set up of a physical standby database, one of the standby redo logfiles was marked as "ACTIVE" when querying the v$standb...
Friday, January 29, 2021

How to manually register missing logsequences on a standby database

›
I have previously documented how to identify gaps in your standby database's log sequence. See these posts: How to check if your phy...
Thursday, September 3, 2020

Potential solution to dgmgrl error ORA-16665: time out waiting for the result from a member

›
After having added a terminal standby database to an existing configuration, the Data Guard Broker configuration seemed unhappy with commu...
Monday, August 10, 2020

How to set parallelism for a data guard recovery process

›
If you need to manually set the apply-process DOP (Degree of Parallelism), you can do this by setting the property ApplyParallel= num whe...
Tuesday, April 21, 2020

Potential solution to ORA-1033 during configuration of standby database in data guard broker

›
In my environment, the following message was displayed in dgmgrl when trying to configure a data guard environment: DGMGRL> add databa...
Tuesday, March 31, 2020

What is the difference between real-time apply and real-time query?

›
Real-time apply is the process of applying the redo in the current standby redo log file as it is being filled , in contrast to waiting fo...
Thursday, March 12, 2020

Workaround for error Warning: ORA-16714: the value of property LogFileNameConvert is inconsistent with the member setting

›
Error from data guard: oracle@oric-dbserver01:[vegdb01]# dgmgrl / DGMGRL for Linux: Release 18.0.0.0.0 - Production on Thu Mar 12 08:02:5...
Tuesday, December 3, 2019

How an incorrect password file format can stop the redo apply process (MRP0) on standby database

›
Error in dgmgrl shows: DGMGRL> show configuration; Configuration - DGConfig1 Protection Mode: MaxPerformance Members: proddb01...
Thursday, August 22, 2019

How to change location for the redo log files in physical standby database

›
Short background: After a cold restore of the database files from standbyserver1 to standbyserver2, the redo logfiles where incorrectly re...
Thursday, August 8, 2019

How to put a mounted standby database in Real-Time Query mode

›
The database is currently mounted as a normal physical standby database: SQL> select open_mode from v$database; OPEN_MODE ---------...
Wednesday, July 31, 2019

How to check if your physical standby database is applying logs or not

›
For Oracle versions 12.1 and lowe, use V$MANAGED_STANDBY: SELECT CLIENT_PROCESS, PROCESS, THREAD#, SEQUENCE#, STATUS FROM V$MANAGED_STA...
Tuesday, July 30, 2019

How do identify a transport error in a Data Guard setup using the broker

›
Applicable to Oracle 12.2 If the broker has been setup, check the configuration basics: dgmgrl / show configuration; Configuration - DGC...
2 comments: