RMAN-06214

mahan · 发表于 2022-7-27 10:10:53

本帖最后由 mahan 于 2022-7-27 10:22 编辑

环境：linux 7+11g rac +dg

检查备库rman备份脚本日志的时候，发现报错
RMAN-06207: WARNING: 91 objects could not be deleted for DISK channel(s) due
RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Datafile Copy /u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_pacs1.f
RMAN-06214: Backup Piece /app/rman/backup/pacs_PACS_qkvroalp_1_1.bak
RMAN-06214: Backup Piece /app/rman/backup/pacs_PACS_qlvroalp_1_1.bak
RMAN-06214: Backup Piece /app/rman/backup/pacs_PACS_qmvroalp_1_1.bak
RMAN-06214: Backup Piece /app/rman/backup/pacs_PACS_qnvroalp_1_1.bak
RMAN-06214: Backup Piece /app/rman/backup/pacs_PACS_qovroalp_1_1.bak
RMAN-06214: Backup Piece /app/rman/backup/pacs_PACS_qpvroalq_1_1.bak
RMAN-06214: Backup Piece /app/rman/backup/pacs_PACS_qqvroalq_1_1.bak
RMAN-06214: Backup Piece /app/rman/backup/pacs_PACS_qrvroalq_1_1.bak
RMAN-06214: Backup Piece /app/rman/backup/pacs_PACS_qsvroalu_1_1.bak

登录/注册后可看大图

3703362e09d1c869e8.png (124.63 KB, 下载次数: 272)

下载附件

2022-7-27 10:04 上传

解决办法：
$ rman target /
RMAN> crosscheck backup;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=4518 device type=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/app/rman/backup/pacs_PACS_qrvroalq_1_1.bak RECID=741 STAMP=1069296317
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/app/rman/backup/pacs_PACS_qsvroalu_1_1.bak RECID=742 STAMP=1069296318
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/app/rman/backup/pacs_PACS_qmvroalp_1_1.bak RECID=743 STAMP=1069296313
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/app/rman/backup/pacs_PACS_qlvroalp_1_1.bak RECID=744 STAMP=1069296313
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/app/rman/backup/pacs_PACS_qovroalp_1_1.bak RECID=745 STAMP=1069296314
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/app/rman/backup/pacs_PACS_qqvroalq_1_1.bak RECID=746 STAMP=1069296314
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/app/rman/backup/pacs_PACS_qkvroalp_1_1.bak RECID=747 STAMP=1069296313
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/app/rman/backup/pacs_PACS_qpvroalq_1_1.bak RECID=748 STAMP=1069296314
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/app/rman/backup/pacs_PACS_qnvroalp_1_1.bak RECID=749 STAMP=1069296314
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/app/rman/backup/arc_PACS_quvroe0r_1_1.bak RECID=750 STAMP=1069299739

.....................................

RMAN> delete EXPIRED backup;

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status    Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
741    741    1 1 EXPIRED    DISK       /app/rman/backup/pacs_PACS_qrvroalq_1_1.bak
742    742    1 1 EXPIRED    DISK       /app/rman/backup/pacs_PACS_qsvroalu_1_1.bak
743    743    1 1 EXPIRED    DISK       /app/rman/backup/pacs_PACS_qmvroalp_1_1.bak
744    744    1 1 EXPIRED    DISK       /app/rman/backup/pacs_PACS_qlvroalp_1_1.bak
745    745    1 1 EXPIRED    DISK       /app/rman/backup/pacs_PACS_qovroalp_1_1.bak
746    746    1 1 EXPIRED    DISK       /app/rman/backup/pacs_PACS_qqvroalq_1_1.bak
747    747    1 1 EXPIRED    DISK       /app/rman/backup/pacs_PACS_qkvroalp_1_1.bak
748    748    1 1 EXPIRED    DISK       /app/rman/backup/pacs_PACS_qpvroalq_1_1.bak
749    749    1 1 EXPIRED    DISK       /app/rman/backup/pacs_PACS_qnvroalp_1_1.bak
750    750    1 1 EXPIRED    DISK       /app/rman/backup/arc_PACS_quvroe0r_1_1.bak
751    751    1 1 EXPIRED    DISK       /app/rman/backup/arc_PACS_r0vroe0s_1_1.bak
752    752    1 1 EXPIRED    DISK       /app/rman/backup/arc_PACS_qvvroe0r_1_1.bak

......................................

帐号		自动登录	找回密码
密码			注册

[Oracle] RMAN-06214