Oracle删除控制文件中的磁带备份信息
👉 本文共约177个字，系统预计阅读时间或需1分钟。
使用NBU进行备份的信息也记录在控制文件中，不能使用普通的方式删除，删除方式如下：
1 2 3 4 | list backupset of datafile 1; allocate channel for maintenance device type sbt parms 'SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=@aaaab)'; crosscheck backup; delete noprompt expired backup; |
注意：BACKUP_DIR需要修改，路径使用“list backupset”查询Media后的值即可。
若报错：
1 2 3 | RMAN-03009: failure of delete command on ORA_MAINT_SBT_TAPE_1 channel at 03/14/2022 12:49:16 ORA-27191: sbtinfo2 returned error Additional information: 3480 |
本人提供Oracle、MySQL、PG等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
那么可以尝试使用如下的方式：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 | list backupset of datafile 1; SELECT ROWNUM-1 "NUMBER", TYPE FROM V$CONTROLFILE_RECORD_SECTION; EXECUTE DBMS_BACKUP_RESTORE.RESETCFILESECTION(11); EXECUTE DBMS_BACKUP_RESTORE.RESETCFILESECTION(12); EXECUTE DBMS_BACKUP_RESTORE.RESETCFILESECTION(13); EXECUTE DBMS_BACKUP_RESTORE.RESETCFILESECTION(17); EXECUTE DBMS_BACKUP_RESTORE.RESETCFILESECTION(18); EXECUTE DBMS_BACKUP_RESTORE.RESETCFILESECTION(19); EXECUTE DBMS_BACKUP_RESTORE.RESETCFILESECTION(28); EXECUTE DBMS_BACKUP_RESTORE.RESETCFILESECTION(14); EXECUTE DBMS_BACKUP_RESTORE.RESETCFILESECTION(16); EXECUTE DBMS_BACKUP_RESTORE.RESETCFILESECTION(27); -- 11.2.0.4下 SQL> set pagesize 1000 SQL> SELECT ROWNUM-1 "NUMBER", TYPE FROM V$CONTROLFILE_RECORD_SECTION; NUMBER TYPE ---------- ---------------------------- 0 DATABASE 1 CKPT PROGRESS 2 REDO THREAD 3 REDO LOG 4 DATAFILE 5 FILENAME 6 TABLESPACE 7 TEMPORARY FILENAME 8 RMAN CONFIGURATION 9 LOG HISTORY 10 OFFLINE RANGE 11 ARCHIVED LOG 12 BACKUP SET 13 BACKUP PIECE 14 BACKUP DATAFILE 15 BACKUP REDOLOG 16 DATAFILE COPY 17 BACKUP CORRUPTION 18 COPY CORRUPTION 19 DELETED OBJECT 20 PROXY COPY 21 BACKUP SPFILE 22 DATABASE INCARNATION 23 FLASHBACK LOG 24 RECOVERY DESTINATION 25 INSTANCE SPACE RESERVATION 26 REMOVABLE RECOVERY FILES 27 RMAN STATUS 28 THREAD INSTANCE NAME MAPPING 29 MTTR 30 DATAFILE HISTORY 31 STANDBY DATABASE MATRIX 32 GUARANTEED RESTORE POINT 33 RESTORE POINT 34 DATABASE BLOCK CORRUPTION 35 ACM OPERATION 36 FOREIGN ARCHIVED LOG 37 rows selected. |
执行过程：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 | RMAN> list backupset of datafile 1; using target database control file instead of recovery catalog List of Proxy Copies ==================== PC Key File Status Completion Time Ckp SCN Ckp Time ------- ---- ----------- ------------------- ---------- ------------------- 2136 1 AVAILABLE 2022-03-12 01:14:38 128591471849 2022-03-12 01:11:21 Datafile name: /u01/app/oracle/oradata/orcl/system01.dbf Handle: bk_dORCL_u8v0o5is3_s3359_p23_t1099090819 Media: @aaaab Tag: TAG20220311T230019 2108 1 AVAILABLE 2022-03-05 01:16:39 128409918094 2022-03-05 01:13:00 Datafile name: /u01/app/oracle/oradata/orcl/system01.dbf Handle: bk_dORCL_u6j0nj485_s3283_p23_t1098486021 Media: @aaaab Tag: TAG20220304T230021 2080 1 AVAILABLE 2022-02-26 01:14:57 128235431456 2022-02-26 01:11:33 Datafile name: /u01/app/oracle/oradata/orcl/system01.dbf Handle: bk_dORCL_u3j0moog7_s3187_p23_t1097622023 Media: @aaaab Tag: TAG20220225T230023 2052 1 AVAILABLE 2022-02-19 01:13:26 128058852469 2022-02-19 01:10:07 Datafile name: /u01/app/oracle/oradata/orcl/system01.dbf Handle: bk_dORCL_u170m69s4_s3111_p23_t1097017220 Media: @aaaab Tag: TAG20220218T230020 2024 1 AVAILABLE 2022-02-12 01:16:34 127874962016 2022-02-12 01:13:00 Datafile name: /u01/app/oracle/oradata/orcl/system01.dbf Handle: bk_dORCL_urh0ljr87_s2929_p23_t1096412423 Media: @aaaab Tag: TAG20220211T230023 1996 1 AVAILABLE 2022-02-05 01:07:04 127632219512 2022-02-05 01:03:40 Datafile name: /u01/app/oracle/oradata/orcl/system01.dbf Handle: bk_dORCL_upq0l1ck3_s2874_p22_t1095807619 Media: @aaaab Tag: TAG20220204T230019 1969 1 AVAILABLE 2022-01-29 01:16:27 127438971711 2022-01-29 01:12:45 Datafile name: /u01/app/oracle/oradata/orcl/system01.dbf Handle: bk_dORCL_uo30keu02_s2819_p22_t1095202818 Media: @aaaab Tag: TAG20220128T230018 1942 1 AVAILABLE 2022-01-22 01:19:05 127236048285 2022-01-22 01:15:52 Datafile name: /u01/app/oracle/oradata/orcl/system01.dbf Handle: bk_dORCL_um80jsfc4_s2760_p22_t1094598020 Media: @aaaab Tag: TAG20220121T230020 1915 1 AVAILABLE 2022-01-15 01:09:19 127048065864 2022-01-15 01:06:07 Datafile name: /u01/app/oracle/oradata/orcl/system01.dbf Handle: bk_dORCL_ukc0ja0o3_s2700_p22_t1093993219 Media: @aaaab Tag: TAG20220114T230019 RMAN> RMAN> delete noprompt expired backup; allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=936 device type=DISK allocated channel: ORA_DISK_2 channel ORA_DISK_2: SID=1361 device type=DISK specification does not match any backup in the repository RMAN> allocate channel for maintenance device type sbt parms 'SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=@aaaab)'; allocated channel: ORA_MAINT_SBT_TAPE_2 channel ORA_MAINT_SBT_TAPE_2: SID=1361 device type=SBT_TAPE channel ORA_MAINT_SBT_TAPE_2: WARNING: Oracle Test Disk API RMAN> crosscheck backup; crosschecked proxy copy: found to be 'EXPIRED' proxy copy handle=bk_dORCL_u8v0o5is3_s3359_p23_t1099090819 RECID=2136 STAMP=1099098681 crosschecked proxy copy: found to be 'EXPIRED' proxy copy handle=bk_dORCL_u6j0nj485_s3283_p23_t1098486021 RECID=2108 STAMP=1098493980 。。。。。 proxy copy handle=bk_dORCL_u170m69s4_s3111_p20_t1097017220 RECID=2049 STAMP=1097024073 crosschecked proxy copy: found to be 'EXPIRED' proxy copy handle=bk_dORCL_urh0ljr87_s2929_p20_t1096412423 RECID=2021 STAMP=1096419314 Crosschecked 246 objects RMAN> delete noprompt expired backup; List of Proxy Copies ==================== PC Key File Status Completion Time Ckp SCN Ckp Time ------- ---- ----------- ------------------- ---------- ------------------- 2136 1 EXPIRED 2022-03-12 01:14:38 128591471849 2022-03-12 01:11:21 Datafile name: /u01/app/oracle/oradata/orcl/system01.dbf Handle: bk_dORCL_u8v0o5is3_s3359_p23_t1099090819 Media: @aaaab Tag: TAG20220311T230019 2108 1 EXPIRED 2022-03-05 01:16:39 128409918094 2022-03-05 01:13:00 Datafile name: /u01/app/oracle/oradata/orcl/system01.dbf Handle: bk_dORCL_u6j0nj485_s3283_p23_t1098486021 Media: @aaaab Tag: TAG20220304T230021 。。。。。 proxy copy handle=bk_dORCL_urh0ljr87_s2929_p20_t1096412423 RECID=2021 STAMP=1096419314 Deleted 246 EXPIRED objects RMAN> list backupset of datafile 1; specification does not match any backup in the repository RMAN> list backupset; specification does not match any backup in the repository |
