ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 日志文件损坏的恢复

日志文件损坏的恢复

原创 Linux操作系统 作者:marvinoracle 时间:2011-04-10 15:27:10 0 删除 编辑

日志文件损坏的恢复

今天打开我测试机的oracle数据库。发现数据库起步来了。具体步骤如下:

SYS>startup
ORACLE instance started.

Total System Global Area  603979776 bytes
Fixed Size                  1220796 bytes
Variable Size             104861508 bytes
Database Buffers          490733568 bytes
Redo Buffers                7163904 bytes
Database mounted.
ORA-16038: log 1 sequence# 56 cannot be archived
ORA-19502: write error on file "", blockno  (blocksize=)
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'


SYS>alter database open;
alter database open
*
ERROR at line 1:
ORA-16014: log 1 sequence# 56 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'


SYS>shutdown abort
ORACLE instance shut down.
SYS>startup
ORACLE instance started.

Total System Global Area  603979776 bytes
Fixed Size                  1220796 bytes
Variable Size             104861508 bytes
Database Buffers          490733568 bytes
Redo Buffers                7163904 bytes
Database mounted.
ORA-16038: log 1 sequence# 56 cannot be archived
ORA-19502: write error on file "", blockno  (blocksize=)
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'

 

SYS>select * from v$logfile;

    GROUP# STATUS  TYPE    MEMBER                                             IS_
---------- ------- ------- -------------------------------------------------- ---
         3 STALE   ONLINE  +ORACLEASM/orcl/onlinelog/group_3.266.747324497    NO
         2         ONLINE  +ORACLEASM/orcl/onlinelog/group_2.267.747324547    NO
         1         ONLINE  /u01/app/oracle/oradata/orcl/redo01.log            NO

原来闪回区空间满了。删除了一部分后就ok了。
alter database clear  unarchived logfile group 1;
alter database open

ok 数据库起来了。。。。。呵呵

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24531354/viewspace-692182/,如需转载,请注明出处,否则将追究法律责任。

上一篇: sqlplus中的set命令
请登录后发表评论 登录
全部评论

注册时间:2010-09-02

  • 博文量
    67
  • 访问量
    181810