Posts Tagged ‘Data Guard’

Oracle Physical Standby Archive Log Gap Resolution

+26 Getting below in Alert log: ——————————————————————————————————- SUCCESS: diskgroup VOL10 was dismounted Media Recovery Waiting for thread 1 sequence 4709 Fetching gap sequence in thread 1, gap sequence 4709-4711 Fri Aug 22 13:00:33 2014 FAL[client]: Failed to request gap sequence  GAP – thread 1 sequence 4709-4711  DBID 238289769 branch 788617304 FAL[client]: All defined FAL servers […]

TAF (Transparent Application Failover) for Data Guard

+29 TAF (Transparent Application Failover) for Data Guard: Below implementation will be continued after DG broker configuration. To know DG broker configuration, go to below link: http://oracledbahub.com/2013/02/dg-broker-configuration/  

ORA-16826: apply service state is inconsistent with the DelayMins property

+15 DGMGRL> show configuration; Configuration – cobra Protection Mode: MaxAvailability   Databases:     cobra    – Primary database     cobradup – (*) Physical standby database       Warning: ORA-16826: apply service state is inconsistent with the DelayMins property

Convert Physical Standby to Snapshot Standby

+20 Snapshot Standby:-  Oracle indroduces Snapshot standby database feature in Datagurad 11g. where one can convert a Physical standby database(Read-Only) to a Snapshot Standby(Read/Write) in READ/WRITE mode and make any DDL/DML operation further and once the Testing purpose is completed, you can resyncronize your database as physical standby back. Convert a Physical Standby to Snapshot Standby with SQL*Plus Check that  Flashback […]

DG Broker Configuration

+22 Data Guard Broker Configuration With failover and Switchover: Setup DG Broker Primary: cobra Standby: cobradup –In below steps above two are used as primary and standby databases. Enable Data Guard Broker Start on the Primary and Standby databases

Manual Failover Physical Standby Database

+14               Steps For Manual Failover to a Physical Standby Database   Pre Checks:   SYS@sharkstd>>>SELECT PROTECTION_MODE,PROTECTION_LEVEL,DATABASE_ROLE ROLE,SWITCHOVER_STATUS FROM V$DATABASE    ;   PROTECTION_MODE              PROTECTION_LEVEL              ROLE                  SWITCHOVER_STATUS ——————–                             ——————–                             —————-                      ——————– MAXIMUM PERFORMANCE    MAXIMUM PERFORMANCE    PHYSICAL STANDBY SESSIONS ACTIVE       Identify […]

PHYSICAL STANDBY DATABASE CREATION THROUGH RMAN ON 10g

+18 Physical Standby Database Creation with RMAN PHYSICAL STANDBY DATABASE CREATION THROUGH RMAN: Prerequisite: 1. Two Servers with same architecture(like Sun sparc/x86 etc.) and same OS version(like solaris 10 etc.) installed. 2. Same oracle software version(like 10.2.0.4.0 etc.) on both servers. 3. create a database on one server for primary purpose. Primary Database: COBRA Standby […]