清除Oracle控制文件中的归档信息v$archived_log

http://blog.itpub.net/28878983/viewspace-2135807/ https://www.askmaclean.com/archives/cleanup-controlfile-sectio-record-deleted-archivelog.html execute sys.dbms_backup_restore.resetCfileSection( 11);  ==> 清理v$ARCHIVED_LOG对应的记录 execute sys.dbms_backup_restore.resetCfileSection(28);  ==>清理v$rman_status对应的记录 --以上是2个例子，具体的section_id可以这样获得： SQL> select rownum-1, type from v$controlfile_record_section;   ROWNUM-1 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   ROWNUM-1 TYPE ---------- ----------------------------         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   ROWNUM-1 TYPE ---------- ----------------------------         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   ROWNUM-1 TYPE ---------- ----------------------------         33 RESTORE POINT 34 rows selected. 关键知识点1.执行包sys.dbms_backup_restore.resetCfileSection(11)，清理v$ARCHIVED_LOG对应的记录；2. catalog start with添加对象到备份记录中；