SQL> select rownum-1, type from v$
controlfile_record_section;
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
可以找到11對應(yīng)歸檔日志
執(zhí)行以下命令可以清理v$ARCHIVED_LOG對應(yīng)的記錄
execute
sys.dbms_backup_restore.resetCfileSection(11);
（注意：在生產(chǎn)上使用需要非常謹(jǐn)慎和經(jīng)過測試，并確?？刂莆募鄳?yīng)部分的信息不再需要）
清理后可重新注冊現(xiàn)有歸檔日志，使用catalog start with '目錄名';