Posts Tagged ‘primary’

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 […]

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 […]