Showing posts with label Oracle Data Guard. Show all posts
Showing posts with label Oracle Data Guard. Show all posts

Tuesday, 27 June 2017

Oracle Active Database Duplication (using RMAN): ORA-00201: control file version incompatible Oracle 11.2.0.4


During active database duplication for standby database creation I faced below error, which is related to compatible on 11.2.0.4 on RHEL-6.5 x64.


Error :


ORA-00201: control file version 11.2.0.4.0 incompatible with ORACLE version 11.2.0.0.0


Thursday, 1 June 2017

Step-By-Step Configuration Of Data Guard Broker in Oracle 11g


 Here we will configure the data Guard Broker . Here are the steps :




Primary Databse   =  Prod
Standby Database =  
Prodstd

Step 1 :  Check the Data Guard Broker process 
SQL>
 sho parameter dg_broker
NAME                                   TYPE             VALUE
-----------------                    ----------          ----------
dg_broker_start                boolean          FALSE

Step 2  : Start the Data Guard Broker Process on Primary database   
SQL>
alter system set dg_broker_start=true scope=both;
System altered.

Step 3 : Check DG_BROKER on standby database and start it 
SQL>
 sho parameter dg_broker
NAME                                    TYPE             VALUE
-----------------                      ----------         ----------
dg_broker_start                  boolean         FALSE

SQL>
alter system set dg_broker_start=true scope=both ;
System altered.

Sunday, 21 February 2016

Data Guard Standby Archive Destination Full

You notice the following error in the alert.log of the Data Guard Standby database. Your Standby is configured to write its archive logs to the Fast Recovery Area.

Saturday, 20 February 2016

Steps to configure Oracle 11g Data Guard Physical Standby – Data Guard

Here in this article I am going to cover steps by step approach to configure Oracle 11g Data Guard Physical Standby.

In my case, Ingredients to simulate Physical Standby data guard environment are as below:

Building A Single Instance Physical Standby For A RAC Primary…Or..Active Dataguard

Today we are going to embark on the adventure of building an Active DataGuard database (the “standby”) with a two-node RAC as the source (the “primary”).

Error 1031 received logging on to the standby

ISSUE

Error 1031 received logging on to the standby
ORA-01031: insufficient privileges
PING[ARC0]: Heartbeat failed to connect to standby 'dgp'. Error is 1031.

Setting up Oracle 12c Active Data Guard Database

Prerequisites for Oracle 12c Active Data Guard Database

In this article we will set up an Active Data Guard for a CDB named “CDB12C” using RMAN duplicate. This article assumes that database binaries are installed on Standby host.The very first step is to turn force logging on the Primary database.

How to Failover Database with flashback using Dataguard

How to Failover Database with flashback using Dataguard
Scenario: This failover will not apply the changes on Standby back to primary
Step 1: On Primary – Stop Log Shipping
Defer the log shipping to standby.
SQL> Alter system set log_archive_dest_state_n=defer;
Check last log sequence

Thursday, 18 February 2016

12c Dataguard : Recover from Service

Rolling Forward a Physical Standby Database Using the RECOVER Command

A standby database is a transactionally-consistent copy of the production database. It enables production Oracle database to survive disasters and data corruption. If the production database becomes unavailable because of a planned or an unplanned outage,

Oracle Data Guard

Oracle Data Guard is one of the most effective and comprehensive data availability, data protection and disaster recovery solutions available today for enterprise data.
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.