While managing Data Guard Standby databases in our environment one of the key responsibility of DBA is End-user connectivity to a proper database or we can say clients connect to the correct database even in case of failover. To know Oracle DataGuard Oracle Dataguard Architecture Your client connectivity should be managed in such a […]
Category: DATAGUARD
Recover Data File in Primary Database in Data Guard Environment
Recovering Data File in Primary Database from the standby database. You have two approaches for data file restoration when your data file gets corrupted or deleted in data guard environment. Restore from RMAN backup Recover it from Standby Database. In our routine, we use the first approach where we simply restore it using RMAN restore command […]
DGMGRL error ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
A common error we face while doing switchover operation using DGMGRL. DGMGRL> switchover to std_testdb; Performing switchover NOW, please wait… Operation requires a connection to instance “testdb” on database “std_testdb” Connecting to instance “testdb”… Connected. New primary database “std_testdb” is opening… Operation requires startup of instance “testdb” on database “testdb” Starting instance “testdb”… Unable to […]
Step by Step Creation of Cascading Standby
Cascading Standby Database works in two layers. As per normal the standby configuration, standby database receives redo from the primary database. In Layer 2 standby database will receive redo from another standby database rather than directly from the primary database. With Cascading standby database we can minimize the load of Primary Database. As per Oracle […]
Creating Fast Incremental Backup
Creating Fast Incremental Backups : We have seen how block change tracking is enabled. Enable block change tracking on the physical standby database The motive of Incremental backup is to backup only those blocks which are changed since the last zero or level 1 incremental backup. Block change tracking provides a boost to this. If […]
Disabling FAST_START Failover
To know about Fast Start Failover in Data Guard To disable Fast_Start failover apply following command : DGMGRL> DISABLE FAST_START FAILOVER; When we perform above command Fast_Start failover is first disabled on target standby database with data guard broker then it is disabled from the primary database. Then these changes are propagated to all standby database […]
Simulating and Restriction After enabling FAST_START failover
Here I am simulating scenario for fast-start failover. Configuring Fast-Start Fail Over Step 1: View fast_start failover is enabled or not. DGMGRL> show configuration; Configuration – drdb Protection Mode: MaxAvailability Databases: testdb – Primary database std_testdb – (*) Physical standby database Fast-Start Failover: ENABLED Configuration Status: SUCCESS Step 2: I am aborting the Simulating and […]
Configuring Fast-Start Fail Over
We have seen overview and prerequisites of fast-start failover in the previous post. Fast Start Failover in Data Guard Steps to configure fast start fail over . Step 1 : Connect to dgmgrl and check the configuration DGMGRL for Linux: Version 11.2.0.4.0 – 64bit Production Copyright (c) 2000, 2009, Oracle. All rights reserved. Welcome to […]
Fast Start Failover in Data Guard
Oracle Data Guard work on two database roles Primary and Standby. In the previous article, we have seen switching the role of Primary and standby database and failover Primary role to Standby database manually. To see Manual Switch Over Manual SwitchOver in Oracle To see Manual Fail Over Manual Failover in Data Guard With Oracle Data Guard […]
DG BROKER Activities Part – II
We have seen SWITCHOVER, FAILOVER and REINSTATE database in the previous article. DG Broker Activities Part – I In this article, we will see changing protection modes with DGMGRL and disabling and removing the configuration. Change protection modes Step 1: Change LOGXPTMODE to suitable option as per Protection mode. DGMGRL> edit database testdb set property […]