物理DG库,
白天open给报表ETL数据
结果报错了
ORA-01578: ORACLE data block corrupted (file # 24, block # 577422)
ORA-01110: data file 24: '/dev/rkt_iomorderidx4'
ORA-26040: Data block was loaded using the NOLOGGING option
ORA-02063: preceding 3 lines from TO_DATA_GUARD
ORA-06512: at "IOMREPORT.ETL", line 100
ORA-06512: at "IOMREPORT.ETL", line 513
ORA-06512: at line 1
不知道咋整了,请教各位大师
这个错产生的原因是什么呢?
怎么恢复呢?
有两种选择:
1.恢复顺坏的数据文件,方法是在生产数据库做个在线备份,眼后把它考到DG上,进行修复就可以了...
生产库:
alter tablespace xxx begin backup;
cp XXX.dbf to XXX.dbf;
alter tablespace xxx end backup;
DG:
alter datafile xxx.dbf offline;
cp XXX.dbf to XXX.dbf;
recover datafile XXX.dbf;
alter datafile xxx.dbf online;