report need backup redundancy 1 tablespace users;删除"过期"备份

RMAN> report need backup redundancy 1 tablespace users;

Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
4    0     /u01/oracle/oradata/db01/users01.dbf

RMAN> backup tablespace users;

Starting backup at 03-FEB-15
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00004 name=/u01/oracle/oradata/db01/users01.dbf
channel ORA_DISK_1: starting piece 1 at 03-FEB-15
channel ORA_DISK_1: finished piece 1 at 03-FEB-15
piece handle=/u01/oracle/11G/dbs/0vpua7f7_1_1 tag=TAG20150203T001015 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 03-FEB-15

RMAN> report need backup redundancy 1 tablespace users;

Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------

RMAN> exit


Recovery Manager complete.
[oracle@Slave1Hadoop51 ~]$ ls -ltr /u01/oracle/11G/dbs/0vpua7f7_1_1
ls: /u01/oracle/11G/dbs/0vpua7f7_1_1: No such file or directory
[oracle@Slave1Hadoop51 ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Feb 3 00:12:31 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: DB01 (DBID=1467107934)

RMAN> crosscheck backupset of tablespace users;--crosscheck backupset device type disk;初步判断是范围大小的差别,显然前者更精确。

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=139 devtype=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/oracle/11G/dbs/0cpua34n_1_1 recid=12 stamp=870648983
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/oracle/11G/dbs/0tpua572_1_1 recid=29 stamp=870651106
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/oracle/11G/dbs/0upua7c3_1_1 recid=30 stamp=870653315
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/oracle/11G/dbs/0vpua7f7_1_1 recid=31 stamp=870653415
Crosschecked 4 objects


RMAN> report need backup redundancy 1 tablespace users;

Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
4    0     /u01/oracle/oradata/db01/users01.dbf

RMAN> list backupset of tablespace users;


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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12      Full    7.46M      DISK        00:00:01     02-FEB-15      
        BP Key: 12   Status: EXPIRED  Compressed: NO  Tag: TAG20150202T225623
        Piece Name: /u01/oracle/11G/dbs/0cpua34n_1_1
  List of Datafiles in backup set 12
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1351974    02-FEB-15 /u01/oracle/oradata/db01/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
29      Full    7.46M      DISK        00:00:00     02-FEB-15      
        BP Key: 29   Status: EXPIRED  Compressed: NO  Tag: TAG20150202T233146
        Piece Name: /u01/oracle/11G/dbs/0tpua572_1_1
  List of Datafiles in backup set 29
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1353085    02-FEB-15 /u01/oracle/oradata/db01/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
30      Full    7.46M      DISK        00:00:01     03-FEB-15      
        BP Key: 30   Status: EXPIRED  Compressed: NO  Tag: TAG20150203T000835
        Piece Name: /u01/oracle/11G/dbs/0upua7c3_1_1
  List of Datafiles in backup set 30
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1354181    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
31      Full    7.46M      DISK        00:00:01     03-FEB-15      
        BP Key: 31   Status: EXPIRED  Compressed: NO  Tag: TAG20150203T001015
        Piece Name: /u01/oracle/11G/dbs/0vpua7f7_1_1
  List of Datafiles in backup set 31
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1354253    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

RMAN> 

4个过期的备份文件。

RMAN> crosscheck backupset of tablespace users;

using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/oracle/11G/dbs/0cpua34n_1_1 recid=12 stamp=870648983
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/oracle/11G/dbs/0tpua572_1_1 recid=29 stamp=870651106
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/oracle/11G/dbs/0upua7c3_1_1 recid=30 stamp=870653315
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/oracle/11G/dbs/0vpua7f7_1_1 recid=31 stamp=870653415
Crosschecked 4 objects


RMAN> delete noprompt expired backup; 

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
12      12      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0cpua34n_1_1
13      13      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0epua3na_1_1
14      14      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0dpua3na_1_1
15      15      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0fpua3ne_1_1
16      16      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0gpua3nr_1_1
17      17      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0hpua3nr_1_1
18      18      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0ipua3o2_1_1
19      19      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0jpua3u1_1_1
20      20      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0kpua3u1_1_1
21      21      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0lpua3u3_1_1
22      22      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0npua47r_1_1
23      23      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0mpua47r_1_1
24      24      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0opua47v_1_1
25      25      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0ppua4fs_1_1
26      26      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0qpua4fu_1_1
27      27      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0rpua4g1_1_1
28      28      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0spua4g3_1_1
29      29      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0tpua572_1_1
30      30      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0upua7c3_1_1
31      31      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/0vpua7f7_1_1
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0cpua34n_1_1 recid=12 stamp=870648983
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0epua3na_1_1 recid=13 stamp=870649579
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0dpua3na_1_1 recid=14 stamp=870649579
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0fpua3ne_1_1 recid=15 stamp=870649583
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0gpua3nr_1_1 recid=16 stamp=870649595
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0hpua3nr_1_1 recid=17 stamp=870649595
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0ipua3o2_1_1 recid=18 stamp=870649603
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0jpua3u1_1_1 recid=19 stamp=870649794
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0kpua3u1_1_1 recid=20 stamp=870649794
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0lpua3u3_1_1 recid=21 stamp=870649795
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0npua47r_1_1 recid=22 stamp=870650108
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0mpua47r_1_1 recid=23 stamp=870650108
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0opua47v_1_1 recid=24 stamp=870650112
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0ppua4fs_1_1 recid=25 stamp=870650365
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0qpua4fu_1_1 recid=26 stamp=870650367
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0rpua4g1_1_1 recid=27 stamp=870650370
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0spua4g3_1_1 recid=28 stamp=870650372
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0tpua572_1_1 recid=29 stamp=870651106
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0upua7c3_1_1 recid=30 stamp=870653315
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/0vpua7f7_1_1 recid=31 stamp=870653415
Deleted 20 EXPIRED objects


RMAN> crosscheck backupset of tablespace users;

using channel ORA_DISK_1

RMAN> 

再次演示：

RMAN> 

RMAN> 

RMAN> 

RMAN> backup tablespace users;

Starting backup at 03-FEB-15
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00004 name=/u01/oracle/oradata/db01/users01.dbf
channel ORA_DISK_1: starting piece 1 at 03-FEB-15
channel ORA_DISK_1: finished piece 1 at 03-FEB-15
piece handle=/u01/oracle/11G/dbs/10pua8b8_1_1 tag=TAG20150203T002512 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 03-FEB-15

RMAN> list backup of tablespace users;


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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
32      Full    7.46M      DISK        00:00:01     03-FEB-15      
        BP Key: 32   Status: AVAILABLE  Compressed: NO  Tag: TAG20150203T002512
        Piece Name: /u01/oracle/11G/dbs/10pua8b8_1_1
  List of Datafiles in backup set 32
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1354709    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

RMAN> exit


Recovery Manager complete.
[oracle@Slave1Hadoop51 ~]$ ls -ltr /u01/oracle/11G/dbs/10pua8b8_1_1
ls: /u01/oracle/11G/dbs/10pua8b8_1_1: No such file or directory
[oracle@Slave1Hadoop51 ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Feb 3 00:26:17 2015

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: DB01 (DBID=1467107934)

RMAN> report need backup redundancy 1 tablespace users;

using target database control file instead of recovery catalog
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------

RMAN> crosscheck backupset of tablespace users;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=126 devtype=DISK
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/oracle/11G/dbs/10pua8b8_1_1 recid=32 stamp=870654312
Crosschecked 1 objects


RMAN> report need backup redundancy 1 tablespace users;

Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
4    0     /u01/oracle/oradata/db01/users01.dbf

RMAN> list backup of tablespace users;


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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
32      Full    7.46M      DISK        00:00:01     03-FEB-15      
        BP Key: 32   Status: EXPIRED  Compressed: NO  Tag: TAG20150203T002512
        Piece Name: /u01/oracle/11G/dbs/10pua8b8_1_1
  List of Datafiles in backup set 32
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 1354709    03-FEB-15 /u01/oracle/oradata/db01/users01.dbf

RMAN> delete noprompt expired backup of  tablespace users;

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
32      32      1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/10pua8b8_1_1
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/10pua8b8_1_1 recid=32 stamp=870654312
Deleted 1 EXPIRED objects


RMAN> list backup of tablespace users;


RMAN>