ORA-00257: archiver error. Connect internal only

用户登录报
ORA-00257: archiver error. Connect internal only
日志归档空间不足
不想归档了备份了，所以手工删除归档日志
方法一：
[oracle@DELL-2950 ~]$ cd /u01/app/oracle/flash_recovery_area/DCORA/archivelog
2010_07_28  2010_08_10  2010_08_26  2010_09_07  2010_09_19  2010_10_07  2010_10_19  2010_10_31  2010_11_12  2010_11_24  2010_12_06
2010_07_29  2010_08_11  2010_08_27  2010_09_08  2010_09_20  2010_10_08  2010_10_20  2010_11_01  2010_11_13  2010_11_25  2010_12_07
2010_07_30  2010_08_12  2010_08_28  2010_09_09  2010_09_27  2010_10_09  2010_10_21  2010_11_02  2010_11_14  2010_11_26  2010_12_08
2010_07_31  2010_08_13  2010_08_29  2010_09_10  2010_09_28  2010_10_10  2010_10_22  2010_11_03  2010_11_15  2010_11_27  2010_12_09
2010_08_01  2010_08_14  2010_08_30  2010_09_11  2010_09_29  2010_10_11  2010_10_23  2010_11_04  2010_11_16  2010_11_28  2010_12_10
2010_08_02  2010_08_15  2010_08_31  2010_09_12  2010_09_30  2010_10_12  2010_10_24  2010_11_05  2010_11_17  2010_11_29
2010_08_03  2010_08_16  2010_09_01  2010_09_13  2010_10_01  2010_10_13  2010_10_25  2010_11_06  2010_11_18  2010_11_30
2010_08_04  2010_08_17  2010_09_02  2010_09_14  2010_10_02  2010_10_14  2010_10_26  2010_11_07  2010_11_19  2010_12_01
2010_08_05  2010_08_18  2010_09_03  2010_09_15  2010_10_03  2010_10_15  2010_10_27  2010_11_08  2010_11_20  2010_12_02
2010_08_06  2010_08_19  2010_09_04  2010_09_16  2010_10_04  2010_10_16  2010_10_28  2010_11_09  2010_11_21  2010_12_03
2010_08_07  2010_08_24  2010_09_05  2010_09_17  2010_10_05  2010_10_17  2010_10_29  2010_11_10  2010_11_22  2010_12_04
2010_08_09  2010_08_25  2010_09_06  2010_09_18  2010_10_06  2010_10_18  2010_10_30  2010_11_11  2010_11_23  2010_12_05
[oracle@DELL-2950 archivelog]$ cd ..
[oracle@DELL-2950 DCORA]$ ls
archivelog
[oracle@DELL-2950 DCORA]$ rm -r archivelog
[oracle@DELL-2950 DCORA]$ mkdir archivelog

 

使用rman清除控制文件或catalog数据库的信息

rman target /
RMAN> crosscheck archivelog all;
Crosschecked 497 objects

RMAN> delete expired archivelog all;
Deleted 497 EXPIRED objects
RMAN> exit

 

方法二：使用rman删除归档日志

RMAN> delete archivelog all;                                                                                                       

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1624 devtype=DISK

List of Archived Log Copies
Key     Thrd Seq     S Low Time   Name
------- ---- ------- - ---------- ----
1010    1    2       A 10-12月-10 /u01/app/oracle/flash_recovery_area/DCORA/archivelog/2010_12_10/o1_mf_1_2_6j3rcwbb_.arc
1011    1    3       A 10-12月-10 /u01/app/oracle/flash_recovery_area/DCORA/archivelog/2010_12_10/o1_mf_1_3_6j3rf0xg_.arc
1012    1    4       A 10-12月-10 /u01/app/oracle/flash_recovery_area/DCORA/archivelog/2010_12_10/o1_mf_1_4_6j3rf7xm_.arc
1013    1    5       A 10-12月-10 /u01/app/oracle/flash_recovery_area/DCORA/archivelog/2010_12_10/o1_mf_1_5_6j4dq6nz_.arc
1014    1    6       A 10-12月-10 /u01/app/oracle/flash_recovery_area/DCORA/archivelog/2010_12_11/o1_mf_1_6_6j5fmvoc_.arc
1015    1    7       A 11-12月-10 /u01/app/oracle/flash_recovery_area/DCORA/archivelog/2010_12_12/o1_mf_1_7_6j7p3pt5_.arc
1016    1    8       A 12-12月-10 /u01/app/oracle/flash_recovery_area/DCORA/archivelog/2010_12_12/o1_mf_1_8_6j8t61n1_.arc
1017    1    9       A 12-12月-10 /u01/app/oracle/flash_recovery_area/DCORA/archivelog/2010_12_13/o1_mf_1_9_6jbpfhg2_.arc

Do you really want to delete the above objects (enter YES or NO)? yes 

RMAN> crosscheck archivelog all;                                                                                                   

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1624 devtype=DISK
specification does not match any archive log in the recovery catalog