日志损坏后怎样启数据库.docVIP

日志损坏后怎样启数据库 如果没有备份情况下当前日志组损坏将如何? SQL conn / as sysdba Connected. SQL select * from v$log; --当前日志组指定在2号组上 SQL host cp /home/1.txt /home/app/oracle/oradata/orcl/redo02.log; 破坏当前的日志文件,再进行切换 SQL alter system switch logfile; alter system switch logfile * ERROR at line 1: ORA-03113: end-of-file on communication channel 实例崩溃了.因为lgwr死了,它是核心进程,一个核心进程死亡实例就会崩溃 SQL conn sys /as sysdba Enter password: Connected to an idle instance. SQL startup ORACLE instance started. Total System Global Area 座机电话号码2 bytes Fixed Size 1218992 bytes Variable Size 1座机电话号码 bytes Database Buffers 1座机电话号码 bytes Redo Buffers 座机电话号码 bytes Database mounted. ORA-00316: log 2 of thread 1, type 0 in header is not log file ORA-00312: online log 2 thread 1: /home/app/oracle/oradata/orcl/redo02.log 我们想启动数据库,但是失败了.因为我们现在的文件根本不是一个日志文件. SQL alter system set _allow_resetlogs_corruption true scope spfile; alter system set _allow_resetlogs_corruption true scope spfile * ERROR at line 1: ORA-00911: invalid character 修改参数失败了. SQL alter system set _allow_resetlogs_corruption true scope spfile; 加上双引号,修改成功 System altered. SQL shutdown abort; ORACLE instance shut down. SQL startup mount; ORACLE instance started. 重新启动实例使修改的参数生效 Total System Global Area 1座机电话号码 bytes Fixed Size 1247900 bytes Variable Size 座机电话号码 bytes Database Buffers 座机电话号码 bytes Redo Buffers 座机电话号码 bytes Database mounted. SQL show parameter allow NAME TYPE VALUE _allow_resetlogs_corruption boolean TRUE SQL alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01139: RESETLOGS option only valid after an incomplete database recovery 我们想以resetlogs模式打开数据库,让数据库重新建立日志,但失败了. 我们做一个假恢复,欺骗数据库.走个形式,因为我们没有备份,不可能真恢复 SQL recover database until cancel; ORA-00279: change 819512 generated at 11/04/2011 11:44:11 needed for thread 1 ORA-00289: suggestion : /home/app/oracle/flash_recovery_area/ORCL/archivelog/2011_11_04/o1_mf_1_7_%u_.ar c ORA-00280: change 819512 for thread 1 is in sequence #7 Specify log: suggested | fi