您好,登錄后才能下訂單哦!
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_arc0_13756.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 16320 change 17258861688 time 07/10/2019 00:11:07
ORA-00312: online log 7 thread 1: 'E:\ORACLE\ORADATA\ORCL\REDO07.LOG'
參考mos id :332672.1
1、添加redo組及成員
alter database add logfile group 8 'E:\ORACLE\ORADATA\ORCL\REDO08.log' size 200M;
alter database add logfile member 'E:\ORACLE\ORADATA\ORCL\REDO081.log' to group 8;
2、查看無法歸檔redo狀態(tài)
select GROUP# ,BYTES/1024/1024 size_M,STATUS,ARCHIVED from v$log;
GROUP# SIZE_M STATUS ARC
4 200 INACTIVE YES
5 200 INACTIVE YES
6 200 CURRENT YES
7 200 INACTIVE NO
8 200 UNUSED NO
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
E:\ORACLE\ORADATA\ORCL\REDO10.LOG
E:\ORACLE\ORADATA\REDO\REDO001.LOG
E:\ORACLE\ORADATA\REDO\REDO03.LOG
E:\ORACLE\ORADATA\REDO\REDO003.LOG
3、清理redo
alter database clear unarchived logfile group 7;
4、redo 刪除
alter database drop logfile group 7;
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報,并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。