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

最新推荐文章于 2023-09-15 15:32:37 发布

北京-agan

最新推荐文章于 2023-09-15 15:32:37 发布

阅读量1.6k

点赞数 2

文章标签： Oracle 数据库 ORA-00257

本文链接：https://blog.csdn.net/aizaikuerle/article/details/10109415

版权

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

ORA-00257 archiver error. Connect internal only

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

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

[oracle@RedHat ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 12 06:11:35 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select * from V$FLASH_RECOVERY_AREA_USAGE;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE		      0 			0		0
ONLINELOG		      0 			0		0
ARCHIVELOG		  97.81 			0	       41
BACKUPPIECE		      0 			0		0
IMAGECOPY		      0 			0		0
FLASHBACKLOG		      0 			0		0

6 rows selected.

发现ARCHIVELOG的使用率达到了97.81

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

SQL> show parameter recover;

NAME				     TYPE	 VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest		     string	 /u01/app/oracle/flash_recovery
						 _area
db_recovery_file_dest_size	     big integer 2G
recovery_parallelism		     integer	 0

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

[oracle@RedHat ~]$ cd $ORACLE_BASE/flash_recovery_area
[oracle@RedHat flash_recovery_area]$ ll
total 4
drwxr-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]$ ll
total 8
drwxr-x---  6 oracle oinstall 4096 Aug 12 00:04 archivelog
drwxr-x---  2 oracle oinstall 4096 Jul 17 11:34 onlinelog
[oracle@RedHat ORCL]$ cd archivelog/
[oracle@RedHat archivelog]$ ll
total 16
drwxr-x---  2 oracle oinstall 4096 Aug  9 22:00 2013_08_09
drwxr-x---  2 oracle oinstall 4096 Aug 10 19:56 2013_08_10
drwxr-x---  2 oracle oinstall 4096 Aug 11 01:53 2013_08_11
drwxr-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]$ ll
total 4
drwxr-x---  2 oracle oinstall 4096 Aug 12 06:17 2013_08_12

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

登陆RMAN

[oracle@RedHat ~]$ rman

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Aug 12 06:18:24 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN> connect target system/system

connected to target database: ORCL (DBID=1348795218)

检查无用的archivelog

RMAN> crosscheck archivelog all;

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

删除

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=139 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=138 devtype=DISK

List of Archived Log Copies
Key     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_.arc
2       1    15      X 09-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_15_90bphhhg_.arc
3       1    16      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_16_90bql9cv_.arc
4       1    17      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_17_90bsn0n8_.arc
5       1    18      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_18_90bx3253_.arc
6       1    19      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_19_90bz7ndq_.arc
7       1    20      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_20_90bz947d_.arc
8       1    21      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_21_90cl66dm_.arc
9       1    22      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_22_90cl6jbl_.arc
10      1    23      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_23_90cl6tcp_.arc
11      1    24      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_24_90clc47c_.arc
12      1    25      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_25_90clcf6h_.arc
13      1    26      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_26_90clcq85_.arc
14      1    27      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_27_90clohvb_.arc
15      1    28      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_28_90clp08f_.arc
16      1    29      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_29_90clpfvz_.arc
17      1    30      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_30_90clpr9l_.arc
18      1    31      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_31_90clq3y6_.arc
19      1    32      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_32_90clqlmn_.arc
20      1    33      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_33_90clqx0w_.arc
21      1    34      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_34_90clr7xw_.arc
22      1    35      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_35_90clys6m_.arc
23      1    36      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_36_90clz3o9_.arc
24      1    37      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_37_90clzhoc_.arc
25      1    38      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_38_90cm98y0_.arc
26      1    39      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_39_90cm9pkb_.arc
27      1    40      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_40_90cmmy59_.arc
28      1    41      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_41_90cmq7cd_.arc
29      1    42      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_42_90cmqkof_.arc
30      1    43      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_43_90cmqvv2_.arc
31      1    44      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_44_90cmr55b_.arc
32      1    45      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_45_90cmrgyl_.arc
33      1    46      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_46_90cmsrgv_.arc
34      1    47      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_47_90cmzj7m_.arc
35      1    48      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_48_90cmzwm8_.arc
36      1    49      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_49_90cn062s_.arc
37      1    50      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_50_90cn0j9q_.arc
38      1    51      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_51_90cn0t0r_.arc
39      1    52      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_52_90cn2ym3_.arc
40      1    53      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_53_90dbmpvh_.arc
41      1    54      X 10-AUG-13 /u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_11/o1_mf_1_54_90dzk0lr_.arc

Do you really want to delete the above objects (enter YES or NO)? yes
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_09/o1_mf_1_14_909xj5g9_.arc recid=1 stamp=823039245
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_15_90bphhhg_.arc recid=2 stamp=823064821
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_16_90bql9cv_.arc recid=3 stamp=823065932
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_17_90bsn0n8_.arc recid=4 stamp=823068036
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_18_90bx3253_.arc recid=5 stamp=823071592
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_19_90bz7ndq_.arc recid=6 stamp=823073785
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_20_90bz947d_.arc recid=7 stamp=823073833
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_21_90cl66dm_.arc recid=8 stamp=823093193
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_22_90cl6jbl_.arc recid=9 stamp=823093204
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_23_90cl6tcp_.arc recid=10 stamp=823093214
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_24_90clc47c_.arc recid=11 stamp=823093353
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_25_90clcf6h_.arc recid=12 stamp=823093363
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_26_90clcq85_.arc recid=13 stamp=823093678
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_27_90clohvb_.arc recid=14 stamp=823093689
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_28_90clp08f_.arc recid=15 stamp=823093699
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_29_90clpfvz_.arc recid=16 stamp=823093724
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_30_90clpr9l_.arc recid=17 stamp=823093738
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_31_90clq3y6_.arc recid=18 stamp=823093744
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_32_90clqlmn_.arc recid=19 stamp=823093757
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_33_90clqx0w_.arc recid=20 stamp=823093763
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_34_90clr7xw_.arc recid=21 stamp=823093773
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_35_90clys6m_.arc recid=22 stamp=823093985
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_36_90clz3o9_.arc recid=23 stamp=823094000
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_37_90clzhoc_.arc recid=24 stamp=823094318
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_38_90cm98y0_.arc recid=25 stamp=823094324
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_39_90cm9pkb_.arc recid=26 stamp=823094633
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_40_90cmmy59_.arc recid=27 stamp=823094663
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_41_90cmq7cd_.arc recid=28 stamp=823094768
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_42_90cmqkof_.arc recid=29 stamp=823094774
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_43_90cmqvv2_.arc recid=30 stamp=823094784
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_44_90cmr55b_.arc recid=31 stamp=823094805
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_45_90cmrgyl_.arc recid=32 stamp=823094812
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_46_90cmsrgv_.arc recid=33 stamp=823094845
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_47_90cmzj7m_.arc recid=34 stamp=823095032
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_48_90cmzwm8_.arc recid=35 stamp=823095042
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_49_90cn062s_.arc recid=36 stamp=823095052
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_50_90cn0j9q_.arc recid=37 stamp=823095061
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_51_90cn0t0r_.arc recid=38 stamp=823095070
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_52_90cn2ym3_.arc recid=39 stamp=823095140
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_10/o1_mf_1_53_90dbmpvh_.arc recid=40 stamp=823118203
deleted archive log
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_08_11/o1_mf_1_54_90dzk0lr_.arc recid=41 stamp=823139620
Deleted 41 EXPIRED objects

退出RMAN

然后再查询FLASH_RECOVERY_AREA使用情况

RMAN> exit;


Recovery Manager complete.
[oracle@RedHat ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 12 06:20:23 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE		      0 			0		0
ONLINELOG		      0 			0		0
ARCHIVELOG		   7.16 			0		3
BACKUPPIECE		      0 			0		0
IMAGECOPY		      0 			0		0
FLASHBACKLOG		      0 			0		0

6 rows selected.

使用率变为7.16

重新用scott用户登录

[oracle@RedHat ~]$ sqlplus scott/scott

SQL*Plus: Release 10.2.0.1.0 - Production on Mon Aug 12 06:53:06 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>

登陆成功。

总结：

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