Redo Logfile Sizing Advisor - This feature recommends the optimal size of redo log files in order to avoid excessive disk I/Os due to frequent checkpointing.
Redo Logfile Sizing Advisor —— 此特性推荐重做日志文件的最佳大小,从而避免因频繁出现的检查点而导致过多的磁盘 I/O。
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 显示哪个组及哪个成员是无效的。
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 是丢失的重做日志的组 #)。
应用推荐