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.

Use the command: Replace with your actual listener name (often or a custom name). Stopping the listener ensures that new database connections do not occur during shutdown.

Connect to SQL*Plus and cancel recovery: Output: This command stops Redo Apply , which is necessary before shutting down a standby 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 . Starting the standby database includes: 1️⃣ Start Listener 2️⃣ Startup NOMOUNT 3️⃣ Mount Standby Database 4️⃣ Start Managed Recovery

This allows client and Data Guard broker connections.

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.

Output: The standby is now in mounted mode , ready for Redo Apply.

To begin Redo Apply in the background: Output: ✔ The standby database now resumes synchronization with the primary database.