Search This Blog

Wednesday, 13 June 2018

Warning: ORA-16826: apply service state is inconsistent with the DelayMins property



        Need to check on DelayMins configuration on all standby’s

ð  DGMGRL> show database verbose 'TESH957P_DC2' 'delaymins';

        Check MRP process is running or not.

ð  SYS@TESH957P SQL>SELECT PROCESS, STATUS, THREAD#, SEQUENCE#,BLOCK#, BLOCKS FROM V$MANAGED_STANDBY where PROCESS like 'MRP%';

          Need to restart Intended State option:

ð  edit database "TESH957P_DC1" set state=apply-off;

ð  edit database "TESH957P_DC1" set state=apply-on;

         And need to cancel the MRP process while enabling i have used " CURRENT LOGFILE " option.

ð  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

ð  ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;

No comments:

Post a Comment