RMAN管理备份
--RMAN使用2，管理备份
--删除备份集：
--1.查看备份集
RMAN> list backupset 7;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7 Full 1.87M DISK 00:00:01 12-JUN-13
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20130612T150858
Piece Name: /home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/backupset/2013_06_12/o1_mf_nnndf_TAG20130612T150858_8vj7nbbq_.bkp
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
6 Full 13229464115969 12-JUN-13 /home/oracle/oracle/product/10.2.0/db_1/dbs/TBS_ORCL_IDX01.DBF
--2.删除第七个备份集：
RMAN> delete backupset 7;
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
7 7 1 1 AVAILABLE DISK /home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/backupset/2013_06_12/o1_mf_nnndf_TAG20130612T150858_8vj7nbbq_.bkp
Do you really want to delete the above objects (enter YES or NO) YES
deleted backup piece
backup piece handle=/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/backupset/2013_06_12/o1_mf_nnndf_TAG20130612T150858_8vj7nbbq_.bkp recid=7 stamp=817916938
Deleted 1 objects
--查看未备份的归档日志：
RMAN> list archivelog all;
specification does not match any archive log in the recovery catalog
--查看已经备份的归档日志：
RMAN> list backup of archivelog all;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
4 1.47G DISK 00:03:18 12-JUN-13
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20130612T144846
Piece Name: /home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/backupset/2013_06_12/o1_mf_annnn_TAG20130612T144846_8vj6glv9_.bkp
List of Archived Logs in backup set 4
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 72 790665 04-DEC-12 13054440590919 10-DEC-12
1 73 13054440590919 10-DEC-12 13054440616655 12-DEC-12
1 74 13054440616655 12-DEC-12 13054440642210 16-DEC-12
1 75 13054440642210 16-DEC-12 13054440650662 16-DEC-12
1 76 13054440650662 16-DEC-12 13054440651406 16-DEC-12
1 77 13054440651406 16-DEC-12 13054440652044 16-DEC-12
1 78 13054440652044 16-DEC-12 13054440652666 16-DEC-12
1 79 13054440652666 16-DEC-12 13054440653806 16-DEC-12
1 80 13054440653806 16-DEC-12 13054440654435 16-DEC-12
1 81 13054440654435 16-DEC-12 13054440655089 16-DEC-12
1 82 13054440655089 16-DEC-12 13054440655737 16-DEC-12
1 83 13054440655737 16-DEC-12 13054440656499 16-DEC-12
1 84 13054440656499 16-DEC-12 13054440657129 16-DEC-12
1 85 13054440657129 16-DEC-12 13054440658099 16-DEC-12
1 86 13054440658099 16-DEC-12 13054440658339 16-DEC-12
1 87 13054440658339 16-DEC-12 13054440658574 16-DEC-12
1 88 13054440658574 16-DEC-12 13054440660313 22-DEC-12
1 89