ITPub博客

首页 > 数据库 > Oracle > Redo log文件被删除恢复

Redo log文件被删除恢复

原创 Oracle 作者:abstractcyj 时间:2016-04-05 11:23:23 0 删除 编辑
1. Redolog file是CURRENT的时候被删除, 清除日志时报错:ORA-01624:
    SQL> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.


Total System Global Area  354914304 bytes
Fixed Size                  2253224 bytes
Variable Size             180358744 bytes
Database Buffers          167772160 bytes
Redo Buffers                4530176 bytes
Database mounted.
SQL> alter system set "_allow_resetlogs_corruption" = true scope=spfile;


System altered.


SQL> recover database until cancel; 
Media recovery complete.
SQL> alter database open resetlogs;


Database altered.


SQL> alter system reset  "_allow_resetlogs_corruption"  scope=spfile sid='*' 
  2  /


System altered.


2. LOGFILE非CURRENT也非ACTIVE
SQL> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.


Total System Global Area  354914304 bytes
Fixed Size                  2253224 bytes
Variable Size             180358744 bytes
Database Buffers          167772160 bytes
Redo Buffers                4530176 bytes
Database mounted.
SQL> alter database clear logfile group 2;


Database altered.


SQL> alter database open;


Database altered.

参考:http://oracle.so138.com/ora/ora-01624log-1-needed-crash-recovery-instance-oracle-jia-yuan
        http://www.orasos.com/tag/ora-01624

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

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    602
  • 访问量
    1091599