출처 : http://www.dba-oracle.com/t_rman_crosscheck.htm
RMAN> delete noprompt obsolete;
RMAN> delete noprompt obsolete;
RMAN> delete noprompt obsolete; RMAN retention policy will be applied to the command RMAN retention policy is set to redundancy 1 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=127 instance=rac2 devtype=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: sid=129 instance=rac2 devtype=DISK allocated channel: ORA_DISK_3 channel ORA_DISK_3: sid=153 instance=rac2 devtype=DISK Deleting the following obsolete backups and copies: Type Key Completion Time Filename/Handle -------------------- ------ ------------------ -------------------- Archive Log 1 08-MAR-12 /home/oracle/archive/2_1_777262308.dbf Datafile Copy 1 08-MAR-12 /home/oracle/backup/SYSTEM.dbf Datafile Copy 2 08-MAR-12 /home/oracle/backup/UNDOTBS1.dbf Datafile Copy 3 08-MAR-12 /home/oracle/backup/SYSAUX.dbf Datafile Copy 4 08-MAR-12 /home/oracle/backup/UNDOTBS2.dbf Datafile Copy 5 08-MAR-12 /home/oracle/backup/USERS.dbf Datafile Copy 6 08-MAR-12 /home/oracle/backup/TS_NEW.dbf Archive Log 2 09-MAR-12 /home/oracle/archive/1_9_777262308.dbf Archive Log 3 09-MAR-12 /home/oracle/archive/2_2_777262308.dbf Archive Log 4 09-MAR-12 /home/oracle/archive/2_3_777262308.dbf Archive Log 5 09-MAR-12 /home/oracle/archive/2_4_777262308.dbf Archive Log 6 09-MAR-12 /home/oracle/archive/2_5_777262308.dbf Archive Log 9 09-MAR-12 /home/oracle/archive/2_7_777262308.dbf Archive Log 8 09-MAR-12 /home/oracle/archive/2_6_777262308.dbf Archive Log 7 09-MAR-12 /home/oracle/archive/1_10_777262308.dbf Archive Log 11 09-MAR-12 /home/oracle/archive/2_9_777262308.dbf Archive Log 10 09-MAR-12 /home/oracle/archive/2_8_777262308.dbf Archive Log 13 09-MAR-12 /home/oracle/archive/2_10_777262308.dbf Archive Log 14 09-MAR-12 /home/oracle/archive/2_11_777262308.dbf Archive Log 12 09-MAR-12 /home/oracle/archive/1_11_777262308.dbf Archive Log 15 09-MAR-12 /home/oracle/archive/2_12_777262308.dbf Archive Log 16 09-MAR-12 /home/oracle/archive/1_12_777262308.dbf Datafile Copy 7 09-MAR-12 /home/oracle/backup/raw3_system.dbf Datafile Copy 8 09-MAR-12 /home/oracle/backup/raw17_undotbs1.dbf Datafile Copy 9 09-MAR-12 /home/oracle/backup/raw4_sysaux.dbf Datafile Copy 10 09-MAR-12 /home/oracle/backup/raw18_undotbs2.dbf Datafile Copy 11 09-MAR-12 /home/oracle/backup/raw15_users.dbf Datafile Copy 12 09-MAR-12 /home/oracle/backup/raw20_ts_new.dbf Datafile Copy 14 10-MAR-12 /home/oracle/clone/system Datafile Copy 15 10-MAR-12 /home/oracle/clone/undotbs1 Datafile Copy 16 10-MAR-12 /home/oracle/clone/sysaux Datafile Copy 17 10-MAR-12 /home/oracle/clone/undotbs2 Datafile Copy 18 10-MAR-12 /home/oracle/clone/users Datafile Copy 19 10-MAR-12 /home/oracle/clone/ts_new Backup Set 7 10-MAR-12 Backup Piece 7 10-MAR-12 /home/oracle/rman/18n5grh2_1_1_20120310.rman Backup Set 4 10-MAR-12 Backup Piece 4 10-MAR-12 /home/oracle/rman/19n5grh2_1_1_20120310.rman Backup Set 3 10-MAR-12 Backup Piece 3 10-MAR-12 /home/oracle/rman/1an5grh2_1_1_20120310.rman Datafile Copy 20 10-MAR-12 /home/oracle/users.dbf Datafile Copy 21 10-MAR-12 /home/oracle/ts_new.dbf Datafile Copy 22 10-MAR-12 /home/oracle/undotbs2.dbf Datafile Copy 23 10-MAR-12 /home/oracle/undotbs1.dbf Datafile Copy 24 10-MAR-12 /home/oracle/sysaux.dbf Datafile Copy 25 10-MAR-12 /home/oracle/system.dbf Datafile Copy 26 10-MAR-12 /home/oracle/clone/users.dbf Datafile Copy 27 10-MAR-12 /home/oracle/clone/ts_new.dbf Datafile Copy 28 10-MAR-12 /home/oracle/clone/undotbs2.dbf Datafile Copy 29 10-MAR-12 /home/oracle/clone/undotbs1.dbf Datafile Copy 31 10-MAR-12 /home/oracle/clone/sysaux.dbf Datafile Copy 32 10-MAR-12 /home/oracle/clone/system.dbf deleted datafile copy datafile copy filename=/home/oracle/backup/raw3_system.dbf recid=7 stamp=777504430 deleted datafile copy datafile copy filename=/home/oracle/backup/raw17_undotbs1.dbf recid=8 stamp=777504449 deleted datafile copy datafile copy filename=/home/oracle/backup/raw4_sysaux.dbf recid=9 stamp=777504459 deleted datafile copy datafile copy filename=/home/oracle/backup/raw18_undotbs2.dbf recid=10 stamp=777504472 deleted datafile copy datafile copy filename=/home/oracle/backup/raw15_users.dbf recid=11 stamp=777504479 deleted datafile copy datafile copy filename=/home/oracle/backup/raw20_ts_new.dbf recid=12 stamp=777504484 Deleted 6 objects deleted backup piece backup piece handle=/home/oracle/rman/18n5grh2_1_1_20120310.rman recid=7 stamp=777547298 deleted backup piece backup piece handle=/home/oracle/rman/19n5grh2_1_1_20120310.rman recid=4 stamp=777547298 deleted backup piece backup piece handle=/home/oracle/rman/1an5grh2_1_1_20120310.rman recid=3 stamp=777547299 Deleted 3 objects RMAN-06207: WARNING: 40 objects could not be deleted for DISK channel(s) due RMAN-06208: to mismatched status. Use CROSSCHECK command to fix status RMAN-06210: List of Mismatched objects RMAN-06211: ========================== RMAN-06212: Object Type Filename/Handle RMAN-06213: --------------- --------------------------------------------------- RMAN-06214: Archivelog /home/oracle/archive/2_1_777262308.dbf RMAN-06214: Datafile Copy /home/oracle/backup/SYSTEM.dbf RMAN-06214: Datafile Copy /home/oracle/backup/UNDOTBS1.dbf RMAN-06214: Datafile Copy /home/oracle/backup/SYSAUX.dbf RMAN-06214: Datafile Copy /home/oracle/backup/UNDOTBS2.dbf RMAN-06214: Datafile Copy /home/oracle/backup/USERS.dbf RMAN-06214: Datafile Copy /home/oracle/backup/TS_NEW.dbf RMAN-06214: Archivelog /home/oracle/archive/1_9_777262308.dbf RMAN-06214: Archivelog /home/oracle/archive/2_2_777262308.dbf RMAN-06214: Archivelog /home/oracle/archive/2_3_777262308.dbf RMAN-06214: Archivelog /home/oracle/archive/2_4_777262308.dbf RMAN-06214: Archivelog /home/oracle/archive/2_5_777262308.dbf RMAN-06214: Archivelog /home/oracle/archive/2_7_777262308.dbf RMAN-06214: Archivelog /home/oracle/archive/2_6_777262308.dbf RMAN-06214: Archivelog /home/oracle/archive/1_10_777262308.dbf RMAN-06214: Archivelog /home/oracle/archive/2_9_777262308.dbf RMAN-06214: Archivelog /home/oracle/archive/2_8_777262308.dbf RMAN-06214: Archivelog /home/oracle/archive/2_10_777262308.dbf RMAN-06214: Archivelog /home/oracle/archive/2_11_777262308.dbf RMAN-06214: Archivelog /home/oracle/archive/1_11_777262308.dbf RMAN-06214: Archivelog /home/oracle/archive/2_12_777262308.dbf RMAN-06214: Archivelog /home/oracle/archive/1_12_777262308.dbf RMAN-06214: Datafile Copy /home/oracle/clone/system RMAN-06214: Datafile Copy /home/oracle/clone/undotbs1 RMAN-06214: Datafile Copy /home/oracle/clone/sysaux RMAN-06214: Datafile Copy /home/oracle/clone/undotbs2 RMAN-06214: Datafile Copy /home/oracle/clone/users RMAN-06214: Datafile Copy /home/oracle/clone/ts_new RMAN-06214: Datafile Copy /home/oracle/users.dbf RMAN-06214: Datafile Copy /home/oracle/ts_new.dbf RMAN-06214: Datafile Copy /home/oracle/undotbs2.dbf RMAN-06214: Datafile Copy /home/oracle/undotbs1.dbf RMAN-06214: Datafile Copy /home/oracle/sysaux.dbf RMAN-06214: Datafile Copy /home/oracle/system.dbf RMAN-06214: Datafile Copy /home/oracle/clone/users.dbf RMAN-06214: Datafile Copy /home/oracle/clone/ts_new.dbf RMAN-06214: Datafile Copy /home/oracle/clone/undotbs2.dbf RMAN-06214: Datafile Copy /home/oracle/clone/undotbs1.dbf RMAN-06214: Datafile Copy /home/oracle/clone/sysaux.dbf RMAN-06214: Datafile Copy /home/oracle/clone/system.dbf
'Oracle > RMAN' 카테고리의 다른 글
| RMAN으로 전체 데이터베이스 백업하면서 필요없는 파일 까지 지우기 ; delete noprompt obsolete이용 (2) | 2012.03.30 |
|---|---|
| RMAN 환경설정 (oracle doc) (0) | 2012.03.18 |
| rman: can't open target (0) | 2012.02.28 |
| RMAN사용도중 control file을 재생성하게되면!? ; RMAN환경설정다시하기, RMAN backuppiece정보 재등록하기 (0) | 2012.02.27 |
| RMAN으로 drop tablespace복구하기 ; 과거의 controlfile을 가져와서 복구해야하는 경우 (0) | 2012.02.26 |