CROSSCHECK 交叉检查校验备份信息
crosscheck backup;校验所有备份集;
[oracle@centos ~]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Sun Apr 2 20:15:57 2017 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: CENTOS (DBID=3235228290) RMAN> crosscheck backup; using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=35 device type=DISK crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/home/oracle/bak/con_01rvukk4_1_1.bak RECID=1 STAMP=939479685 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/home/oracle/bak/con_1.bak RECID=2 STAMP=939479806 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/home/oracle/bak/full.bak RECID=3 STAMP=939479870 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/backupset/2017_03_24/o1_mf_nnndf_TAG20170324T143752_df9hp086_.bkp RECID=4 STAMP=939479872 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/backupset/2017_03_24/o1_mf_ncsnf_TAG20170324T143752_df9hpjdz_.bkp RECID=5 STAMP=939479888 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/home/oracle/bak/full_07rvuktf_1_1.bak RECID=6 STAMP=939479983 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/backupset/2017_03_24/o1_mf_ncsnf_TAG20170324T143944_df9hss4z_.bkp RECID=7 STAMP=939479993 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/home/oracle/control_bak/con_2.bak RECID=8 STAMP=939740157 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_03_27/o1_mf_s_939740158_dfkfvyr0_.bkp RECID=9 STAMP=939740158 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/flash/centos_db0gs06kuf_1_1.rman RECID=10 STAMP=939742159 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/flash/centos_db0hs06kuh_1_1.rman RECID=11 STAMP=939742161 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/flash/centos_db0is06kui_1_1.rman RECID=12 STAMP=939742162 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/flash/centos_db0js06kuj_1_1.rman RECID=13 STAMP=939742163 crosschecked backup piece: found to be 'EXPIRED' backup piece handle=/u01/app/oracle/flash/centos_db0ks06kuq_1_1.rman RECID=14 STAMP=939742171 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_03_27/o1_mf_s_939741898_dfkhtwsg_.bkp RECID=15 STAMP=939742172 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/centos_db0ms06tel_1_1.rman RECID=16 STAMP=939750869 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_03_27/o1_mf_s_939750787_dfkrbx6g_.bkp RECID=17 STAMP=939750877 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/centos_db0rs0mqgr_1_1.rman RECID=18 STAMP=940272155 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_04_02/o1_mf_s_940272000_dg1of2br_.bkp RECID=19 STAMP=940272162 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/centos_db0ts0mr3v_1_1.rman RECID=20 STAMP=940272767 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_04_02/o1_mf_s_940272000_dg1p073l_.bkp RECID=21 STAMP=940272775 Crosschecked 21 objects RMAN>
crosscheck backup of database;校验所有数据文件的备份集;
RMAN> crosscheck backup of database; using channel ORA_DISK_1 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/backupset/2017_03_24/o1_mf_nnndf_TAG20170324T143752_df9hp086_.bkp RECID=4 STAMP=939479872 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/centos_db0ms06tel_1_1.rman RECID=16 STAMP=939750869 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/centos_db0rs0mqgr_1_1.rman RECID=18 STAMP=940272155 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/centos_db0ts0mr3v_1_1.rman RECID=20 STAMP=940272767 Crosschecked 4 objects RMAN>
crosscheck backup of tablespace users;校验特定表空间的备份集;
RMAN> crosscheck backup of tablespace users; using channel ORA_DISK_1 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/backupset/2017_03_24/o1_mf_nnndf_TAG20170324T143752_df9hp086_.bkp RECID=4 STAMP=939479872 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/centos_db0ms06tel_1_1.rman RECID=16 STAMP=939750869 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/centos_db0rs0mqgr_1_1.rman RECID=18 STAMP=940272155 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/centos_db0ts0mr3v_1_1.rman RECID=20 STAMP=940272767 Crosschecked 4 objects RMAN>
crosscheck backup of datafile 4;校验特定数据文件的备份集;
RMAN> crosscheck backup of datafile 4; using channel ORA_DISK_1 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/backupset/2017_03_24/o1_mf_nnndf_TAG20170324T143752_df9hp086_.bkp RECID=4 STAMP=939479872 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/centos_db0ms06tel_1_1.rman RECID=16 STAMP=939750869 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/centos_db0rs0mqgr_1_1.rman RECID=18 STAMP=940272155 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/centos_db0ts0mr3v_1_1.rman RECID=20 STAMP=940272767 Crosschecked 4 objects RMAN>
crosscheck backup of controlfile;校验控制文件的备份集;
RMAN> crosscheck backup of controlfile; using channel ORA_DISK_1 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/backupset/2017_03_24/o1_mf_ncsnf_TAG20170324T143752_df9hpjdz_.bkp RECID=5 STAMP=939479888 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/backupset/2017_03_24/o1_mf_ncsnf_TAG20170324T143944_df9hss4z_.bkp RECID=7 STAMP=939479993 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/home/oracle/control_bak/con_2.bak RECID=8 STAMP=939740157 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_03_27/o1_mf_s_939740158_dfkfvyr0_.bkp RECID=9 STAMP=939740158 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_03_27/o1_mf_s_939741898_dfkhtwsg_.bkp RECID=15 STAMP=939742172 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_03_27/o1_mf_s_939750787_dfkrbx6g_.bkp RECID=17 STAMP=939750877 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_04_02/o1_mf_s_940272000_dg1of2br_.bkp RECID=19 STAMP=940272162 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_04_02/o1_mf_s_940272000_dg1p073l_.bkp RECID=21 STAMP=940272775 Crosschecked 8 objects RMAN>
crosscheck backup of spfile;校验参数文件spfile的备份集;
RMAN> crosscheck backup of spfile; using channel ORA_DISK_1 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/backupset/2017_03_24/o1_mf_ncsnf_TAG20170324T143752_df9hpjdz_.bkp RECID=5 STAMP=939479888 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/backupset/2017_03_24/o1_mf_ncsnf_TAG20170324T143944_df9hss4z_.bkp RECID=7 STAMP=939479993 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_03_27/o1_mf_s_939740158_dfkfvyr0_.bkp RECID=9 STAMP=939740158 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_03_27/o1_mf_s_939741898_dfkhtwsg_.bkp RECID=15 STAMP=939742172 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_03_27/o1_mf_s_939750787_dfkrbx6g_.bkp RECID=17 STAMP=939750877 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_04_02/o1_mf_s_940272000_dg1of2br_.bkp RECID=19 STAMP=940272162 crosschecked backup piece: found to be 'AVAILABLE' backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_04_02/o1_mf_s_940272000_dg1p073l_.bkp RECID=21 STAMP=940272775 Crosschecked 7 objects RMAN>
crosscheck backup of archivelog sequence 3;校验归档日志的备份集;
RMAN> crosscheck backup of archivelog sequence 3; using channel ORA_DISK_1 specification does not match any backup in the repository RMAN>
crosscheck copy;校验所有映像副本;
RMAN> crosscheck copy; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=35 device type=DISK specification does not match any datafile copy in the repository specification does not match any control file copy in the repository validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_11_df9hoyh5_.arc RECID=2 STAMP=939479870 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_12_df9s5gn4_.arc RECID=14 STAMP=939489582 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_12_df9hpkh9_.arc RECID=3 STAMP=939479889 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_13_df9s5gl5_.arc RECID=12 STAMP=939489582 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_13_df9hshn7_.arc RECID=4 STAMP=939479983 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_14_df9s5gm3_.arc RECID=13 STAMP=939489582 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_25/o1_mf_1_1_dfddpw8t_.arc RECID=19 STAMP=939575132 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_25/o1_mf_1_1_dfd7jh1d_.arc RECID=15 STAMP=939569807 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_25/o1_mf_1_2_dfddpwg9_.arc RECID=20 STAMP=939575132 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_26/o1_mf_1_1_dfghcxwg_.arc RECID=21 STAMP=939643390 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_27/o1_mf_1_2_dfk4lr16_.arc RECID=22 STAMP=939730648 Crosschecked 11 objects RMAN>
crosscheck copy of database;校验所有数据文件的映像副本;
RMAN> crosscheck copy of database; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=35 device type=DISK specification does not match any datafile copy in the repository RMAN>
crosscheck copy of tablespace users;校验特定表空间的映像副本;
RMAN> crosscheck copy of tablespace users; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=35 device type=DISK specification does not match any datafile copy in the repository RMAN>
crosscheck copy of datafile 6;校验特定数据文件的映像副本;
RMAN> crosscheck copy of datafile 6; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=35 device type=DISK specification does not match any datafile copy in the repository RMAN>
crosscheck copy of archivelog sequence 4;校验归档日志的映像副本;
crosscheck copy of archivelog all;校验所有归档;
RMAN> crosscheck copy of archivelog sequence 4; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=35 device type=DISK specification does not match any archived log in the repository RMAN> crosscheck archivelog all; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=35 device type=DISK validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_11_df9hoyh5_.arc RECID=2 STAMP=939479870 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_12_df9s5gn4_.arc RECID=14 STAMP=939489582 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_12_df9hpkh9_.arc RECID=3 STAMP=939479889 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_13_df9s5gl5_.arc RECID=12 STAMP=939489582 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_13_df9hshn7_.arc RECID=4 STAMP=939479983 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_14_df9s5gm3_.arc RECID=13 STAMP=939489582 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_25/o1_mf_1_1_dfddpw8t_.arc RECID=19 STAMP=939575132 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_25/o1_mf_1_1_dfd7jh1d_.arc RECID=15 STAMP=939569807 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_25/o1_mf_1_2_dfddpwg9_.arc RECID=20 STAMP=939575132 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_26/o1_mf_1_1_dfghcxwg_.arc RECID=21 STAMP=939643390 validation succeeded for archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_27/o1_mf_1_2_dfk4lr16_.arc RECID=22 STAMP=939730648 Crosschecked 11 objects RMAN>
crosscheck copy of controlfile;校验控制文件的映像副本;
RMAN> crosscheck copy of controlfile; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=35 device type=DISK specification does not match any control file copy in the repository RMAN>
DELETE删除指定备份
delete obsolete;删除过时备份(超出备份策略的备份)
RMAN> delete obsolete; RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 using channel ORA_DISK_1 Deleting the following obsolete backups and copies: Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Archive Log 2 24-MAR-17 /u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_11_df9hoyh5_.arc Backup Set 4 24-MAR-17 Backup Piece 4 24-MAR-17 /u01/app/oracle/flash/CENTOS/backupset/2017_03_24/o1_mf_nnndf_TAG20170324T143752_df9hp086_.bkp Archive Log 3 24-MAR-17 /u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_12_df9hpkh9_.arc Backup Set 5 24-MAR-17 Backup Piece 5 24-MAR-17 /u01/app/oracle/flash/CENTOS/backupset/2017_03_24/o1_mf_ncsnf_TAG20170324T143752_df9hpjdz_.bkp Archive Log 4 24-MAR-17 /u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_13_df9hshn7_.arc Archive Log 5 24-MAR-17 /u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_14_df9ljnv2_.arc Backup Set 7 24-MAR-17 Backup Piece 7 24-MAR-17 /u01/app/oracle/flash/CENTOS/backupset/2017_03_24/o1_mf_ncsnf_TAG20170324T143944_df9hss4z_.bkp Archive Log 12 24-MAR-17 /u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_13_df9s5gl5_.arc Archive Log 14 24-MAR-17 /u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_12_df9s5gn4_.arc Archive Log 13 24-MAR-17 /u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_14_df9s5gm3_.arc Archive Log 15 25-MAR-17 /u01/app/oracle/flash/CENTOS/archivelog/2017_03_25/o1_mf_1_1_dfd7jh1d_.arc Archive Log 20 25-MAR-17 /u01/app/oracle/flash/CENTOS/archivelog/2017_03_25/o1_mf_1_2_dfddpwg9_.arc Archive Log 19 25-MAR-17 /u01/app/oracle/flash/CENTOS/archivelog/2017_03_25/o1_mf_1_1_dfddpw8t_.arc Archive Log 21 26-MAR-17 /u01/app/oracle/flash/CENTOS/archivelog/2017_03_26/o1_mf_1_1_dfghcxwg_.arc Archive Log 22 27-MAR-17 /u01/app/oracle/flash/CENTOS/archivelog/2017_03_27/o1_mf_1_2_dfk4lr16_.arc Backup Set 8 27-MAR-17 Backup Piece 8 27-MAR-17 /home/oracle/control_bak/con_2.bak Backup Set 9 27-MAR-17 Backup Piece 9 27-MAR-17 /u01/app/oracle/flash/CENTOS/autobackup/2017_03_27/o1_mf_s_939740158_dfkfvyr0_.bkp Backup Set 15 27-MAR-17 Backup Piece 15 27-MAR-17 /u01/app/oracle/flash/CENTOS/autobackup/2017_03_27/o1_mf_s_939741898_dfkhtwsg_.bkp Backup Set 16 27-MAR-17 Backup Piece 16 27-MAR-17 /u01/app/oracle/flash/centos_db0ms06tel_1_1.rman Backup Set 17 27-MAR-17 Backup Piece 17 27-MAR-17 /u01/app/oracle/flash/CENTOS/autobackup/2017_03_27/o1_mf_s_939750787_dfkrbx6g_.bkp Backup Set 18 02-APR-17 Backup Piece 18 02-APR-17 /u01/app/oracle/flash/centos_db0rs0mqgr_1_1.rman Backup Set 19 02-APR-17 Backup Piece 19 02-APR-17 /u01/app/oracle/flash/CENTOS/autobackup/2017_04_02/o1_mf_s_940272000_dg1of2br_.bkp Do you really want to delete the above objects (enter YES or NO)? y deleted archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_11_df9hoyh5_.arc RECID=2 STAMP=939479870 deleted backup piece backup piece handle=/u01/app/oracle/flash/CENTOS/backupset/2017_03_24/o1_mf_nnndf_TAG20170324T143752_df9hp086_.bkp RECID=4 STAMP=939479872 deleted archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_12_df9hpkh9_.arc RECID=3 STAMP=939479889 deleted backup piece backup piece handle=/u01/app/oracle/flash/CENTOS/backupset/2017_03_24/o1_mf_ncsnf_TAG20170324T143752_df9hpjdz_.bkp RECID=5 STAMP=939479888 deleted archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_13_df9hshn7_.arc RECID=4 STAMP=939479983 deleted archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_14_df9ljnv2_.arc RECID=5 STAMP=939488842 deleted backup piece backup piece handle=/u01/app/oracle/flash/CENTOS/backupset/2017_03_24/o1_mf_ncsnf_TAG20170324T143944_df9hss4z_.bkp RECID=7 STAMP=939479993 deleted archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_13_df9s5gl5_.arc RECID=12 STAMP=939489582 deleted archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_12_df9s5gn4_.arc RECID=14 STAMP=939489582 deleted archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_24/o1_mf_1_14_df9s5gm3_.arc RECID=13 STAMP=939489582 deleted archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_25/o1_mf_1_1_dfd7jh1d_.arc RECID=15 STAMP=939569807 deleted archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_25/o1_mf_1_2_dfddpwg9_.arc RECID=20 STAMP=939575132 deleted archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_25/o1_mf_1_1_dfddpw8t_.arc RECID=19 STAMP=939575132 deleted archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_26/o1_mf_1_1_dfghcxwg_.arc RECID=21 STAMP=939643390 deleted archived log archived log file name=/u01/app/oracle/flash/CENTOS/archivelog/2017_03_27/o1_mf_1_2_dfk4lr16_.arc RECID=22 STAMP=939730648 deleted backup piece backup piece handle=/home/oracle/control_bak/con_2.bak RECID=8 STAMP=939740157 deleted backup piece backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_03_27/o1_mf_s_939740158_dfkfvyr0_.bkp RECID=9 STAMP=939740158 deleted backup piece backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_03_27/o1_mf_s_939741898_dfkhtwsg_.bkp RECID=15 STAMP=939742172 deleted backup piece backup piece handle=/u01/app/oracle/flash/centos_db0ms06tel_1_1.rman RECID=16 STAMP=939750869 deleted backup piece backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_03_27/o1_mf_s_939750787_dfkrbx6g_.bkp RECID=17 STAMP=939750877 deleted backup piece backup piece handle=/u01/app/oracle/flash/centos_db0rs0mqgr_1_1.rman RECID=18 STAMP=940272155 deleted backup piece backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_04_02/o1_mf_s_940272000_dg1of2br_.bkp RECID=19 STAMP=940272162 Deleted 22 objects RMAN>
delete expired backup;删除过期备份(校验失败的备份);
RMAN> delete expired backup; using channel ORA_DISK_1 List of Backup Pieces BP Key BS Key Pc# Cp# Status Device Type Piece Name ------- ------- --- --- ----------- ----------- ---------- 1 1 1 1 EXPIRED DISK /home/oracle/bak/con_01rvukk4_1_1.bak 2 2 1 1 EXPIRED DISK /home/oracle/bak/con_1.bak 3 3 1 1 EXPIRED DISK /home/oracle/bak/full.bak 6 6 1 1 EXPIRED DISK /home/oracle/bak/full_07rvuktf_1_1.bak 10 10 1 1 EXPIRED DISK /u01/app/oracle/flash/centos_db0gs06kuf_1_1.rman 11 11 1 1 EXPIRED DISK /u01/app/oracle/flash/centos_db0hs06kuh_1_1.rman 12 12 1 1 EXPIRED DISK /u01/app/oracle/flash/centos_db0is06kui_1_1.rman 13 13 1 1 EXPIRED DISK /u01/app/oracle/flash/centos_db0js06kuj_1_1.rman 14 14 1 1 EXPIRED DISK /u01/app/oracle/flash/centos_db0ks06kuq_1_1.rman Do you really want to delete the above objects (enter YES or NO)? y deleted backup piece backup piece handle=/home/oracle/bak/con_01rvukk4_1_1.bak RECID=1 STAMP=939479685 deleted backup piece backup piece handle=/home/oracle/bak/con_1.bak RECID=2 STAMP=939479806 deleted backup piece backup piece handle=/home/oracle/bak/full.bak RECID=3 STAMP=939479870 deleted backup piece backup piece handle=/home/oracle/bak/full_07rvuktf_1_1.bak RECID=6 STAMP=939479983 deleted backup piece backup piece handle=/u01/app/oracle/flash/centos_db0gs06kuf_1_1.rman RECID=10 STAMP=939742159 deleted backup piece backup piece handle=/u01/app/oracle/flash/centos_db0hs06kuh_1_1.rman RECID=11 STAMP=939742161 deleted backup piece backup piece handle=/u01/app/oracle/flash/centos_db0is06kui_1_1.rman RECID=12 STAMP=939742162 deleted backup piece backup piece handle=/u01/app/oracle/flash/centos_db0js06kuj_1_1.rman RECID=13 STAMP=939742163 deleted backup piece backup piece handle=/u01/app/oracle/flash/centos_db0ks06kuq_1_1.rman RECID=14 STAMP=939742171 Deleted 9 EXPIRED objects RMAN>
delete backup;删除所有备份集;
RMAN> delete backup; using channel ORA_DISK_1 List of Backup Pieces BP Key BS Key Pc# Cp# Status Device Type Piece Name ------- ------- --- --- ----------- ----------- ---------- 20 20 1 1 AVAILABLE DISK /u01/app/oracle/flash/centos_db0ts0mr3v_1_1.rman 21 21 1 1 AVAILABLE DISK /u01/app/oracle/flash/CENTOS/autobackup/2017_04_02/o1_mf_s_940272000_dg1p073l_.bkp Do you really want to delete the above objects (enter YES or NO)? y deleted backup piece backup piece handle=/u01/app/oracle/flash/centos_db0ts0mr3v_1_1.rman RECID=20 STAMP=940272767 deleted backup piece backup piece handle=/u01/app/oracle/flash/CENTOS/autobackup/2017_04_02/o1_mf_s_940272000_dg1p073l_.bkp RECID=21 STAMP=940272775 Deleted 2 objects RMAN>
delete copy;删除所有映像副本;
RMAN> delete copy; released channel: ORA_DISK_1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=35 device type=DISK specification does not match any datafile copy in the repository specification does not match any control file copy in the repository specification does not match any archived log in the repository RMAN>