Search This Blog

Monday, 16 July 2018

Standby backup issue due to mrp running other nodes:



edit database 'OESH7A7D' set state='APPLY-OFF';
edit database 'OESH7A7D' set state='APPLY-ON' with apply instance ='OESH7A7D1';
show database 'OESH7A7D';

select thread#,max(sequence#) from gv$log_history group by thread#;

No comments:

Post a Comment