恢复误删除的redo log

最新推荐文章于 2021-12-14 18:10:12 发布

ZhongWeicheng

最新推荐文章于 2021-12-14 18:10:12 发布

阅读量3k

点赞数 1

分类专栏： Oracle 文章标签： oracle Oracle ORACLE

本文链接：https://blog.csdn.net/staricqxyz/article/details/8314579

版权

Oracle 专栏收录该内容

165 篇文章 0 订阅

订阅专栏

恢复非当前的日志组

[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.