没有备份的current状态的redo日志损坏

SQL> select* from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM---------- ---------- ---------- -------------------- --- ---------------- ------------- --------- 1 1 2 52428800 1 YES ACTIVE 464602 07-SEP-12 2 1 3 52428800 1 NO CURRENT 464604 07-SEP-12 3 1 1 52428800 1 YES ACTIVE 464091 07-SEP-12 SQL> select * from v$logfile; GROUP# STATUS TYPE MEMBER IS_---------- ------- ----------------------------------------------- --- 3 ONLINE /u01/tiger/oradata/orcl/redo03.log NO 2 ONLINE /u01/tiger/oradata/orcl/redo02.log NO 1 ONLINE /u01/tiger/oradata/orcl/redo01.log NO SQL> ！cp /etc/passwd/u01/tiger/oradata/orcl/redo02.log SQL> alter system switch logfile;alter system switch logfile*ERROR at line 1:ORA-03113: end-of-file on communicationchannel SQL> conn /as sysdbaConnected to an idle instance.SQL> startupOracle instance started. Total System Global Area 314572800 bytesFixed Size 1219136 bytesVariable Size 117441984 bytesDatabase Buffers 188743680 bytesRedo Buffers 7168000 bytesDatabase mounted.ORA-00316:log 2 of thread 1, type 14900 in header is not log fileORA-00312: online log 2 thread 1:"/u01/tiger/oradata/orcl/redo02.log" SQL> recover database;ORA-00283: recovery session canceled due toerrorsORA-00316: log 2 of thread 1, type 14900 inheader is not log fileORA-00312: online log 2 thread 1:"/u01/tiger/oradata/orcl/redo02.log" SQL> recover database until cancel;ORA-00279: change 464604 generated at09/07/2012 15:26:50 needed for thread 1ORA-00289: suggestion :/u01/tiger/flash_recovery_area/ORCL/archivelog/2012_09_07/o1_mf_1_3_%u_.arcORA-00280: change 464604 for thread 1 is insequence #3 Specify log: {<RET>=suggested |filename | AUTO | CANCEL}cancelORA-01547:warning: RECOVER succeeded but OPEN RESETLOGS would get error belowORA-01194:file 1 needs more recovery to be consistentORA-01110: data file 1:"/u01/tiger/oradata/orcl/system01.dbf" ORA-01112: media recovery not started SQL> alter database open;alter database open*ERROR at line 1:ORA-01589: must use RESETLOGS orNORESETLOGS option for database open SQL> alter database open resetlogs; Database altered. 无备份的使用隐含参数恢复如果出现如下情况SQL> alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-01194: file 1 needs more recovery to beconsistentORA-01110: data file 1:"/u01/oracle/oradata/ora10g/system01.dbf"我们只能放弃不完全恢复使用隐含参数恢复altersystem set "_allow_resetlogs_corruption"=true scope=spfile;Oracle 创建表和插入的相关注意事项redo文件破坏使用隐含参数恢复数据库相关资讯 redo

大量redo生成的问题原因及改进（09/06/2015 21:44:21）
Oracle 10g Standby Database 实时（12/22/2014 18:34:35）
普通表与临时表DML操作会产生REDO/ （09/17/2013 20:29:12）

online redo日志文件损坏恢复（01/11/2015 08:36:34）
Redo丢失的4种情况及处理方法（11/26/2014 11:12:28）
Oracle redo 日志调整（06/07/2013 16:13:00）

本文评论查看全部评论（0）