ORA-00364: cannot write header to new log member ORACLE 报错 故障修复 远程处理

文档解释

ORA-00364: cannot write header to new log member

Cause: An i/o error occurred when attempting to write the header to a log member that is being added to an existing group.

Action: See accompanying errors. Fix problem or use another file.

ORA-00364: cannot write header to new log member错误指的是Oracle不能将头文件写入新的日志成员。

官方解释

ORA-00364 “cannot write header to new log member” is a generic message that can be caused during online log file additions, or when performing media recovery. It is reported when header information is written to a new log file, and the file exists, but Oracle cannot create or write to the file.

常见案例

ORA-00364: cannot write header to new log member is caused usually by incorrect permissions and/or incorrect path settings.

正常处理方法及步骤

1.首先检查日志文件是否存在，如果不存在，则在磁盘相应位置创建该文件。

2.确保新日志文件具有Oracle系统用户足够权限，如READ、WRITE和EXECUTE。

3.使用“alter database add logfile”重新添加日志文件，如果之前尝试过添加新的日志文件，则要注意只有之前尝试的状况才能够添加新的日志文件。

4.使用“alter database drop logfile”语句删除日志文件。