处理Online redo log错误

1：redo log 是如何工作的：Online redo logs store a record of transactions that have occurred in your database. Online redo logs exist solely to provide a mechanism for you to recover your database in the event of a failure. You are required to have at least two online redo log groups in your database. Each online redo log group must contain at least one online redo log member. The member is the physical file that exists on disk. You can create multiple members in each redo log group, which is known as multiplexing your online redo log group.NOTE：联机重做日志记录数据库发生的所有变化。联机重做日志采用循环些的处理方法2：如何尽量减少redo错误造成的数据损失：•Multiplex groups to have multiple members.•Never allow two members of the same group to share the same controller.
•Never put two members of the same group on the same physical disk.
•Ensure operating system file permissions are set appropriately.
•Use physical storage devices that are redundant （that is, RAID）.
•Appropriately size the log files so that they switch and are archived at regular intervals.
•Set the archive_lag_targetinitialization parameter to ensure that the online redo logsare switched at regular intervals 3：Determining How to Restore

Inspect the alert.log file to determine which online redo log files have experienced a media failure.
Query V$LOG and V$LOGFILE to determine the status of the log group and degree of multiplexing.
If there is still one functioning member of a multiplexed group, fix the remaining failed member（s）.
Depending on the status of the log group

select a.group#,a.thread# ,a.status ,b.member member,b.status from v$log a,v$logfile b where a.group#=b.group# order by a.group#,b.group#；

RMAN备份中常见的问题Oracle Alert log按时间保存脚本相关资讯 redo log

Oracle 11g的Redo Log和Archive （昨 06:56）
管理REDO LOG记录（07/20/2015 20:58:10）
关于redo log的修改与重建（04/26/2014 10:13:55）

archive log文件大小与redo log文（07/23/2015 16:50:33）
使用append+nologging引起恢复故障（05/05/2014 20:26:06）
删除redo log group or member （04/25/2013 09:09:20）

本文评论查看全部评论（0）