Oracle, Standby Database

This are the commands that you need to Start and Stop a running Oracle Standby Database in Oracle 11g or 12c

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.
Stop a running Oracle Standby Database
alter database recover managed standby database cancel;
Database altered.
shutdown immediate;
Advertisements

Start and Stop Oracle Standby Database in Oracle 11g / 12c

Aside