orcle恢复报错：ORA-00392: 日志 2 (用于线程 1) 正被清除, 不允许操作

遇到问题

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: 位于 10/20/2022 14:28:10 的 sql statement 命令失败
ORA-00344: 无法重新创建联机日志 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG'
ORA-27040: 文件创建错误, 无法创建文件
OSD-04002: 无法打开文件
O/S-Error: (OS 3) 系统找不到指定的路径。

 

1. 目录不存在，尝试手动创建该目录

结果还是有问题

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: 位于 10/20/2022 14:30:42 的 sql statement 命令失败
ORA-00392: 日志 2 (用于线程 1) 正被清除, 不允许操作
ORA-00312: 联机日志 2 线程 1: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG'

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: 位于 10/20/2022 14:31:02 的 sql statement 命令失败
ORA-00392: 日志 2 (用于线程 1) 正被清除, 不允许操作
ORA-00312: 联机日志 2 线程 1: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG'

 

2. 迁移目录

结果不变

RMAN> alter database rename file 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG' to 'D:\APP\oradata\ORCL\REDO01.LOG';

已处理语句

RMAN> alter database rename file 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG' to 'D:\APP\oradata\ORCL\REDO02.LOG';

已处理语句

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: 位于 10/20/2022 14:36:22 的 sql statement 命令失败
ORA-00392: 日志 2 (用于线程 1) 正被清除, 不允许操作
ORA-00312: 联机日志 2 线程 1: 'D:\APP\ORADATA\ORCL\REDO02.LOG'

 

3. 删除日志信息

OK

RMAN> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
         1 CLEARING
         2 CLEARING_CURRENT
         5 CLEARING
         4 CLEARING
         3 CLEARING

RMAN> alter database clear logfile group 1;

已处理语句

RMAN> alter database clear logfile group 2;

已处理语句

RMAN> alter database clear logfile group 3;

已处理语句

RMAN> alter database clear logfile group 4;

已处理语句

RMAN> alter database clear logfile group 5;

已处理语句

RMAN> alter database open resetlogs;

已处理语句

RMAN>

 

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: 位于 10/20/2022 14:28:10 的 sql statement 命令失败
ORA-00344: 无法重新创建联机日志 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG'
ORA-27040: 文件创建错误, 无法创建文件
OSD-04002: 无法打开文件
O/S-Error: (OS 3) 系统找不到指定的路径。

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: 位于 10/20/2022 14:30:42 的 sql statement 命令失败
ORA-00392: 日志 2 (用于线程 1) 正被清除, 不允许操作
ORA-00312: 联机日志 2 线程 1: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG'

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: 位于 10/20/2022 14:31:02 的 sql statement 命令失败
ORA-00392: 日志 2 (用于线程 1) 正被清除, 不允许操作
ORA-00312: 联机日志 2 线程 1: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG'

RMAN> alter database rename file 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO01.LOG' to 'D:\APP\oradata\ORCL\REDO01.LOG';

已处理语句

RMAN> alter database rename file 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\REDO02.LOG' to 'D:\APP\oradata\ORCL\REDO02.LOG';

已处理语句

RMAN> alter database open resetlogs;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: 位于 10/20/2022 14:36:22 的 sql statement 命令失败
ORA-00392: 日志 2 (用于线程 1) 正被清除, 不允许操作
ORA-00312: 联机日志 2 线程 1: 'D:\APP\ORADATA\ORCL\REDO02.LOG'

RMAN> select group#,status from v$log;

    GROUP# STATUS
---------- ----------------
         1 CLEARING
         2 CLEARING_CURRENT
         5 CLEARING
         4 CLEARING
         3 CLEARING

RMAN> alter database clear logfile group 1;

已处理语句

RMAN> alter database clear logfile group 2;

已处理语句

RMAN> alter database clear logfile group 3;

已处理语句

RMAN> alter database clear logfile group 4;

已处理语句

RMAN> alter database clear logfile group 5;

已处理语句

RMAN> alter database open resetlogs;

已处理语句

RMAN>