Starting Physical Standby database in mount mode

Starting Physical Standby database in mount mode



SQL>  startup nomount;

ORACLE instance started.

Total System Global Area 2415917880 bytes
Fixed Size                  8899384 bytes
Variable Size             520093696 bytes
Database Buffers         1879048192 bytes
Redo Buffers                7876608 bytes


alter database mount standby database;

Database altered.


alter database recover managed standby database disconnect from session;

Database altered.


select open_mode,name,database_role from v$database;


OPEN_MODE            NAME      DATABASE_ROLE
-------------------- --------- ----------------
MOUNTED              DELHI     PHYSICAL STANDBY


select process,sequence#,status from v$managed_standby;


PROCESS    SEQUENCE# STATUS
--------- ---------- ------------
DGRD               0 ALLOCATED
ARCH               0 CONNECTED
ARCH               0 CONNECTED
ARCH               0 CONNECTED
ARCH               0 CONNECTED
DGRD               0 ALLOCATED
MRP0              34 WAIT_FOR_LOG

Comments