控制文件和REDOLOG同时损坏的ORACLE数据库恢复一例

控制文件和REDOLOG同时损坏的ORACLE数据库恢复一例

一个客户打电话给我，说他们一个测试数据库起不来了，让我过去看看， 到客户现场发现数据库已经DOWN了，试着启动一下 SQL*Plus: Release 10.2.0.3.0 - Production on Tue Oct 7 10:33:29 2008 Copyright (c) 1982, 2006, Oracle.  All Rights Reserved. Connected to an idle instance. ORACLE instance started. Total System Global Area 2365587456 bytes Fixed Size                  2060096 bytes Variable Size            1526726848 bytes Database Buffers          822083584 bytes Redo Buffers               14716928 bytes Database mounted. ORA-16038: log