CNDBA社区
Media Recovery Log +ARCHDG/amr/archivelog/2019_03_20/thread_2_seq_819422.3145.1003396757
Errors in file /u01/app/oracle/diag/rdbms/amr/amrdb1/trace/amrdb1_pr00_304235.trc:
ORA-00333: redo log read error block 1458176 count 2048
ORA-00334: archived log: ‘+ARCHDG/amr/archivelog/2019_03_21/thread_1_seq_837062.2361.1003406937’
ORA-17510: Attempt to do i/o beyond file size
Errors in file /u01/app/oracle/diag/rdbms/amr/amrdb1/trace/amrdb1_pr00_304235.trc:
ORA-00333: redo log read error block 1458176 count 2048
ORA-00334: archived log: ‘+ARCHDG/amr/archivelog/2019_03_21/thread_1_seq_837062.2361.1003406937’
ORA-17510: Attempt to do i/o beyond file size
Incomplete read from log member ‘+ARCHDG/amr/archivelog/2019_03_21/thread_1_seq_837062.2361.1003406937’. Trying next member.
Errors with log +ARCHDG/amr/archivelog/2019_03_20/thread_2_seq_819422.3145.1003396757
MRP0: Detected read corruption! Retry recovery once log is re-fetched…
Errors in file /u01/app/oracle/diag/rdbms/amr/amrdb1/trace/amrdb1_pr00_304235.trc:
ORA-00333: redo log read error block 1458176 count 2048
查询v$managed_standby视图看到MRP进程卡在thread_1_seq_837062 这个日志不应用；
select PROCESS,STATUS,GROUP# ,THREAD#,SEQUENCE#,BLOCK# from v$managed_standby order by 6 desc
解决方案：从主库拷贝archivelog 到备库：
seq=$1
thread=$2
rman target sys/“XDQhmg##309”@amrdb auxiliary sys/“XDQhmg##309”@amr_ytj log /home/oracle/for_dg.log
run {
backup as copy reuse archivelog sequence ${seq} thread ${thread} auxiliary format ‘+ARCHDG’;
backup as copy reuse archivelog sequence 837062 thread 1 auxiliary format ‘+ARCHDG’;
}
版权声明：本文为博主原创文章，未经博主允许不得转载。
adg备库缺少日志mrp中断，拷贝主库日志到备库
