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>