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