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

时间:2025-04-09 20:36:32

如果使用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_ :

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;