orcle恢复报错：ORA00392:日志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>

View Code