0 积分	1 好友	1 主题

发消息

[物理/逻辑坏块] 手动删除备份文件，rman中如何delete掉

1^#

发表于 2013-9-11 11:32:18 | 查看: 9010| 回复: 6

各位高手，在测试rman的时候，遇到一个问题，希望不惜赐教！

os版本：RHEL6.1
oracle版本：11.2.0.3.0
单机环境

利用rman测试时候:
由于在系统层面执行了删除操作，命令如下：
#cd /oradata/backup
#rm -rf bak_0aojh5d8_1_1
#rm -rf bak_0bojh5ft_1_1

RMAN> list backup；

List of Backup Sets
===================

BS Key  Type LV Size    Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6    Full 979.57M DISK       00:01:23    10-SEP-13
      BP Key: 6 Status: AVAILABLE  Compressed: NO  Tag: TAG20130910T183832
      Piece Name: /oradata/backup/bak_0aojh5d8_1_1
  List of Datafiles in backup set 6
  File LV Type Ckp SCN Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    Full 1133254 10-SEP-13 /opt/oracle/oradata/portaldb/system01.dbf
  2    Full 1133254 10-SEP-13 /opt/oracle/oradata/portaldb/sysaux01.dbf
  3    Full 1133254 10-SEP-13 /opt/oracle/oradata/portaldb/undotbs01.dbf
  4    Full 1133254 10-SEP-13 /opt/oracle/oradata/portaldb/users01.dbf
  5    Full 1133254 10-SEP-13 /oradata/portaldb_ICMLFQ32_01.dbf
  6    Full 1133254 10-SEP-13 /oradata/portaldb_ICMLNF32_01.dbf
  7    Full 1133254 10-SEP-13 /oradata/portaldb_ICMSFQ04_01.dbf
  8    Full 1133254 10-SEP-13 /oradata/portaldb_ICMVFQ04_01.dbf
  9    Full 1133254 10-SEP-13 /oradata/portaldb_ICMLSNDX_01.dbf

BS Key  Type LV Size    Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7    Full 9.36M    DISK       00:00:01    10-SEP-13
      BP Key: 7 Status: AVAILABLE  Compressed: NO  Tag: TAG20130910T183832
      Piece Name: /oradata/backup/bak_0bojh5ft_1_1
  SPFILE Included: Modification time: 10-SEP-13
  SPFILE db_unique_name: PORTALDB
  Control File Included: Ckp SCN: 1133289    Ckp time: 10-SEP-13

希望解决的问题：目前想删除list backup显示的备份文件，请问应该有什么解决方案？

分享0

收藏0 回复只看该作者道具举报

haoge7777

2^#

发表于 2013-9-11 11:39:39

delete backup

回复只看该作者道具举报

hbhe0316

3^#

发表于 2013-9-11 11:41:38

haoge7777 发表于 2013-9-11 11:39
delete backup

RMAN> delete backup;

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status    Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
6    6    1 1 AVAILABLE DISK       /oradata/backup/bak_0aojh5d8_1_1
7    7    1 1 AVAILABLE DISK       /oradata/backup/bak_0bojh5ft_1_1

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

RMAN-06207: WARNING: 2 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 /oradata/backup/bak_0aojh5d8_1_1
RMAN-06214: Backup Piece /oradata/backup/bak_0bojh5ft_1_1

回复只看该作者道具举报

hbhe0316

4^#

发表于 2013-9-11 11:42:35

haoge7777 发表于 2013-9-11 11:39
delete backup

您好，我事先删除了/oradata/backup/bak_0aojh5d8_1_1和/oradata/backup/bak_0bojh5ft_1_1，所有delete backup；不行，谢谢您的回复。

回复只看该作者道具举报

haoge7777

5^#

发表于 2013-9-11 12:01:25

crosscheck backup;
delete backu;

回复只看该作者道具举报

hbhe0316

6^#

发表于 2013-9-11 12:32:59

haoge7777 发表于 2013-9-11 12:01
crosscheck backup;
delete backu;

RMAN> crosscheck backup;

using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/oradata/backup/bak_0aojh5d8_1_1 RECID=6 STAMP=825791912
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/oradata/backup/bak_0bojh5ft_1_1 RECID=7 STAMP=825791998
Crosschecked 2 objects

RMAN> delete expired backup;

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status    Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
6    6    1 1 EXPIRED    DISK       /oradata/backup/bak_0aojh5d8_1_1
7    7    1 1 EXPIRED    DISK       /oradata/backup/bak_0bojh5ft_1_1

Do you really want to delete the above objects (enter YES or NO)? y
deleted backup piece
backup piece handle=/oradata/backup/bak_0aojh5d8_1_1 RECID=6 STAMP=825791912
deleted backup piece
backup piece handle=/oradata/backup/bak_0bojh5ft_1_1 RECID=7 STAMP=825791998
Deleted 2 EXPIRED objects

RMAN> list backup;

specification does not match any backup in the repository

问题解决了，谢谢你的帮助。

回复只看该作者道具举报

hbhe0316

7^#

发表于 2013-9-11 12:45:00

总结一下，请各位大神勿见笑：利用crosscheck命令检测备份或归档物理文件的状态，如果物理文件存在，并且控制文件中有匹配记录，则标记该对象为available，如果不存在，则标记为expired(无效)，本问题先标记两个无效的备份文件，然后删除无效的备份文件。

感谢haoge7777兄的支持

回复只看该作者道具举报

返回列表

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