oracle 归档模式下删除current日志不完全恢复

最新推荐文章于 2022-12-12 21:45:12 发布

转载最新推荐文章于 2022-12-12 21:45:12 发布 · 230 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://blog.51cto.com/12185273/2150156

文章标签：

#数据库

本文介绍了Oracle数据库在归档模式下的操作与日志管理，包括如何查看当前的日志状态和归档设置。同时，针对删除日志文件后启动数据库出现的错误，提供了详细的恢复步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

归档模式

SYS@orcl> archive log list
Database log mode          Archive Mode
Automatic archival         Enabled
Archive destination        /u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch
Oldest online log sequence     5
Next log sequence to archive   7
Current log sequence           7

查看日志组

SYS@orcl> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
     1 INACTIVE
     2 CURRENT
     3 INACTIVE

查看current日志组文件路径

select member from v$logfile;

MEMBER
------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl/redo03.log
/u01/app/oracle/oradata/orcl//redo02.log
/u01/app/oracle/oradata/orcl//redo01.log

删除日志文件
rm -rf /u01/app/oracle/oradata/orcl/redo02.log
启动数据库报错

SYS@orcl> startup
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size          2257840 bytes
Variable Size         536874064 bytes
Database Buffers      289406976 bytes
Redo Buffers            6565888 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 2821
Session ID: 125 Serial number:

查看trace alert日志，提示找不到文件

ORA-00313: open failed for members of log group 2 of thread 1
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/orcl/redo02.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

进行恢复

recover database until cancel;
alter database open resetlogs;

转载于:https://blog.51cto.com/12185273/2150156