- 15 Nov, 2025
- 0 Comments
- 2 Mins Read
How to Start and Stop Oracle Data Guard 19c
How to Start and Stop Oracle Data Guard 19c (Step-by-Step Guide)
Oracle Data Guard is one of the most reliable solutions for data protection, disaster recovery, and high availability. As a DBA, knowing how to properly start and stop the Data Guard (Standby) environment is essential for maintenance, patching, and troubleshooting.
This guide provides a clear and easy-to-follow explanation of how to gracefully stop and start your Oracle 19c Data Guard standby database.
How to Stop the Standby (DR) Database
Stopping the standby database involves three main tasks:
1️⃣ Stop Listener
2️⃣ Cancel Managed Recovery
3️⃣ Shutdown Database
Let’s go through them one by one.
1. Stop the Listener
Use the lsnrctl command:
Replace <listener_name> with your actual listener name (often LISTENER or a custom name).
Stopping the listener ensures that new database connections do not occur during shutdown.
2. Cancel Managed Recovery
Connect to SQL*Plus and cancel recovery:
Output:
This command stops Redo Apply, which is necessary before shutting down a standby database.
3. Shutdown the Database
Run the shutdown command:
Expected output:
✔ These messages simply mean the standby database was not open (normal for standby) and has been cleanly shut down.
How to Start the Standby (DR) Database
Starting the standby database includes:
1️⃣ Start Listener
2️⃣ Startup NOMOUNT
3️⃣ Mount Standby Database
4️⃣ Start Managed Recovery
1. Start the Listener
This allows client and Data Guard broker connections.
2. Start the Database in NOMOUNT Stage
You may see warnings like:
This is normal and usually not an issue.
At this stage, the instance starts and memory structures (SGA/PGA) are allocated.
3. Mount the Standby Database
Output:
The standby is now in mounted mode, ready for Redo Apply.
4. Start Managed Recovery
To begin Redo Apply in the background:
Output:
✔ The standby database now resumes synchronization with the primary database.
Conclusion
Managing Oracle Data Guard requires careful execution of start/stop procedures to maintain synchronization and avoid errors. Following these steps ensures a clean and controlled shutdown or startup of your standby environment.
Whether you are performing maintenance, patching, or troubleshooting, this guide helps you operate Data Guard with confidence.
Thanks for reading. Now it’s time to turn this knowledge into action. Happy learning and see you in class or in the next blog!
Want to see how we teach?
Head over to our YouTube channel for insights, tutorials, and tech breakdowns:
www.youtube.com/@learnomate
To know more about our courses, offerings, and team:
Visit our official website: www.learnomate.org
Interested in mastering Oracle Database Administration?
Check out our comprehensive Oracle DBA Training program here: https://learnomate.org/oracle-dba-training/
Want to explore more tech topics?
Check out our detailed blog posts here: https://learnomate.org/blogs/
And hey, I’d love to stay connected with you personally!
Let’s connect on LinkedIn: Ankush Thavali 😎
Happy Vibes!
ANKUSH