rm手动直接删除oracle的备份片段，用list backup查还显示出来

最新推荐文章于 2021-04-04 23:17:32 发布

5icode.top

最新推荐文章于 2021-04-04 23:17:32 发布

阅读量1k

点赞数

分类专栏： rman 文章标签： crosscheck

本文链接：https://blog.csdn.net/hzdxw/article/details/43371329

版权

rman 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

RMAN> list backup;

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


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
64      Full    6.76M      DISK        00:00:11     01-FEB-15      
        BP Key: 64   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122140
        Piece Name: /home/oracle/nosetdesc/whole_DB01_49pu69il_1_1
  List of Datafiles in backup set 64
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 1729091    01-FEB-15 /u01/oracle/oradata/db01/sysaux01.dbf
  8       Full 1729091    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/undots01.dbf
  11      Full 1729091    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
  13      Full 896185     03-MAR-14 /tmp/local.dbf


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
65      Full    28.46M     DISK        00:00:18     01-FEB-15      
        BP Key: 65   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122140
        Piece Name: /home/oracle/nosetdesc/whole_DB01_47pu69il_1_1
  List of Datafiles in backup set 65
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1729089    01-FEB-15 /u01/oracle/oradata/db01/system01.dbf
  9       Full 1729089    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/frankts2.dbf


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
66      Full    29.34M     DISK        00:00:19     01-FEB-15      
        BP Key: 66   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122140
        Piece Name: /home/oracle/nosetdesc/whole_DB01_48pu69il_1_1
  List of Datafiles in backup set 66
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 1729090    01-FEB-15 /u01/oracle/oradata/db01/undotbs01.dbf
  7       Full 1729090    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/demots01.dbf
  10      Full 819502     23-FEB-14 /u01/oracle/oradata/db01/ts_test_me/bigts01.dbf
  12      Full 846455     24-FEB-14 /u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
67      Full    64.00K     DISK        00:00:01     01-FEB-15      
        BP Key: 67   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122140
        Piece Name: /home/oracle/nosetdesc/whole_DB01_4bpu69j8_1_1
  List of Datafiles in backup set 67
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 392648     22-JAN-14 /tmp/test_block_size.dbf


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
68      Full    4.21M      DISK        00:00:12     01-FEB-15      
        BP Key: 68   Status: AVAILABLE  Compressed: YES  Tag: TAG20150201T122140
        Piece Name: /home/oracle/nosetdesc/whole_DB01_4apu69j7_1_1
  List of Datafiles in backup set 68
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1729098    01-FEB-15 /u01/oracle/oradata/db01/users01.dbf
  6       Full 1729098    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/frankts01.dbf
  18      Full 1718978    29-JAN-15 /u01/test.dbf
  20      Full 1718978    29-JAN-15 /u01/oracle/11G/dbs/f:test.dbf


RMAN>

查看别无给定的备份文件

[oracle@MasterHadoop50 nosetdesc]$ ls
logs
[oracle@MasterHadoop50 nosetdesc]$ ls
logs
[oracle@MasterHadoop50 nosetdesc]$ pwd
/home/oracle/nosetdesc
[oracle@MasterHadoop50 nosetdesc]$ ls
logs
[oracle@MasterHadoop50 nosetdesc]$

crosscheck 之后还是有记录

RMAN> crosscheck backupset of database;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=130 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=135 devtype=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/nosetdesc/whole_DB01_49pu69il_1_1 recid=64 stamp=870524502
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/nosetdesc/whole_DB01_47pu69il_1_1 recid=65 stamp=870524501
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/nosetdesc/whole_DB01_48pu69il_1_1 recid=66 stamp=870524501
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/nosetdesc/whole_DB01_4bpu69j8_1_1 recid=67 stamp=870524520
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/home/oracle/nosetdesc/whole_DB01_4apu69j7_1_1 recid=68 stamp=870524520
Crosschecked 5 objects


RMAN> list backup;


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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
64      Full    6.76M      DISK        00:00:11     01-FEB-15      
        BP Key: 64   Status: EXPIRED  Compressed: YES  Tag: TAG20150201T122140
        Piece Name: /home/oracle/nosetdesc/whole_DB01_49pu69il_1_1
  List of Datafiles in backup set 64
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 1729091    01-FEB-15 /u01/oracle/oradata/db01/sysaux01.dbf
  8       Full 1729091    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/undots01.dbf
  11      Full 1729091    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/dtfilets01.dbf
  13      Full 896185     03-MAR-14 /tmp/local.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
65      Full    28.46M     DISK        00:00:18     01-FEB-15      
        BP Key: 65   Status: EXPIRED  Compressed: YES  Tag: TAG20150201T122140
        Piece Name: /home/oracle/nosetdesc/whole_DB01_47pu69il_1_1
  List of Datafiles in backup set 65
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1729089    01-FEB-15 /u01/oracle/oradata/db01/system01.dbf
  9       Full 1729089    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/frankts2.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
66      Full    29.34M     DISK        00:00:19     01-FEB-15      
        BP Key: 66   Status: EXPIRED  Compressed: YES  Tag: TAG20150201T122140
        Piece Name: /home/oracle/nosetdesc/whole_DB01_48pu69il_1_1
  List of Datafiles in backup set 66
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 1729090    01-FEB-15 /u01/oracle/oradata/db01/undotbs01.dbf
  7       Full 1729090    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/demots01.dbf
  10      Full 819502     23-FEB-14 /u01/oracle/oradata/db01/ts_test_me/bigts01.dbf
  12      Full 846455     24-FEB-14 /u01/oracle/oradata/db01/ts_test_me/dtfilets2.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
67      Full    64.00K     DISK        00:00:01     01-FEB-15      
        BP Key: 67   Status: EXPIRED  Compressed: YES  Tag: TAG20150201T122140
        Piece Name: /home/oracle/nosetdesc/whole_DB01_4bpu69j8_1_1
  List of Datafiles in backup set 67
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 392648     22-JAN-14 /tmp/test_block_size.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
68      Full    4.21M      DISK        00:00:12     01-FEB-15      
        BP Key: 68   Status: EXPIRED  Compressed: YES  Tag: TAG20150201T122140
        Piece Name: /home/oracle/nosetdesc/whole_DB01_4apu69j7_1_1
  List of Datafiles in backup set 68
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1729098    01-FEB-15 /u01/oracle/oradata/db01/users01.dbf
  6       Full 1729098    01-FEB-15 /u01/oracle/oradata/db01/ts_test_me/frankts01.dbf
  18      Full 1718978    29-JAN-15 /u01/test.dbf
  20      Full 1718978    29-JAN-15 /u01/oracle/11G/dbs/f:test.dbf

RMAN>

删除备份信息，再查看就没有了上述的备份信息

RMAN> delete noprompt expired backupset of database;

using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
64      64      1   1   EXPIRED     DISK        /home/oracle/nosetdesc/whole_DB01_49pu69il_1_1
65      65      1   1   EXPIRED     DISK        /home/oracle/nosetdesc/whole_DB01_47pu69il_1_1
66      66      1   1   EXPIRED     DISK        /home/oracle/nosetdesc/whole_DB01_48pu69il_1_1
67      67      1   1   EXPIRED     DISK        /home/oracle/nosetdesc/whole_DB01_4bpu69j8_1_1
68      68      1   1   EXPIRED     DISK        /home/oracle/nosetdesc/whole_DB01_4apu69j7_1_1
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_49pu69il_1_1 recid=64 stamp=870524502
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_47pu69il_1_1 recid=65 stamp=870524501
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_48pu69il_1_1 recid=66 stamp=870524501
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_4bpu69j8_1_1 recid=67 stamp=870524520
deleted backup piece
backup piece handle=/home/oracle/nosetdesc/whole_DB01_4apu69j7_1_1 recid=68 stamp=870524520
Deleted 5 EXPIRED objects


RMAN> list backup;


RMAN>

5icode.top

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
rm手动直接删除oracle的备份片段，用list backup查还显示出来

RMAN> list backup;List of Backup Sets===================BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ ---------------64
复制链接

扫一扫

专栏目录