系统可以正常使用,但alert日志报错
ccid-k:/ora10g/admin/sfcc/bdump>more alert_sfcc.log
Tue Aug 11 09:38:33 2009
Errors in file /ora10g/admin/sfcc/bdump/sfcc_lgwr_14562.trc:
ORA-00313: Message 313 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [/ora10g/flash_recovery_area/S
FCC/onlinelog/o1_mf_1_4dyn1o9n_.log]
报错lgwr找不到回复区里的在线日志文件
查看在线日志文件
select group#,member from v$logfile;
SQL> /
GROUP# MEMBER
---------- ---------------------------------------------------------------------------------------------------------------------------------------------------
1 /ora10g/oradata/SFCC/onlinelog/o1_mf_1_4dyn1o4t_.log
1 /ora10g/flash_recovery_area/SFCC/onlinelog/o1_mf_1_4dyn1o9n_.log
2 /ora10g/oradata/SFCC/onlinelog/o1_mf_2_4dyn1ok5_.log
2 /ora10g/flash_recovery_area/SFCC/onlinelog/o1_mf_2_4dyn1p2d_.log
3 /ora10g/oradata/SFCC/onlinelog/o1_mf_3_4dyn1qkm_.log
3 /ora10g/flash_recovery_area/SFCC/onlinelog/o1_mf_3_4dyn1qrh_.log
6 rows selected.
每个组2个成员
恢复区中的对象都不在
cp /ora10g/oradata/SFCC/onlinelog/o1_mf_1_4dyn1o4t_.log /ora10g/flash_recovery_area/SFCC/onlinelog/o1_mf_1_4dyn1o9n_.log
cp /ora10g/oradata/SFCC/onlinelog/o1_mf_2_4dyn1ok5_.log /ora10g/flash_recovery_area/SFCC/onlinelog/o1_mf_2_4dyn1p2d_.log
cp /ora10g/oradata/SFCC/onlinelog/o1_mf_3_4dyn1qkm_.log /ora10g/flash_recovery_area/SFCC/onlinelog/o1_mf_3_4dyn1qrh_.log
根据查询的结果写出复制命令
将丢失的在线日志文件补上
切换日志
不在报错
==========
报错信息很重好
认真读
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/13177610/viewspace-672984/ ,如需转载,请注明出处,否则将追究法律责任。