Data Guard switchover taking a lot of time Windows Server 2016

User_9YDUN

Data Guard switchover taking a lot of time Windows Server 2016

I configured Data Guard on two windows 2016 server machines. Now when i perform switchover its taking 30 min for 1 database shut/start if i normally do without DG Broker. If i use DG Broker its takes 35 min approx for whole switchover.

Oracle Database 11.2.0.4 Enterprise Edition (Active Dataguard)

RAM 8GB CPU : 4

SGA 2.5GB

PLease let me know what can be done in this case. I don't see any errors in alert logs or anywhere. PLease help Me.

Thanks

LaserSoft

Hi

Have you configured all pre-requisites like

1. Force logging (Enabled)
2. Standby Redo LOG Groups (REDO LoG Groups + 1)
3. Fal_client and Fal_Server etc..
4. Check alert log files after switchover command what will be the contents. Can you please share contents here.
5. Before switchover, check all the archives log files SYNC'ed with Physical Standby Database (May be you checked, Just check)
6. Make sure this parameter - LOG_ARCHIVE_MAX_PROCESSES - primary and physical standby database to higher / sufficient value.
7. Check the tempfiles between Primary and Physical Standby Database.

Please also check for more details: MOS DOC ID: 1304939.1 (Best Practices Switchover)

My suggestion, please use Data Guard Broker if it is possible for your environment. If it is DG Broker, we can use commands like Validate Database <> before switchover so that we will know the LAG etc.

Thanks

LaserSoft.