Steps to Start and Stop Oracle Standby Database

Steps to Start and  Stop Oracle Standby Database

Syntax to Start a Oracle Standby Database

startup nomount;
ORACLE instance started.
Total System Global Area 3206836224 bytes
Fixed Size                  2257520 bytes
Variable Size            1191185808 bytes
Database Buffers         1979711488 bytes
Redo Buffers               33681408 bytes

alter database mount standby database;
Database altered.

alter database recover managed standby database disconnect from session;
Database altered.

Syntax to Stop a running Oracle Standby Database

alter database recover managed standby database cancel;
Database altered.
shut immediate;

The commands will stop the recover process which is identified as the MRP0 process, followed by the “shutdown immediate” – a clean shutdown of the database.