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
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
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
--------- ---------- ------------
DGRD 0 ALLOCATED
ARCH 0 CONNECTED
ARCH 0 CONNECTED
ARCH 0 CONNECTED
ARCH 0 CONNECTED
DGRD 0 ALLOCATED
MRP0 34 WAIT_FOR_LOG
Comments
Post a Comment