日期:2014-05-16  浏览次数:20805 次

alert.log日志问题 菜鸟求教
系统记录:ora-03113:通信通道文件结束
-------log---------下面日志怎么查看
Wed Mar 21 14:34:28 2012
Thread 1 advanced to log sequence 1672
  Current log# 3 seq# 1672 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Thread 1 advanced to log sequence 1673
  Current log# 1 seq# 1673 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Thread 1 advanced to log sequence 1674
  Current log# 2 seq# 1674 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Wed Mar 21 14:34:39 2012
Thread 1 advanced to log sequence 1675
  Current log# 3 seq# 1675 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Thread 1 advanced to log sequence 1676
  Current log# 1 seq# 1676 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Wed Mar 21 14:35:03 2012
Thread 1 advanced to log sequence 1677
  Current log# 2 seq# 1677 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Wed Mar 21 14:35:27 2012
Thread 1 advanced to log sequence 1678
  Current log# 3 seq# 1678 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Wed Mar 21 14:35:45 2012
Thread 1 advanced to log sequence 1679
  Current log# 1 seq# 1679 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Thread 1 advanced to log sequence 1680
  Current log# 2 seq# 1680 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Wed Mar 21 14:36:02 2012
Thread 1 cannot allocate new log, sequence 1681
Checkpoint not complete
  Current log# 2 seq# 1680 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Thread 1 advanced to log sequence 1681
  Current log# 3 seq# 1681 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Thread 1 advanced to log sequence 1682
  Current log# 1 seq# 1682 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Wed Mar 21 14:36:22 2012
Thread 1 advanced to log sequence 1683
  Current log# 2 seq# 1683 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Thread 1 advanced to log sequence 1684
  Current log# 3 seq# 1684 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Thread 1 advanced to log sequence 1685
  Current log# 1 seq# 1685 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Wed Mar 21 14:36:35 2012
Thread 1 advanced to log sequence 1686
  Current log# 2 seq# 1686 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Wed Mar 21 14:37:08 2012
Thread 1 advanced to log sequence 1687
  Current log# 3 seq# 1687 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Wed Mar 21 14:37:47 2012
Thread 1 advanced to log sequence 1688
  Current log# 1 seq# 1688 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Wed Mar 21 14:38:23 2012
Thread 1 cannot allocate new log, sequence 1689
Checkpoint not complete
  Current log# 1 seq# 1688 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Thread 1 advanced to log sequence 1689
  Current log# 2 seq# 1689 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Wed Mar 21 14:38:43 2012
Thread 1 advanced to log sequence 1690
  Current log# 3 seq# 1690 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Wed Mar 21 14:38:55 2012
Thread 1 advanced to log sequence 1691
  Current log# 1 seq# 1691 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG
Wed Mar 21 14:39:09 2012
Thread 1 advanced to log sequence 1692
  Current log# 2 seq# 1692 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG
Thread 1 advanced to log sequence 1693
  Current log# 3 seq# 1693 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG
Wed Mar 21 14:39:22 2012
Thread 1 advanced to log sequence 1694
  C