恢复误删除的redo log

来源：互联网发布：开发一个软件多少钱编辑：程序博客网时间：2024/05/16 10:22

恢复非当前的日志组

[oracle@zwc primarydb]$ rm -rf redo01*SYS@zwcdb:~>startupORACLE instance started.Total System Global Area  285212672 bytesFixed SIZE                  1218992 bytesVariable SIZE              96470608 bytesDATABASE Buffers          184549376 bytesRedo Buffers                2973696 bytesDATABASE mounted.ORA-00313: OPEN failed FOR members OF log GROUP 1 OF thread 1ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/primarydb/redo01.log'ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/primarydb/redo01_.log'SYS@zwcdb:~>ALTER DATABASE clear logfile GROUP 1;DATABASE altered.SYS@zwcdb:~>ALTER DATABASE OPEN;DATABASE altered.

恢复当前日志组

SYS@zwcdb:~>startupORACLE instance started.Total System Global Area  285212672 bytesFixed SIZE                  1218992 bytesVariable SIZE              96470608 bytesDATABASE Buffers          184549376 bytesRedo Buffers                2973696 bytesDATABASE mounted.ORA-00313: OPEN failed FOR members OF log GROUP 1 OF thread 1ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/primarydb/redo01.log'ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/primarydb/redo01_.log'SYS@zwcdb:~>recover DATABASE until cancel;Media recovery complete.SYS@zwcdb:~>ALTER DATABASE OPEN resetlogs;DATABASE altered.SYS@zwcdb:~>SELECT a.GROUP#,a.TYPE,b.STATUS,b.bytes/1024/1024||'M' "SIZE",a.member,a.is_recovery_dest_file   2  FROM v$logfile a,v$log b WHERE a.GROUP#=b.GROUP# ORDER BY 1;    GROUP# TYPE    STATUS           SIZE  MEMBER                                             IS_RECOVERY_DEST_FILE---------- ------- ---------------- ----- -------------------------------------------------- ---------------------         1 ONLINE  INACTIVE         50M   /u01/app/oracle/oradata/primarydb/redo01.log       NO         1 ONLINE  INACTIVE         50M   /u01/app/oracle/oradata/primarydb/redo01_.log      NO         2 ONLINE  CURRENT          50M   /u01/app/oracle/oradata/primarydb/redo02_.log      NO         2 ONLINE  CURRENT          50M   /u01/app/oracle/oradata/primarydb/redo02.log       NO         3 ONLINE  UNUSED           50M   /u01/app/oracle/oradata/primarydb/redo03_.log      NO         3 ONLINE  UNUSED           50M   /u01/app/oracle/oradata/primarydb/redo03.log       NO6 ROWS selected.