每个实例只有一个活动的LGWR(log writer)进程,至少有两个日志组(logfile group),每个日志组至少一个日志文件,同一日志组多个日志文件内容相同,互为镜像。
基于12个网页-相关网页
Since the redo log group is inactive and is archived, just clear the redo log - alter database clear logfile group N (where N is the group # of the lost redo log)
由于重做日志组是不活动和归档的,所以只需清除重做日志即可 —— alter database clear logfile group N(其中 N 是丢失的重做日志的组 #)。
To investigate what status is the missing redo log is - Select * from v$logfile shows which group and member is INVALID
要检查丢失的重做日志处于什么状态 —— Select * from v$logifle 显示哪个组及哪个成员是无效的。
Add a new member to the group - Alter database add logfile member '/fullpath/log_filename.
将新的成员添加到这个组 —— Alter database add logfile member '/fullpath/log_filename.log' reuse to group n;
应用推荐