Converting a Snapshot Standby DB to Physical Standby

Converting a Snapshot Standby database into a Physical Standby Database. Step 1 verify open mode of database (it should be in read write) SQL>select open_mode from v$database; SQL> conn sys/oracle@standby

Converting physical standby DB to snapshot standby

Managing Snapshot standby database in Oracle. In this article we will see step by step procedure to convert physical standby database to snapshot standby database. At Standby database Step 1.

How to setup Data Guard Broker Configuration

DG Broker setup in Oracle Source: DB Version: 19.12.0.0.0 OS : Redhat Linux 7.6   Target : DB Version: 19.12.0.0.0 OD: Oracle Linux 7.9   On Primary ============== ARCHIVE LOG

ORA-16038 TNS-12535 ORA-03135 archiver hung

ORA-16038 TNS-12535 ORA-03135 archiver hung at timeline number. The archiver hung at time/line number due to Possible N/W disconnect with Primary DB. The RFS process on the standby gets the

cksum values for primary & on DR is not matching

Error:cksum values for primary (4119705441) & on DR (3035667210) is not matching. Cksum values for password files between primary & DR site were varying for some databases on the 4node

How to verify DR lag ?

To verify Disaster Recovery lag Connect to DR / standby server select NAME, OPEN_MODE, LOG_MODE, FORCE_LOGGing, DATABASE_ROLE, INSTANCE_name, HOST_NAME, STARTUP_TIME from v$database,v$instance; NAME OPEN_MODE LOG_MODE FOR DATABASE_ROLE INSTANCE_NAME HOST_NAME STARTUP_T———

Step by step procedure for DR exercise (Data Guard)

Step by step procedure for Disaster Recovery exercise (Data Guard) This is all about recovering the databases at Disaster Recovery (DR) site that support the business.Every company that maintains Disaster