web123456

Oracle DataGuard library startup report ORA-01186 ORA-01122 ORA-01110 ORA-01210

If you use LVM to manage storage, when the baseline is completed from the production side to the disaster recovery side and start the disaster recovery DB to the read only state, the following error is reported in the alarm log:

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

【Suggested Plan】

① Start the disaster recovery DB to readonly state

② Run the following command in the disaster recovery DB to rebuild the tempfile:

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

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