AS RN FROM v$logfile b where b.group#=a.group#) WHERE RN = 2) as Member2,from v$log------------------------------ -------------------
7 4901 YES INACTIVE /u02/oradata/PROD/redo06.log /u02/oradata
listener.log看上去不错,我不太了解alert_xe.log :)我想这是相关的信息:Thu Oct 15 10:52:10 2009 3923 redo blocks read, 520 data blocks need recovery:52:12 2009
Recovery of Online RedoLog: