说说RMAN里的obsolete

时间:2020-12-04 19:03:46

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
no obsolete backups found

RMAN> backup datafile 1;

Starting backup at 29-MAY-14
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=00001 name=/u01/app/oracle/oradata/prod/system01.dbf
channel ORA_DISK_1: starting piece 1 at 29-MAY-14
channel ORA_DISK_1: finished piece 1 at 29-MAY-14
piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/amp9g8sf_1_1 tag=TAG20140529T102934 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 29-MAY-14

Starting Control File and SPFILE Autobackup at 29-MAY-14
piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-00 comment=NONE
Finished Control File and SPFILE Autobackup at 29-MAY-14

RMAN> list backup of datafile 1;

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
504     Full    391.63M    DISK        00:00:23     29-MAY-14      
        BP Key: 504   Status: AVAILABLE  Compressed: NO  Tag: TAG20140529T102934
        Piece Name: /u01/app/oracle/product/10.2.0/db_1/dbs/amp9g8sf_1_1
  List of Datafiles in backup set 504
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1588933    29-MAY-14 /u01/app/oracle/oradata/prod/system01.dbf

RMAN> backup datafile 1;

Starting backup at 29-MAY-14
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=00001 name=/u01/app/oracle/oradata/prod/system01.dbf
channel ORA_DISK_1: starting piece 1 at 29-MAY-14
channel ORA_DISK_1: finished piece 1 at 29-MAY-14
piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/aop9g8u0_1_1 tag=TAG20140529T103024 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
Finished backup at 29-MAY-14

Starting Control File and SPFILE Autobackup at 29-MAY-14
piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-01 comment=NONE
Finished Control File and SPFILE Autobackup at 29-MAY-14

RMAN> list backup of datafile 1;

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
504     Full    391.63M    DISK        00:00:23     29-MAY-14      
        BP Key: 504   Status: AVAILABLE  Compressed: NO  Tag: TAG20140529T102934
        Piece Name: /u01/app/oracle/product/10.2.0/db_1/dbs/amp9g8sf_1_1
  List of Datafiles in backup set 504
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1588933    29-MAY-14 /u01/app/oracle/oradata/prod/system01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
506     Full    391.63M    DISK        00:00:27     29-MAY-14      
        BP Key: 506   Status: AVAILABLE  Compressed: NO  Tag: TAG20140529T103024
        Piece Name: /u01/app/oracle/product/10.2.0/db_1/dbs/aop9g8u0_1_1
  List of Datafiles in backup set 506
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1588970    29-MAY-14 /u01/app/oracle/oradata/prod/system01.dbf

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           503    17-MAR-14         
  Backup Piece       503    17-MAR-14          /u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140317-0b
Backup Set           504    29-MAY-14         
  Backup Piece       504    29-MAY-14          /u01/app/oracle/product/10.2.0/db_1/dbs/amp9g8sf_1_1
Backup Set           505    29-MAY-14         
  Backup Piece       505    29-MAY-14          /u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-00

RMAN> backup datafile 1;

Starting backup at 29-MAY-14
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=00001 name=/u01/app/oracle/oradata/prod/system01.dbf
channel ORA_DISK_1: starting piece 1 at 29-MAY-14
channel ORA_DISK_1: finished piece 1 at 29-MAY-14
piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/aqp9g90p_1_1 tag=TAG20140529T103153 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26
Finished backup at 29-MAY-14

Starting Control File and SPFILE Autobackup at 29-MAY-14
piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-02 comment=NONE
Finished Control File and SPFILE Autobackup at 29-MAY-14

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           503    17-MAR-14         
  Backup Piece       503    17-MAR-14          /u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140317-0b
Backup Set           504    29-MAY-14         
  Backup Piece       504    29-MAY-14          /u01/app/oracle/product/10.2.0/db_1/dbs/amp9g8sf_1_1
Backup Set           505    29-MAY-14         
  Backup Piece       505    29-MAY-14          /u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-00
Backup Set           506    29-MAY-14         
  Backup Piece       506    29-MAY-14          /u01/app/oracle/product/10.2.0/db_1/dbs/aop9g8u0_1_1
Backup Set           507    29-MAY-14         
  Backup Piece       507    29-MAY-14          /u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-01