logfile文件损坏的问题处理(ORA-00327)
1, 数据库日志报错ORA-00327,注意此处有乱码
sys@TYOLAP3(dtydb5)> ALTER DATABASE DROP LOGFILE MEMBER '+DATA/tyolap/onlinelog/redo31a'; 数据库已更改。sys@TYOLAP3(dtydb5)> ALTER DATABASE ADD LOGFILE MEMBER '+DATA/tyolap/onlinelog/redo31a' to group 31; 数据库已更改。sys@TYOLAP3(dtydb5)> alter system switch logfile;系统日志恢复正常 GROUP# STATUS TYPE MEMBER IS_---------- ------- ------- -------------------------------------------------- --- 31 ONLINE +DATA/tyolap/onlinelog/redo31a NO ONLINE +DATA/tyolap/onlinelog/redo31b NO 32 ONLINE +DATA/tyolap/onlinelog/redo32a NO ONLINE +DATA/tyolap/onlinelog/redo32b NO
5,系统恢复正常了,但是日志文件损坏的原因还不是特清楚。