联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
有一个客户他是linux到win环境dg,alert日志报清除fra中日志失败
un Jun 25 10:50:14 2023 Media Recovery Waiting for thread 1 sequence 196437 (in transit) Sun Jun 25 10:50:26 2023 WARNING: Cannot delete Oracle managed file /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_28/o1_mf_1_192078_l74s4m2l_.arc Errors in file D:\APP\ADMINISTRATOR\diag\rdbms\XFFwin\XFF\trace\XFF_rfs_1100.trc: ORA-01265: 无法删除 ARCHIVED LOG /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_28/o1_mf_1_192078_l74s4m2l_.arc ORA-27056: 无法删除文件 OSD-04029: 无法获取文件属性 O/S-Error: (OS 3) 系统找不到指定的路径。
尝试人工rman删除日志,报RMAN-06214错误
RMAN-06214: Archivelog /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_29/o1_mf_1_192575_l78zobv0_.arc RMAN-06214: Archivelog /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_29/o1_mf_1_192576_l791fo3j_.arc RMAN-06214: Archivelog /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_29/o1_mf_1_192577_l7935w3d_.arc RMAN-06214: Archivelog /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_29/o1_mf_1_192578_l794y5bc_.arc RMAN-06214: Archivelog /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_29/o1_mf_1_192579_l795cngq_.arc RMAN-06214: Archivelog /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_29/o1_mf_1_192580_l795con4_.arc RMAN-06214: Archivelog /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_29/o1_mf_1_192581_l795jtxk_.arc RMAN-06214: Archivelog /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_29/o1_mf_1_192582_l795k97z_.arc RMAN-06214: Archivelog /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_29/o1_mf_1_192583_l795noy1_.arc RMAN-06214: Archivelog /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_29/o1_mf_1_192584_l795vvjg_.arc RMAN-06214: Archivelog /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_29/o1_mf_1_192585_l796y9o2_.arc RMAN-06214: Archivelog /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_29/o1_mf_1_192586_l798pk99_.arc RMAN-06214: Archivelog /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_29/o1_mf_1_192587_l79bgx33_.arc RMAN-06214: Archivelog /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_29/o1_mf_1_192588_l79bm1wf_.arc RMAN-06214: Archivelog /u01/oracle/fast_recovery_area/XFFDG/archivelog/2023_05_29/o1_mf_1_192589_l79bm2tn_.arc
crosscheck报ORA-19633错
RMAN> CROSSCHECK ARCHIVELOG ALL; 释放的通道: ORA_DISK_1 释放的通道: ORA_DISK_2 释放的通道: ORA_DISK_3 释放的通道: ORA_DISK_4 分配的通道: ORA_DISK_1 通道 ORA_DISK_1: SID=1717 设备类型=DISK 分配的通道: ORA_DISK_2 通道 ORA_DISK_2: SID=13 设备类型=DISK 分配的通道: ORA_DISK_3 通道 ORA_DISK_3: SID=579 设备类型=DISK 分配的通道: ORA_DISK_4 通道 ORA_DISK_4: SID=1148 设备类型=DISK 对归档日志的验证成功 归档日志文件名=D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\XFFWIN\ARCHIVELOG\2023_06_25\O1_MF_1_196451_L9HC90MS_.ARC REC ID=35113 STAMP=1140433431 对归档日志的验证成功 归档日志文件名=D:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\XFFWIN\ARCHIVELOG\2023_06_25\O1_MF_1_196452_L9HC9271_.ARC REC ID=35112 STAMP=1140433425 已交叉检验的 2 对象 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: crosscheck 命令 (ORA_DISK_4 通道上, 在 06/25/2023 11:04:30 上) 失败 ORA-19633: 控制文件记录 30322 与恢复目录不同步
常规方法无法删除归档日志,只能通过dbms包强制删除归档日志
C:\Users\Administrator>sqlplus / as sysdba SQL*Plus: Release 11.2.0.4.0 Production on 星期日 6月 25 11:05:15 2023 Copyright (c) 1982, 2013, Oracle. All rights reserved. 连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> execute sys.dbms_backup_restore.resetCfileSection( 11); PL/SQL 过程已成功完成。
加我QQ
