说说RMAN里的obsolete

mac2022-06-30  98

RMAN> report obsolete;RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 1no obsolete backups foundRMAN> backup datafile 1;Starting backup at 29-MAY-14using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=/u01/app/oracle/oradata/prod/system01.dbfchannel ORA_DISK_1: starting piece 1 at 29-MAY-14channel ORA_DISK_1: finished piece 1 at 29-MAY-14piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/amp9g8sf_1_1 tag=TAG20140529T102934 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:25Finished backup at 29-MAY-14Starting Control File and SPFILE Autobackup at 29-MAY-14piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-00 comment=NONEFinished Control File and SPFILE Autobackup at 29-MAY-14RMAN> 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.dbfRMAN> backup datafile 1;Starting backup at 29-MAY-14using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=/u01/app/oracle/oradata/prod/system01.dbfchannel ORA_DISK_1: starting piece 1 at 29-MAY-14channel ORA_DISK_1: finished piece 1 at 29-MAY-14piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/aop9g8u0_1_1 tag=TAG20140529T103024 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:35Finished backup at 29-MAY-14Starting Control File and SPFILE Autobackup at 29-MAY-14piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-01 comment=NONEFinished Control File and SPFILE Autobackup at 29-MAY-14RMAN> 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.dbfBS 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.dbfRMAN> report obsolete;RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 1Report of obsolete backups and copiesType                 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-0bBackup Set           504    29-MAY-14           Backup Piece       504    29-MAY-14          /u01/app/oracle/product/10.2.0/db_1/dbs/amp9g8sf_1_1Backup Set           505    29-MAY-14           Backup Piece       505    29-MAY-14          /u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-00RMAN> backup datafile 1;Starting backup at 29-MAY-14using channel ORA_DISK_1channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=00001 name=/u01/app/oracle/oradata/prod/system01.dbfchannel ORA_DISK_1: starting piece 1 at 29-MAY-14channel ORA_DISK_1: finished piece 1 at 29-MAY-14piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/aqp9g90p_1_1 tag=TAG20140529T103153 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:26Finished backup at 29-MAY-14Starting Control File and SPFILE Autobackup at 29-MAY-14piece handle=/u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-02 comment=NONEFinished Control File and SPFILE Autobackup at 29-MAY-14RMAN> report obsolete;RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 1Report of obsolete backups and copiesType                 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-0bBackup Set           504    29-MAY-14           Backup Piece       504    29-MAY-14          /u01/app/oracle/product/10.2.0/db_1/dbs/amp9g8sf_1_1Backup Set           505    29-MAY-14           Backup Piece       505    29-MAY-14          /u01/app/oracle/product/10.2.0/db_1/dbs/c-248862348-20140529-00Backup Set           506    29-MAY-14           Backup Piece       506    29-MAY-14          /u01/app/oracle/product/10.2.0/db_1/dbs/aop9g8u0_1_1Backup 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

转载于:https://www.cnblogs.com/iyoume2008/p/4690616.html

最新回复(0)