恢复误删除的redo log

恢复非当前的日志组

[oracle@zwc primarydb]$ rm -rf redo01*
SYS@zwcdb:~>startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed SIZE                  1218992 bytes
Variable SIZE              96470608 bytes
DATABASE Buffers          184549376 bytes
Redo Buffers                2973696 bytes
DATABASE mounted.
ORA-00313: OPEN failed FOR members OF log GROUP 1 OF thread 1
ORA-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:~>startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed SIZE                  1218992 bytes
Variable SIZE              96470608 bytes
DATABASE Buffers          184549376 bytes
Redo Buffers                2973696 bytes
DATABASE mounted.
ORA-00313: OPEN failed FOR members OF log GROUP 1 OF thread 1
ORA-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       NO

6 ROWS selected.