Dataguard Physical Standby Start / Stop

How to start/stop Dataguard Physical Standby Database

SHUTDOWN
========
status of mrp:
NON-RAC:
select process,status,client_process,thread#,
sequence#,block#,blocks,delay_mins from v$managed_standby;

RAC:

select inst_id,process,status,client_process,thread#,
sequence#,block#,blocks,delay_mins from gv$managed_standby;

cancelling mrp:

recover managed standby database cancel;

shut immediate;

STARTUP
=======
startup nomount;

alter database mount standby database;

STARTING MRP0
=============
If a non-real-time apply standby then issue the following 

SQL statement to start Redo Apply:

alter database recover managed standby database 
disconnect from session;
--OR--
RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM 
SESSION PARALLEL 64;

SQL> 

SELECT open_mode FROM V$DATABASE;

OPEN_MODE
--------------------
MOUNTED

If a real-time apply standby then issue the following

 SQL statement to start Redo Apply:

alter database recover managed standby database using

 current logfile disconnect from session;

SQL> 

SELECT open_mode FROM V$DATABASE;

OPEN_MODE
--------------------
READ ONLY WITH APPLY

Now that the standby is in real-time query mode 

(ie the standby is open in read-only mode and Redo Apply is active).

status of mrp:

NON-RAC:

select process,status,client_process,thread#,sequence#,block#,

blocks,delay_mins from v$managed_standby;

RAC:

select inst_id,process,status,client_process,thread#,sequence#,

block#,blocks,delay_mins from gv$managed_standby;

OPEN_MODE = READ ONLY WITH APPLY
--------------------------------
alter database open readonly;