遇到问题
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>