Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 535.8K On-Premises Infrastructure
- 138.1K Analytics Software
- 38.6K Application Development Software
- 5.6K Cloud Platform
- 109.3K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71K Infrastructure Software
- 105.2K Integration
- 41.5K Security Software
Data Guard switchover taking a lot of time Windows Server 2016

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
Answers
-
Hi
Have you configured all pre-requisites like
- Force logging (Enabled)
- Standby Redo LOG Groups (REDO LoG Groups + 1)
- Fal_client and Fal_Server etc..
- Check alert log files after switchover command what will be the contents. Can you please share contents here.
- Before switchover, check all the archives log files SYNC'ed with Physical Standby Database (May be you checked, Just check)
- Make sure this parameter - LOG_ARCHIVE_MAX_PROCESSES - primary and physical standby database to higher / sufficient value.
- 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.