文档解释
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”语句删除日志文件。