ORA-00362: member is required to form a valid logfile in group string

来源:互联网 发布:mvc cms 后台管理系统 编辑:程序博客网 时间:2024/05/11 19:49

stale status of redo logs.......

ORA-00362:

member is required to form a valid logfile in group stringCause:A request to drop a logfile member was denied because it would remove data required to form a complete logfile.
Action:If desired, delete the entire log (after archiving if required), by using DROP LOGFILE;



This status means the logfile contains incomplete redo info. This status prevents the logfile from being dropped without being archived first. You should not worry about this status unless it happens repeatedly. Becuase "stale" does not mean "invalid". When this redo group becomes current, this state will automatically become valid


alter system switch logfile;

then check v$logfile again

原创粉丝点击