Monday, September 1, 2014


DATE :-- 1st SEP 2014


                                          DATA GUARD BROKER :-- ORA - 16826

Solution :--

DGMGRL> show configuration

Configuration - dg1

  Protection Mode: MaxPerformance
  Databases:
    DBPR11G  - Primary database
    dbstp11g - Physical standby database
      Warning: ORA-16826: apply service state is inconsistent with the DelayMins property

/* Note the warning */

Fast-Start Failover: DISABLED

Configuration Status:
WARNING

DGMGRL>

Resolution :--

Step 1 :-- Check RECOVERY_MODE by querying v$archive_dest_status on primary


SQL> select recovery_mode from v$archive_dest_status;

RECOVERY_MODE
-----------------------
IDLE
MANAGED

Step 2 :-- Cancel the recovery process on standby

SQL> alter database recover managed standby database cancel;

Step 3:-- Start the recovery process

SQL> alter database recover managed standby database using current logfile disconnect;

Step 4:-- Query the primary

SQL> select recovery_mode from v$archive_dest_status;

RECOVERY_MODE
-----------------------
IDLE
MANAGED REAL TIME APPLY

IDLE

MANAGED has Changed to MANAGED REAL TIME APPLY

Step 5:-- Query 

DGMGRL> show database dbstp11g

Database - dbstp11g

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

Database Status:
SUCCESS

DGMGRL>







No comments:

Post a Comment

  Diagnosing a long parsing issue in Oracle Database Slide 1: Topic: Diagnosing a Long Parsing Issue in Oracle Database Slide 2: Parsing is ...