ORA-00257 archiver error. Connect internal only解决方法

今天用scott用户链接本地的oracle，报错

ORA-00257 archiver error. Connect internal only

这样的问题一般都是 FLASH_RECOVERY_AREA空间不足

所以我先用管理员账户登录，查询了一下FLASH_RECOVERY_AREA的使用情况

[oracle@RedHat ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 12 06:11:35 2013Copyright (c) 1982, 2005, Oracle.  All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> select * from V$FLASH_RECOVERY_AREA_USAGE;FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES------------ ------------------ ------------------------- ---------------CONTROLFILE      0 00ONLINELOG      0 00ARCHIVELOG  97.81 0       41BACKUPPIECE      0 00IMAGECOPY      0 00FLASHBACKLOG      0 006 rows selected.

发现ARCHIVELOG的使用率达到了97.81

然后查看归档日志文件所在的路径

SQL> show parameter recover;NAME     TYPE VALUE------------------------------------ ----------- ------------------------------db_recovery_file_dest     string /u01/app/oracle/flash_recovery _areadb_recovery_file_dest_size     big integer 2Grecovery_parallelism     integer 0

进入所在路径，找到归档日志文件

[oracle@RedHat ~]$ cd $ORACLE_BASE/flash_recovery_area[oracle@RedHat flash_recovery_area]$ lltotal 4drwxr-x---  4 oracle oinstall 4096 Aug  9 22:00 ORCL[oracle@RedHat flash_recovery_area]$ cd orcl-bash: cd: orcl: No such file or directory[oracle@RedHat flash_recovery_area]$ cd ORCL[oracle@RedHat ORCL]$ lltotal 8drwxr-x---  6 oracle oinstall 4096 Aug 12 00:04 archivelogdrwxr-x---  2 oracle oinstall 4096 Jul 17 11:34 onlinelog[oracle@RedHat ORCL]$ cd archivelog/[oracle@RedHat archivelog]$ lltotal 16drwxr-x---  2 oracle oinstall 4096 Aug  9 22:00 2013_08_09drwxr-x---  2 oracle oinstall 4096 Aug 10 19:56 2013_08_10drwxr-x---  2 oracle oinstall 4096 Aug 11 01:53 2013_08_11drwxr-x---  2 oracle oinstall 4096 Aug 12 00:04 2013_08_12

删除归档日志，采用rm -R 2013_08_*，但是数据库会自动保存最后一个

[oracle@RedHat archivelog]$ rm -R 2013_08_*[oracle@RedHat archivelog]$ lltotal 4drwxr-x---  2 oracle oinstall 4096 Aug 12 06:17 2013_08_12

在删除归档日志后，必须用RMAN维护控制文件，否则空间显示仍然不释放。

登陆RMAN

[oracle@RedHat ~]$ rmanRecovery Manager: Release 10.2.0.1.0 - Production on Mon Aug 12 06:18:24 2013Copyright (c) 1982, 2005, Oracle.  All rights reserved.RMAN> connect target system/systemconnected to target database: ORCL (DBID=1348795218)

检查无用的archivelog

RMAN> crosscheck archivelog all;using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=139 devtype=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: sid=138 devtype=DISKvalidation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_09/o1_mf_1_14_909xj5g9_.arc recid=1 stamp=823039245validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_15_90bphhhg_.arc recid=2 stamp=823064821validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_16_90bql9cv_.arc recid=3 stamp=823065932validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_17_90bsn0n8_.arc recid=4 stamp=823068036validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_18_90bx3253_.arc recid=5 stamp=823071592validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_19_90bz7ndq_.arc recid=6 stamp=823073785validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_20_90bz947d_.arc recid=7 stamp=823073833validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_21_90cl66dm_.arc recid=8 stamp=823093193validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_22_90cl6jbl_.arc recid=9 stamp=823093204validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_23_90cl6tcp_.arc recid=10 stamp=823093214validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_24_90clc47c_.arc recid=11 stamp=823093353validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_25_90clcf6h_.arc recid=12 stamp=823093363validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_26_90clcq85_.arc recid=13 stamp=823093678validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_27_90clohvb_.arc recid=14 stamp=823093689validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_28_90clp08f_.arc recid=15 stamp=823093699validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_29_90clpfvz_.arc recid=16 stamp=823093724validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_30_90clpr9l_.arc recid=17 stamp=823093738validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_31_90clq3y6_.arc recid=18 stamp=823093744validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_32_90clqlmn_.arc recid=19 stamp=823093757validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_33_90clqx0w_.arc recid=20 stamp=823093763validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_34_90clr7xw_.arc recid=21 stamp=823093773validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_35_90clys6m_.arc recid=22 stamp=823093985validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_36_90clz3o9_.arc recid=23 stamp=823094000validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_37_90clzhoc_.arc recid=24 stamp=823094318validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_38_90cm98y0_.arc recid=25 stamp=823094324validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_39_90cm9pkb_.arc recid=26 stamp=823094633validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_40_90cmmy59_.arc recid=27 stamp=823094663validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_41_90cmq7cd_.arc recid=28 stamp=823094768validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_42_90cmqkof_.arc recid=29 stamp=823094774validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_43_90cmqvv2_.arc recid=30 stamp=823094784validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_44_90cmr55b_.arc recid=31 stamp=823094805validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_45_90cmrgyl_.arc recid=32 stamp=823094812validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_46_90cmsrgv_.arc recid=33 stamp=823094845validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_47_90cmzj7m_.arc recid=34 stamp=823095032validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_48_90cmzwm8_.arc recid=35 stamp=823095042validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_49_90cn062s_.arc recid=36 stamp=823095052validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_50_90cn0j9q_.arc recid=37 stamp=823095061validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_51_90cn0t0r_.arc recid=38 stamp=823095070validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_52_90cn2ym3_.arc recid=39 stamp=823095140validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_53_90dbmpvh_.arc recid=40 stamp=823118203validation failed for archived logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_11/o1_mf_1_54_90dzk0lr_.arc recid=41 stamp=823139620Crosschecked 41 objects

删除

RMAN> delete expired archivelog all;released channel: ORA_DISK_1released channel: ORA_DISK_2allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=139 devtype=DISKallocated channel: ORA_DISK_2channel ORA_DISK_2: sid=138 devtype=DISKList of Archived Log CopiesKey     Thrd Seq     S Low Time  Name------- ---- ------- - --------- ----1       1    14      X 09-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_09/o1_mf_1_14_909xj5g9_.arc2       1    15      X 09-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_15_90bphhhg_.arc3       1    16      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_16_90bql9cv_.arc4       1    17      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_17_90bsn0n8_.arc5       1    18      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_18_90bx3253_.arc6       1    19      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_19_90bz7ndq_.arc7       1    20      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_20_90bz947d_.arc8       1    21      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_21_90cl66dm_.arc9       1    22      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_22_90cl6jbl_.arc10      1    23      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_23_90cl6tcp_.arc11      1    24      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_24_90clc47c_.arc12      1    25      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_25_90clcf6h_.arc13      1    26      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_26_90clcq85_.arc14      1    27      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_27_90clohvb_.arc15      1    28      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_28_90clp08f_.arc16      1    29      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_29_90clpfvz_.arc17      1    30      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_30_90clpr9l_.arc18      1    31      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_31_90clq3y6_.arc19      1    32      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_32_90clqlmn_.arc20      1    33      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_33_90clqx0w_.arc21      1    34      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_34_90clr7xw_.arc22      1    35      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_35_90clys6m_.arc23      1    36      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_36_90clz3o9_.arc24      1    37      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_37_90clzhoc_.arc25      1    38      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_38_90cm98y0_.arc26      1    39      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_39_90cm9pkb_.arc27      1    40      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_40_90cmmy59_.arc28      1    41      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_41_90cmq7cd_.arc29      1    42      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_42_90cmqkof_.arc30      1    43      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_43_90cmqvv2_.arc31      1    44      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_44_90cmr55b_.arc32      1    45      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_45_90cmrgyl_.arc33      1    46      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_46_90cmsrgv_.arc34      1    47      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_47_90cmzj7m_.arc35      1    48      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_48_90cmzwm8_.arc36      1    49      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_49_90cn062s_.arc37      1    50      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_50_90cn0j9q_.arc38      1    51      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_51_90cn0t0r_.arc39      1    52      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_52_90cn2ym3_.arc40      1    53      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_53_90dbmpvh_.arc41      1    54      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_11/o1_mf_1_54_90dzk0lr_.arcDo you really want to delete the above objects (enter YES or NO)? yesdeleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_09/o1_mf_1_14_909xj5g9_.arc recid=1 stamp=823039245deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_15_90bphhhg_.arc recid=2 stamp=823064821deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_16_90bql9cv_.arc recid=3 stamp=823065932deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_17_90bsn0n8_.arc recid=4 stamp=823068036deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_18_90bx3253_.arc recid=5 stamp=823071592deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_19_90bz7ndq_.arc recid=6 stamp=823073785deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_20_90bz947d_.arc recid=7 stamp=823073833deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_21_90cl66dm_.arc recid=8 stamp=823093193deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_22_90cl6jbl_.arc recid=9 stamp=823093204deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_23_90cl6tcp_.arc recid=10 stamp=823093214deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_24_90clc47c_.arc recid=11 stamp=823093353deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_25_90clcf6h_.arc recid=12 stamp=823093363deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_26_90clcq85_.arc recid=13 stamp=823093678deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_27_90clohvb_.arc recid=14 stamp=823093689deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_28_90clp08f_.arc recid=15 stamp=823093699deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_29_90clpfvz_.arc recid=16 stamp=823093724deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_30_90clpr9l_.arc recid=17 stamp=823093738deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_31_90clq3y6_.arc recid=18 stamp=823093744deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_32_90clqlmn_.arc recid=19 stamp=823093757deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_33_90clqx0w_.arc recid=20 stamp=823093763deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_34_90clr7xw_.arc recid=21 stamp=823093773deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_35_90clys6m_.arc recid=22 stamp=823093985deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_36_90clz3o9_.arc recid=23 stamp=823094000deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_37_90clzhoc_.arc recid=24 stamp=823094318deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_38_90cm98y0_.arc recid=25 stamp=823094324deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_39_90cm9pkb_.arc recid=26 stamp=823094633deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_40_90cmmy59_.arc recid=27 stamp=823094663deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_41_90cmq7cd_.arc recid=28 stamp=823094768deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_42_90cmqkof_.arc recid=29 stamp=823094774deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_43_90cmqvv2_.arc recid=30 stamp=823094784deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_44_90cmr55b_.arc recid=31 stamp=823094805deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_45_90cmrgyl_.arc recid=32 stamp=823094812deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_46_90cmsrgv_.arc recid=33 stamp=823094845deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_47_90cmzj7m_.arc recid=34 stamp=823095032deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_48_90cmzwm8_.arc recid=35 stamp=823095042deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_49_90cn062s_.arc recid=36 stamp=823095052deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_50_90cn0j9q_.arc recid=37 stamp=823095061deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_51_90cn0t0r_.arc recid=38 stamp=823095070deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_52_90cn2ym3_.arc recid=39 stamp=823095140deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_53_90dbmpvh_.arc recid=40 stamp=823118203deleted archive logarchive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_11/o1_mf_1_54_90dzk0lr_.arc recid=41 stamp=823139620Deleted 41 EXPIRED objects

退出RMAN

然后再查询FLASH_RECOVERY_AREA使用情况

RMAN> exit;Recovery Manager complete.[oracle@RedHat ~]$ sqlplus / as sysdbaSQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 12 06:20:23 2013Copyright (c) 1982, 2005, Oracle.  All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> select * from v$flash_recovery_area_usage;FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES------------ ------------------ ------------------------- ---------------CONTROLFILE      0 00ONLINELOG      0 00ARCHIVELOG   7.16 03BACKUPPIECE      0 00IMAGECOPY      0 00FLASHBACKLOG      0 006 rows selected.

使用率变为7.16

重新用scott用户登录

[oracle@RedHat ~]$ sqlplus scott/scottSQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 12 06:53:06 2013Copyright (c) 1982, 2005, Oracle.  All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL>

登陆成功。

总结：

遇到ORA-00257： archiver error. Connect internal only错误，一般是因为闪回区空间不足，导致只能以sysdba的身份登陆数据库，我们可以查看FLASH_RECOVERY_AREA的利用率，然后删除过期的归档日志文件，然后用RMAN来维护控制文件---检查并删除过期的归档日志信息。最后退出RMAN，登陆成功。