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;
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
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