Database Switchover was successful but the temporary tablespace got failures, why this issue happen Before proceeding to this process, create the database outage for both the primary and standby databases. Disable all the database jobs in both primary and standby database., check if the database jobs are running or schedules by crontab jobs or any Read More

How to Configure the Data Guard with Cascading Standby Database on Oracle 19C DB Brief about this concept – I would like to configure the data guard with the cascading standby database on Oracle Database 19C. – To perform this we should have configure 1 Primary database, 2 Standby database Flow should be like this Read More

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..