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