ITPub博客

首页 > Linux操作系统 > Linux操作系统 > red log (current)丢失的处理.

red log (current)丢失的处理.

原创 Linux操作系统 作者:ljs4053 时间:2011-09-08 15:20:24 0 删除 编辑
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博客 ” ,链接:http://blog.itpub.net/22736841/viewspace-706929/,如需转载,请注明出处,否则将追究法律责任。

上一篇: SP2-0575错误
请登录后发表评论 登录
全部评论

注册时间:2010-02-22

  • 博文量
    14
  • 访问量
    10551