ORA-00257:archiver error. Connect internal only, until freed.

来源：互联网发布：车管家软件是什么编辑：程序博客网时间：2024/05/21 10:22

有个测试库，今天早上来发现登陆数据库失败；提示我归档错误。

1、查看数据库归档情况

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 5294
Next log sequence to archive 5294
Current log sequence 5303

SQL> show parameter log_archive_dest

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest string
log_archive_dest_1 string
log_archive_dest_10 string
log_archive_dest_11 string
log_archive_dest_12 string
log_archive_dest_13 string
log_archive_dest_14 string

2、查看归档路径

SQL> show parameter recovery

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /opt/flash_recovery_area
db_recovery_file_dest_size big integer 2G
recovery_parallelism integer 0

3、查看归档已使用空间大小

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 97.83 0 24
BACKUP PIECE 0 0 0
IMAGE COPY 0 0 0
FLASHBACK LOG 1.48 .74 2
FOREIGN ARCHIVED LOG 0 0 0

4、清除无用的归档日志

删除过期的归档

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=84 device type=DISK
specification does not match any archived log in the repository

删除系统时间前一天以前的归档
RMAN> delete archivelog until time 'sysdate-1';

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=84 device type=DISK
List of Archived Log Copies for database with db_unique_name CMPS
=====================================================================

Key Thrd Seq S Low Time
------- ---- ------- - ---------
5256 1 5294 A 21-AUG-12
Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5294_83onngx9_.arc

5257 1 5295 A 22-AUG-12
Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5295_83onnjlf_.arc

5258 1 5296 A 22-AUG-12
Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5296_83onnjpc_.arc

5259 1 5297 A 23-AUG-12
Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5297_83onnm40_.arc

5260 1 5298 A 23-AUG-12
Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5298_83onnm75_.arc

5261 1 5299 A 23-AUG-12
Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5299_83onnos7_.arc

5262 1 5300 A 24-AUG-12
Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5300_83onnp05_.arc

5263 1 5301 A 24-AUG-12
Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5301_83onnrw8_.arc

5264 1 5302 A 24-AUG-12
Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5302_83onns14_.arc

5265 1 5303 A 25-AUG-12
Name: /opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5303_83onnv6p_.arc

Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5294_83onngx9_.arc RECID=5256 STAMP=792409872
deleted archived log
archived log file name=/opt/flash_recovery_area/CMPS/archivelog/2012_08_27/o1_mf_1_5295_83onnjlf_.arc RECID=5257 STAMP=792409874
deleted archived log............................................................................

5、查看归档日志所占用的空间十分释放

SQL> select * from v$flash_recovery_area_usage;

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
-------------------- ------------------ ------------------------- ---------------
CONTROL FILE 0 0 0
REDO LOG 0 0 0
ARCHIVED LOG 0 0 0
BACKUP PIECE 0 0 0
IMAGE COPY 0 0 0
FLASHBACK LOG 1.48 .74 2
FOREIGN ARCHIVED LOG 0 0 0

7 rows selected

6、测试连接数据库正常