Enable Active Guard with DG Broker (11.2.0.2).

We a have new created standby and we need to make it active to utilized its resources.

current configuration

 
DGMGRL> show configuration;

Configuration - FITS

  Protection Mode: MaxPerformance
  Databases:
    FITS     - Primary database
    FITSDG   - Physical standby database
    FITSdg02 - Physical standby database <<< --- enable active guard. 
Fast-Start Failover: DISABLED 
Configuration Status: 
SUCCESS 

DGMGRL>


check detail of the standby database.

 
DGMGRL> show database FITSdg02;

Database - FITSdg02

  Role:            PHYSICAL STANDBY
  Intended State: APPLY-ON
  Transport Lag:   0 seconds
  Apply Lag:       0 seconds
  Real Time Query: OFF
  Instance(s):
    FITSDG02

Database Status:
SUCCESS
 

SQL> select open_mode from v$database;

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

Stop the log apply on the standby using dgmgrl

 
DGMGRL> edit database FITSdg02 set state='APPLY-OFF';
Succeeded.

DGMGRL> show database FITSdg02;

Database - FITSdg02

  Role:            PHYSICAL STANDBY
  Intended State: APPLY-OFF
  Transport Lag:   0 seconds
  Apply Lag:       18 seconds
  Real Time Query: OFF
  Instance(s):
    FITSDG02

Database Status:
SUCCESS

DGMGRL>

on the alert log of the standby

 
Wed Feb 08 20:28:35 2012
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL
Wed Feb 08 20:28:35 2012
MRP0: Background Media Recovery cancelled with status 16037
Errors in file /opt/app/oracle/diag/rdbms/FITSdg02/FITSDG02/trace/FITSDG02_pr00_9883.trc:
ORA-16037: user requested cancel of managed recovery operation
Managed Standby Recovery not using Real Time Apply
Recovery interrupted!
Recovered data files to a consistent state at change 316507777323
Wed Feb 08 20:28:36 2012
MRP0: Background Media Recovery process shutdown (FITSDG02)
Managed Standby Recovery Canceled (FITSDG02)
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL

Open the standby database instances in read only mode using sql plus

 
SQL> alter database open read only;

Database altered.

Start the redo apply service again using dgmgrl

 
DGMGRL> edit database FITSdg02 set state='APPLY-ON';
Succeeded.

DGMGRL> show database FITSdg02;

Database - FITSdg02

  Role:            PHYSICAL STANDBY
  Intended State: APPLY-ON
  Transport Lag:   0 seconds
  Apply Lag:       0 seconds
  Real Time Query: ON
  Instance(s):
    FITSDG02

Database Status:
SUCCESS
 
SQL> select open_mode from v$database;

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

when you encounter error related to tempfile like below… just drop and recreate your tempfiles.

 
ERROR:
ORA-01187: cannot read from file  because it failed verification tests
ORA-01110: data file 201: '/dbGTNIP/db04/oradata/FITSDG02/temp01.dbf'

check all your tempfile

 
SQL> select file#,status,name from v$tempfile;

     FILE# Status    Tablespace Name
---------- --------- ----------------------
         1 ONLINE    /dbGTNIP/db04/oradata/FITSDG02/temp01.dbf
         2 ONLINE    /dbGTNIP/db04/oradata/FITSDG02/temp02.dbf

Drop and recreate your tempfiles.

 
SQL> alter database tempfile '/dbGTNIP/db04/oradata/FITSDG02/temp01.dbf' drop;

Database altered.

SQL>  alter database tempfile '/dbGTNIP/db04/oradata/FITSDG02/temp02.dbf' drop; 
Database altered.

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/dbGTNIP/db04/oradata/FITSDG02/temp01.dbf' REUSE;

Tablespace altered.

SQL> ALTER TABLESPACE TEMP ADD TEMPFILE '/dbGTNIP/db04/oradata/FITSDG02/temp02.dbf' REUSE;

Tablespace altered.

thanks for visiting my blog

Advertisements

3 thoughts on “Enable Active Guard with DG Broker (11.2.0.2).

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s