Re-start Active Dataguard

RE-Enable log apply service (By restarting Guard)

[sysdba@dataguard:stbydb-/cluster/home/oracle]$ sid

SIDs on this node:

  +ASM

  stbydb

ORACLE_SID = [stbydb] ?

The Oracle base remains unchanged with value /cluster/app/grid

ORACLE_SID=stbydb

ORACLE_HOME=/cluster/app/grid/product/11.2.0/db_1

[sysdba@dataguard:stbydb-/cluster/home/oracle]$ hems

SQL*Plus: Release 11.2.0.2.0 Production on Fri Dec 14 11:40:29 2012

Copyright (c) 1982, 2010, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SYS@stbydb >>  alter database recover managed standby database cancel;

Database altered.

SYS@stbydb >> shutdown immediate;

ORA-01013: user requested cancel of current operation

SYS@stbydb >> shutdown abort;

ORACLE instance shut down.

SYS@stbydb >> startup mount;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 5.3848E+10 bytes

Fixed Size                  2239232 bytes

Variable Size            2.5904E+10 bytes

Database Buffers         2.7783E+10 bytes

Redo Buffers              158928896 bytes

Database mounted.

SYS@stbydb >> alter database open read only;

Database altered.

SYS@stbydb >> select open_mode from v$database;

OPEN_MODE

--------------------

READ ONLY

SYS@stbydb >> alter database recover managed standby database using current logfile disconnect;

Database altered.

SYS@stbydb >>