从当前重做日志组的丢失中恢复。
从不活动的重做日志组的丢失中恢复。
从惟一活动重做日志组的丢失中恢复。
从丢失的联机重做日志组的成员中进行恢复。
Recovering from the loss of one member of an online redo log group.
你可以在主库添加或删除在线重做日志组或者日志成员而不影响备库。
You can add or drop online redo log file groups or members to the primary database without affecting the standby database.
表明例程恢复不再需要联机重做日志组，它可能已经归档也可能未归档。
INACTIVE - Log is no longer needed for instance recovery. It may be in use for media recovery. It might or might not be archived.
联机重做日志组是活动的，但是并非当前联机重做日志组，崩溃恢复需要该状态。
Active - log is active but is not the current log. It is needed for crash recovery. It.
由于重做日志组是不活动和归档的，所以只需清除重做日志即可 ——alterdatabaseclear logfilegroupN（其中 N 是丢失的重做日志的组 #）。
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)
要检查丢失的重做日志处于什么状态 ——Select *fromv$logifle显示哪个组及哪个成员是无效的。
To investigate what status is the missing redo log is - Select * from v$logfile shows which group and member is INVALID
理论上说，日志文件组的成员的存放位置应该放在磁盘上的不同位置，这样即使一个磁盘损坏也不会导致整个在线重做日志文件丢失。
Ideally, the locations of the members should be on separate disks so that the failure of one disk does not cause the loss of the entire online redo log.
保存在线重做日志文件组的多个成员来保证重做日志不丢失。
Maintaining multiple members of an online redo log group protects against the loss of the redo log.
保存在线重做日志文件组的多个成员来保证重做日志不丢失。
Maintaining multiple members of an online redo log group protects against the loss of the redo log.
应用推荐