1.SQL> startup;
ORACLE instance started.

Total System Global Area 1029484544 bytes
Fixed Size                  1379100 bytes
Variable Size             373294308 bytes
Database Buffers          650117120 bytes
Redo Buffers                4694016 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 5848
Session ID: 9 Serial number: 5

2.查看报警日志文件（alert.log),发现日志组二丢失）
Thu Sep 08 15:22:10 2011
ARC2 started with pid=22, OS id=4040
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Errors in file d:\app\ffybjf\diag\rdbms\orcl\orcl\trace\orcl_lgwr_4320.trc:
ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: 'D:\APP\FFYBJF\ORADATA\ORCL\REDO02.LOG'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

3.恢复丢失的日志
SQL> alter database clear unarchived logfile group 2;

Database altered.

SQL> alter database open;

Database altered.

ITPub博客

red log （current)丢失的处理.

最新文章