IT开放社区

RMAN管理备份交叉检查及删除

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>

 

相关文章

发表评论:

◎欢迎参与讨论,请在这里发表您的看法、交流您的观点。

网站分类
最新文章
    随机文章
      站点信息
      • 文章总数:113
      • 页面总数:2
      • 分类总数:3
      • 标签总数:1
      • 评论总数:0
      • 浏览总数:45518
      左邻右舍

      BlogPowerBy Z-BlogPHP 1.5 Zero ;Theme By 爱墙纸

      IT开放社区:京ICP备13044647号.初创于Oracle DBA实战班.邮箱:admin@itkaifang.com

      分享:

      支付宝

      微信