How to perform the Manual Data Guard Switchover on Oracle 19c Database To perform this data guard switchover operation., You need to planned according to the requirement. In this case., your primary database role will be changed/converted as STANDBY DB., Standby database role will be changed/converted as PRIMARY DB & There is no loss of Read More

Data Guard Physical Standby Setup in Oracle Database 18c SQL> select instance_name,status,version from V$instance; INSTANCE_NAME    STATUS       VERSION ———- ———— —————– ora18c           OPEN         18.0.0.0.0 PRIMARY DATABASE CONFIGURATION Check the archivelog status

Switchover in Realtime Production database in Oracle 11gR2 ================= PRIMARY DATABASE ================= Pre-requisite SQL> select INSTANCE_NAME,VERSION,STATUS from V$instance; INSTANCE_NAME VERSION STATUS —————-… Read more..

Data Guard Broker Configuration (DGMGRL Utility) Data Guard broker configuration using the command line dgmgrl interface,  Below are the step by step procedure tested & verified in our Test ENV Primary Database: PR Standby Database: STD Set the below parameter as on both… Read more..

Perform the Switchover in our Test DB ENV Primary database – IP (10.0.0.1) ===================================== Before Switchover from primary to standby ===================================== SQL> select name,open_mode,database_role from v$database; NAME      OPEN_MODE            DATABASE_ROLE ———… Read more..

Manually Perform Physical standby data Guard Failover steps In case of worst situation with data guard primary database, or not available for production than we can activated standby database as a primary production database. standby Database: Verify… Read more..