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

最新推荐文章于 2024-08-20 10:54:35 发布
最新推荐文章于 2024-08-20 10:54:35 发布
阅读量1.6k 收藏 1
点赞数 2
文章标签： Oracle 数据库 ORA-00257
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：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，登陆成功。

北京-agan
关注
  • 2
    点赞
  • 踩
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
ORA-00257 archiver error.connect internal only，until freed
Colin Lau Oracle
12-29 2020
今天在做imp的时候突然跳出来这个错误： 用sys登陆查看数据库是否处于归档模式： 我靠，sys进不去，有新的错误ORA-09817，但是出现了关键错误 Linux Error: 28: No space left on device; 查看系统空间使用情况： 根目录/ 使用100%，使用满啦，为什么会突然满呢，我做imp只有100多M，查看系统日志：
ORA-00257: archiver error. Connect internal only, until freed
专注java1000 年
12-12 356
1.首先通过cmd命令窗口连接超级管理员，Linux命令，sqlplus / as sysdba; 2.查询db_recovery_file_dest_size的空间,然后去查看你的db_recovery_file_dest的文件路劲是不是已经装满了。 3.装满了的话就修改db_recovery_file_dest_size的空间，至于大小随你。更改语句ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=8g; 4.重启oracl...
archive error .Connect internal only,until freed的一个解决方案
慕的天空
12-28 1481
遇到这种时候通常是oracle的归档日志满了，导致远程访问失败！ 只需两步操作： 1.使用RMAN登录及连接本地数据库 rman target / 2.删除过期的归档日志 delete expired archivelog all; 第二部的操作可以选择删除规定时间的归档日志比如： delete noprompt force archivelog until time ‘sysdate-2’; ...
ORA-00257: archiver error. Connect internal only, until freed 的解决方法
能量守恒洛的专栏
03-27 8935
归档文件存储空间不足，导致出现该问题。 当我们将数据库的模式修改为归档模式的时候，如果没有指定归档目录，默认的归档文件就会放到FlashRecovery Area的目录，但是这个目录是有大小限制的，如果超过了这个大小，就会导致2个问题，一是不能完成归档，二是，在出现问题后，如果此时重启数据库，那么数据库就无法正常启动。 解决方法有 三个方案。（1）扩大Flash Recovery Area的...
ORA-00257: archiver error. Connect internal only, until freed解决（适用于非归档日志空间占满造成该报错的场景）
charlie2cindy的博客
02-04 4284
场景还原 数据库一个汇总任务中，使用了DBLINK跨库查询几个表，平时跑的很顺溜，突然有一天报错：ORA-00257: archiver error. Connect internal only, until freed 该报错导致数据汇总任务未能成功执行，只能先解决报错 解决过程 网络上查找相应解决方案 因在此之前没有遇到过类似报错，从字面上看知道与归档日志有关，但是保险起见还是先在网络上搜索了下相关报错解决方案进行参考。一般给出的解决方案都是归档日志空间沾满导致该报错，确定方法如下： 先查询归档日志
oracle：archiver error. Connect internal only, until freed 错误的处理方法
热门推荐
cm_1234的博客
01-29 1万+
【原因】出现ORA-00257错误（空间不足错误），通过查找资料，绝大部分说这是由于归档日志太多，占用了全部的硬盘剩余空间导致的，通过简单删除日志或加大存储空间就能够解决。 【解决办法】 1. 登录服务器，切换用户oracle,连接oracle [root@userbeta~]# su - oracle [oracle@userbeta~]$ sqlplus /nolog
ORA-00257: archiver error. Connect internal only, until freed 解决办法
weixin_45336090的博客
11-08 1427
问题原因：Oracle归档日志爆满 Oracle的归档日志会记录对数据库所做的修改，如新增，修改，删除数据时都会记录在日志中。当短时间内执行大量的更新操作时，就会导致归档日志爆满，有两种方式可以解决该问题：     1.使用RMAN删除归档日志     2.增大闪回恢复区的大小 一.使用RMAN删除归档日志 1.切换到Oracle数据库 su - oracle 2.进入RMAN维护： rman target user_na
ORA-00257: archiver error. Connect internal only, until freed——解决
卢克治-BJTU-NLP-的博客
05-15 3140
参考http://www.2cto.com/database/201109/104615.html，https://www.cnblogs.com/lanzi/p/3301729.html 开启归档后，操作一个大表迁移表空间，执行了1个多小时没完成就手动给中断了，但是再次用plsql登陆时提示“ORA-00257: archiver error. Connect internal only, until freed”，原来是日志满了，根据上述网址提供的步骤操作后就可以，即删除部分归档日志。 1.首先查看
Oracle归档日志写满(ora-00257)了怎么办
12-16
在Oracle数据库管理过程中，经常会遇到ORA-00257错误：“archiver error. Connect internal only, until freed”。这通常是因为归档日志空间不足导致的，即归档日志已经写满。此时，数据库将无法正常进行归档操作，...
ORA-00257 错误的处理方法
04-17
归档日期满了报 ORA-00257 archiver error. Connect internal only, until freed 错误的处理方法
oracle数据库归档日志满问题解决方案[归类].pdf
10-11
用户登录时提示ORA-00257：archiver error. Connect internal only，util freed。这个错误信息表明归档日志已经满溢，无法继续写入新的日志记录，影响数据库的正常运行。 二、解决方案 解决该问题的步骤如下： 1....
oracle数据库归档日志满问题解决方案.docx
12-30
当用户登录时，提示 ORA-00257：archiver error. Connect internal only，直到释放。这个错误信息表明归档日志满，无法写入新的日志。 二、解决方案 1. 使用 sys 用户登录 SQLPlus 首先，需要使用 sys 用户登录 ...
ORA-00257: archiver error. Connect internal only, until freed 处理方法
孑木文学的博客
10-29 3551
1、产生原因 通过PL/SQL登录用户账号提示此信息，导致无法正常登录，查询资料显示出现ORA-00257错误由于归档日志已满，占用了全部的硬盘剩余空间导致的，通过简单删除日志释放存储空间就能够解决。 2、解决办法 2.1 root用户登录服务器,然后切换Oracle用户，用DBA用户连接到oracle [root@ldjc ~]# su - oracle [oracle@ldjc ~]$ sql...
ORA-00257:archiver error.Connect internal only,until freed.
m0_49562857的博客
09-15 2356
归档满了。
解决ORA-00257:archiver error.Connect internal only, until freed
聆听。。花开雨落的博客
04-25 504
用sqlplus登录orcale; SQL> SELECT* FROM V$FLASH_RECOVERY_AREA_USAGE; FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES ------------ ------------------ ---------------------...
ORA-00257: archiver error. Connect internal only, until freed.有效解决方法！
sailorPan
05-21 1375
ORA-00257（存储空间问题），oracle中archivelog的日志量过多。解决过程：1、备份日志，2、删除日志 解决办法： 1、备份日志。 1.1 SSH工具登录服务器，切换用户oracle,连接oracle su - oracle sqlplus /nolog SQL> connect /as sysdba 1.2、检查flash recovery area的...
【Oracle】 ORA-00257: archiver error. Connect internal only, until freed
象在舞的技术专栏
04-30 2505
最近在操作Oracle数据库的时候出现了如下的一个错误： ORA-00257: archiver error. Connect internal only, until freed 这个错误产生的原因主要是因为归档日志太多，导致硬盘空间不足导致的，可以通过删除日志或加大空间就能够解决，具体操作如下：（这里通过删除日志的方式进行解决） 1、首先在终端使用如下...
【达梦数据库】导入导出过程中get DDL复现过程
最新发布
weixin_47686079的博客
08-20 329
在处理问题的过程中，客户反馈在达梦数据库中导入导出分区表，get 表的DDL，不会出现表的所有分区信息，ORACLE数据库却会出现所有分区表，事实真的如此吗？
ora-00257: archiver error. connect internal only, until freed.
06-28
### 回答1： ORA-00257是Oracle数据库中的一个错误代码，表示归档错误。错误信息中的“connect internal only, until freed”表示只有内部连接才能解决这个问题，直到空间释放为止。这个错误通常是由于归档日志文件已满或磁盘空间不足导致的。要解决这个问题，可以通过删除旧的归档日志文件或增加磁盘空间来释放空间。 ### 回答2： ORA-00257是Oracle数据库中常见的错误之一，它表示归档器发生故障，无法继续归档。这个错误经常出现在数据库空间不足或者磁盘空间不足的情况下。另外，当出现一个归档进程正在使用或者另一个归档进程正在进行数据转储时，也可能出现ORA-00257错误。 这个错误可以通过在SQLPLUS命令行界面中连接到内部（internal）以解决。连接到内部可以使用以下命令： sqlplus / as sysdba 连接到内部后，可以尝试使用以下命令释放空间并解决ORA-00257错误： 1.查看当前的归档日志： archive log list; 2.查看归档日志的状态： select * from v$archive_dest_status; 3.检查数据库的归档日志目录： select name, value from v$parameter where name like '%log_archive_dest%'; 4.手动归档当前的重做日志： alter system archive log current; 5.删除重复或无用的归档日志： RMAN> crosscheck archivelog all; RMAN> delete noprompt expired archivelog all; 当然，磁盘空间不足也是ORA-00257错误的常见原因。在这种情况下，需要增加磁盘空间或定期清理日志来避免出现这个错误。 总之，ORA-00257错误是Oracle数据库中常见的归档器错误之一。尽管出现这个错误可能有多种原因，但可以通过连接到内部，查找并释放空间以及清理无用的归档日志来解决这个问题。 ### 回答3： ORA-00257是Oracle数据库中的一个错误代码，表示出现了归档器错误，只能通过内部连接访问，直到释放。 当Oracle数据库中的归档日志没有及时清空时，就可能会出现ORA-00257错误。归档日志是Oracle数据库保留的一些历史记录，用于恢复数据和保证数据一致性。每当Oracle数据库执行完一定量的事务操作后，就会将这些操作记录下来，并写入到归档日志中。但是，如果归档日志没有及时清空，就会导致存储空间不足，从而导致ORA-00257错误的发生。 解决ORA-00257错误的方法是通过内部连接访问数据库，并释放所有占用该日志的进程。首先，需要先停止所有使用归档日志的进程，然后释放归档日志，最后再启动这些进程，即可解决错误。 具体操作步骤如下： 1. 使用管理员账号登录到数据库中。 2. 执行以下SQL语句，停止所有使用归档日志的进程。 SQL> ALTER system SWITCH logfile; SQL> ALTER system SWITCH logfile; SQL> ALTER system SWITCH logfile; SQL> SHUTDOWN immidiate; 3. 使用以下命令释放归档日志。 SQL> startup mount; SQL> ARCHIVE LOG ALL; SQL> ALTER DATABASE OPEN; 4. 最后，启动之前停止的进程。 SQL> ALTER system ARCHIVELOG ALL; 以上就是解决ORA-00257错误的完整步骤。需要注意的是，在清空归档日志之前，需要备份相关的数据以保证数据的安全性。同时，也应该定期清空归档日志，避免存储空间不足导致ORA-00257错误的再次发生。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值