11gR2 RAC-Dataguard Sync issue Between Primary & Standby

Posted by Sagar Patil

I have a 2 node RAC -DG setup between 2 remote data centres. After building DataGuard between them I am now coming across stange latency stats. Read more…

DataGuard Monitorable (Read-Only) Database Properties

Posted by Sagar Patil
Configuration details below are for a 2 Node RAC as Primary (PROD1,PROD2) & 2 node RAC(STDBY1,STDBY2) as Physical Standby.

Read more…

How to Safely Remove a Data Guard Broker Configuration under RAC/NON-RAC setup

Posted by Sagar Patil

1) Remove the Data Guard Broker Configuration

Using the Commandline DGMGRL
SQL> show parameter dg_broker;
NAME                                 TYPE        VALUE
———————————— ———– ——————————
dg_broker_config_file1               string      /mnt/data/oradata/PROD/dr1PROD.dat
dg_broker_config_file2               string      /mnt/data/oradata/PROD/dr2PROD.dat
dg_broker_start                      boolean     TRUE

Read more…

Script to Collect Data Guard Physical Standby Diagnostic Information [ID 241438.1]

Posted by Sagar Patil

I generally don’t cut and paste metalink notes. But in case you are using DG , for diagnosis you will have to use 2 metalink scripts, [ID 241438.1] & [ID 241374.1] Read more…

Script to Collect Data Guard Primary Site Diagnostic Information [ID 241374.1]

Posted by Sagar Patil

I generally don’t cut and paste metalink notes. But in case you are using DG , for diagnosis you will have to use 2 metalink scripts, [ID 241438.1] & [ID 241374.1] Read more…

11g RAC | Using Duplicate target database 11g Active Database option

Posted by Sagar Patil

I have a 2 Node RAC Standby database (STDBY) . I need to replicate it as a Load TEST database (LDTEST) in a read/write mode.

Read more…

11g |Monitoring DataGuard using Broker Commands

Posted by Sagar Patil

DGMGRL> show database PROD;
Object “prod” was not found

** 11.2.0.2 – You may see errors at dgmgrl if you don’t include database name in quotes

Read more…

Dataguard: Recovering lost broker configuration files: Clear Old Configuration & Add New One

Posted by Sagar Patil

I had a working datagard configuration between 1 primary and 2 physical standby systems. Today I noticed my dataguard configuration files were missing from all servers (Primary/Standby).

Read more…

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor at Dataguard Switchover

Posted by Sagar Patil

Read more…

Dataguard : Activating Standby (Failover) when Primary is Down

Posted by Sagar Patil

In this post, I will show you how easy it is to fail-over on standby dataguard database when primary is not available. Read more…

Dataguard : ORA-16826 apply service state is inconsistent when changing mode to MaxProtection

Posted by Sagar Patil

This morning I moved my Standby database from Maxperformance to Maxprotection while it returned ORA-16826
Read more…

Dataguard : EDIT CONFIGURATION (Change Protection Mode)

Posted by Sagar Patil

Following post will give you an idea on Dataguard data protection mode in which you want configuration to run when configuration is enabled. The possible protection modes are: Read more…

Summary of DGMGRL Commands with Example

Posted by Sagar Patil


Command Effect
ADD DATABASE Adds a new standby database profile to the existing broker configuration  Read more…

DGMGRL : ORA-16789: standby redo logs not configured/ORA-16826: apply service state is inconsistent with the DelayMins property

Posted by Sagar Patil

My DGMGRL configuration is returning warnings as below.

DGMGRL> show database primary;
Database – primary
Role:            PRIMARY
Intended State:  TRANSPORT-ON
Instance(s):
primary
Database Warning(s):
ORA-16789: standby redo logs not configured

Read more…

Creating Oracle Dataguard Primary/Standby DB on a Single PC

Posted by Sagar Patil

Generally you don’t have to set up Dataguard on a single machine. But there are occasions when you have to build test environment for destruction and this post is tuned for such opportunity.

Read more…

Dataguard : Applying CPU(Cirital Patch Update) to Dataguard Environment

Posted by Sagar Patil

I have One Primary database and 2 Physical Standby Databases under RHEL 5. Here is a process to patch them with JULY CPU update “Critical Patch Update Release 10.2.0.4 for UNIX Released July 13, 2010″

Read more…

Dataguard: Shell script to List Archive gap between Primary & Standby

Posted by Sagar Patil

I was looking for a NAGIOS monitoring script which will list the archive gap between Primary and 2 of my Standby databases.

Read more…

Script to Auto Start Primary/Standby Database under Linux

Posted by Sagar Patil

The following represents the Oracle recommended method for automating database startup and shutdown of Oracle 10g instances.

Read more…

Views Relevant to Oracle Data Guard

Posted by Sagar Patil
LOGICAL DBA_LOGSTDBY_EVENTS Contains information about the activity of the logical standby database system. It can be used to determine the cause of failures that occur when SQL Apply is applying redo to logical standby databases.
LOGICAL DBA_LOGSTDBY_LOG Shows the log files registered for logical standby databases.
LOGICAL DBA_LOGSTDBY_NOT_UNIQUE Identifies tables that have no primary and no non-null unique indexes.
LOGICAL DBA_LOGSTDBY_PARAMETERS Contains the list of parameters used by SQL apply.
LOGICAL DBA_LOGSTDBY_PROGRESS Describes the progress of SQL Apply on the logical standby database.
LOGICAL DBA_LOGSTDBY_SKIP Lists the tables that will be skipped by SQL Apply.
LOGICAL DBA_LOGSTDBY_SKIP_TRANSACTION Lists the skip settings chosen.
  DBA_LOGSTDBY_UNSUPPORTED Identifies the schemas and tables (and columns in those tables) that contain unsupported datatypes. Use this view when you are preparing to create a logical standby database.
PHYSICAL/LOGICAL V$ARCHIVE_DEST Read more…

Manually resolve archive log gap/ Recover Standby / Manual Standby recovery

Posted by Sagar Patil

The primary and standby database have the same filesystem layout, i.e. archive redo is at same place on both servers. Read more…

How to Recover Standby from Primary Database

Posted by Sagar Patil

– Server A – Is a Live Server
– Server B – Is a Physical Standby Server
Both were configured for a data guard

Read more…

Oracle Standby Recovery Rate Monitoring

Posted by Sagar Patil

Why standby periodically lags during the day?
The script reports the time it took to apply the log, the size of the log, and the redo apply rate for that log.

Read more…

Creating Data Guard Primary/Standby on 2 Windows Servers

Posted by Sagar Patil

Oracle Data Guard is the management, monitoring, and automation software infrastructure that creates, maintains, and monitors one or more standby databases to protect enterprise data from failures, disasters, errors, and corruptions.

Read more…

Switchover from primary to standby/ Switchover Primary : No Dgmgrl

Posted by Sagar Patil

This process will reverse database roles in a Data Guard setup, i.e. standby database becomes primary.

Read more…

Top of Page

Top menu