RAC环境下RMAN-06214

来源：互联网发布：淘宝网店注册编辑：程序博客网时间：2024/06/05 21:49

关于rac下rman全备删除问题

RMAN> delete backupset;

using channel ORA_DISK_1

List of Backup Pieces

BP Key BS Key Pc# Cp# Status Device Type Piece Name

------- ------- --- --- ---------------------- ----------

13 13 1 1 AVAILABLE DISK /u01/oracle/product/10.2.0/db_1/dbs/0moeao27_1_1

14 14 1 1 AVAILABLE DISK /u01/oracle/product/10.2.0/db_1/dbs/0noeao28_1_1

Do you really want to delete the aboveobjects (enter YES or NO)? y

RMAN-06207: WARNING: 2 objects could not bedeleted 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 /u01/oracle/product/10.2.0/db_1/dbs/0moeao27_1_1

RMAN-06214: Backup Piece /u01/oracle/product/10.2.0/db_1/dbs/0noeao28_1_1

删除删不掉

RMAN> crosscheck backup;

using channel ORA_DISK_1

crosschecked backup piece: found to be'EXPIRED'

backup piecehandle=/u01/oracle/product/10.2.0/db_1/dbs/0moeao27_1_1 recid=13stamp=820338759

crosschecked backup piece: found to be'EXPIRED'

backup piecehandle=/u01/oracle/product/10.2.0/db_1/dbs/0noeao28_1_1 recid=14stamp=820338761

Crosschecked 2 objects

使用crosscheck检查下

RMAN> crosscheck backuppiece'/u01/oracle/product/10.2.0/db_1/dbs/0moeao27_1_1';

using channel ORA_DISK_1

crosschecked backup piece: found to be'EXPIRED'

backup piecehandle=/u01/oracle/product/10.2.0/db_1/dbs/0moeao27_1_1 recid=13stamp=820338759

Crosschecked 1 objects

就可以删除

RMAN> delete backupset 13;

using channel ORA_DISK_1

List of Backup Pieces

BP Key BS Key Pc# Cp# Status Device Type Piece Name

------- ------- --- --- ---------------------- ----------

13 13 1 1 EXPIRED DISK /u01/oracle/product/10.2.0/db_1/dbs/0moeao27_1_1

Do you really want to delete the aboveobjects (enter YES or NO)? y

deleted backup piece

backup piecehandle=/u01/oracle/product/10.2.0/db_1/dbs/0moeao27_1_1 recid=13stamp=820338759

Deleted 1 objects

RMAN> crosscheck backuppiece'/u01/oracle/product/10.2.0/db_1/dbs/0noeao28_1_1';

using channel ORA_DISK_1

crosschecked backup piece: found to be'EXPIRED'

backup piecehandle=/u01/oracle/product/10.2.0/db_1/dbs/0noeao28_1_1 recid=14stamp=820338761

Crosschecked 1 objects

RMAN> delete backupset 14;

using channel ORA_DISK_1

List of Backup Pieces

BP Key BS Key Pc# Cp# Status Device Type Piece Name

------- ------- --- --- ---------------------- ----------

14 14 1 1 EXPIRED DISK /u01/oracle/product/10.2.0/db_1/dbs/0noeao28_1_1

Do you really want to delete the aboveobjects (enter YES or NO)? y

deleted backup piece

backup piecehandle=/u01/oracle/product/10.2.0/db_1/dbs/0noeao28_1_1 recid=14stamp=820338761

Deleted 1 objects

查看没有内容

RMAN> list backupset;

RMAN>