当前位置: 代码迷 >> 综合 >> Oracle DataGuard 备库启动报ORA-01186 ORA-01122 ORA-01110 ORA-01210
  详细解决方案

Oracle DataGuard 备库启动报ORA-01186 ORA-01122 ORA-01110 ORA-01210

热度:69   发布时间:2024-02-02 15:32:43.0

如果使用LVM管理存储,当从生产端往容灾端做完基线后,启动容灾DB到read only状态时,告警日志中报如下错误:

Reread of rdba: 0x00400001 (file 201,block 1) found same corrupted dataErrors in file /oracle/db/diag/rdbms/drora01/ drora01/trace/drora01 dbw0_ 12388.trc:

ORA-01186: file 201 failed verification tests

ORA-01122: database file 201 failed verification check

ORA-01110: data file 201: '/dev/vgdrora/ rlv temp'

ORA -01210: data file header is media corrupt File 201 not verified due to error ORA-01122

【建议方案】

① 将容灾DB启动到readonly状态

② 在容灾DB执行以下命令重建tempfile :

SQL>alter database tempfile '/dev/vgdrora/rlv _temp'  drop;

SQL>alter tablespace temp add tempfile '/dev/vgdrora/ rlv _temp' size 4000M reuse;

  相关解决方案