暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

RMAN-06213 RMAN-06214: Backup Piece

原创 对方带有病毒 2021-10-20
1623

rman备份的时候发现有如下报错:

RMAN-06207: WARNING: 3 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: Backup Piece /data/oracle/app/product/11.2.0/db/dbs/c-3607516748-20210727-02
RMAN-06214: Backup Piece /data/oracle/app/product/11.2.0/db/dbs/c-3607516748-20210923-00
RMAN-06214: Backup Piece /data/oracle/app/product/11.2.0/db/dbs/c-3607516748-20210923-01

处理:

RMAN> crosscheck backuppiece '/data/oracle/app/product/11.2.0/db/dbs/c-3607516748-20210727-02';

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=116 device type=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/data/oracle/app/product/11.2.0/db/dbs/c-3607516748-20210727-02 RECID=2241 STAMP=1079003876
Crosschecked 1 objects


RMAN> delete backupset 2241;

using channel ORA_DISK_1

List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
2241 2241 1 1 EXPIRED DISK /data/oracle/app/product/11.2.0/db/dbs/c-3607516748-20210727-02

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/data/oracle/app/product/11.2.0/db/dbs/c-3607516748-20210727-02 RECID=2241 STAMP=1079003876
Deleted 1 objects



控制文件报错:

RMAN-06212: Object Type Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Datafile Copy /u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_SID.f.bak


处理:

RMAN> crosscheck controlfilecopy '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_SID.f.bak';

RMAN> delete expired controlfilecopy '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_SID.f.bak';



最后修改时间:2021-12-17 10:39:35
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论