ARC0: Failed to archive thread 1 sequence 6292 (19809)
Wed Jan  9 15:00:29 2013
Errors in file /arp/oraarp/admin/arpdb/bdump/arpdb_arc1_21890.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.
Wed Jan  9 15:00:29 2013
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.

 

答：
Flash Recovery Area空间不足导致数据库不能打开,清除过期无效的归档，增大flash recover area空间。

一.rman清除过期无效的归档日志 

[oraarp@arpdb ~]$ rman target /
    连接到目标数据库: ARPDB (DBID=3012609948) 
   RMAN> crosscheck archivelog all;
   RMAN> delete expired archivelog all; 

释放的通道: ORA_DISK_1
    分配的通道: ORA_DISK_1
   通道 ORA_DISK_1: sid=652 devtype=DISK 

已存档的日志副本列表

关键字     Thrd Seq     S 短时间     名称
------- ---- ------- - ---------- ----
13      1    5440    X 22-4月 -10 /arp/oraarp/archive/1_5440_681226270.dbf
15      1    5441    X 22-4月 -10 /arp/oraarp/archive/1_5441_681226270.dbf

是否确定要删除以上对象 (输入 YES 或 NO)?YES

二.增大 db_recovery_file_dest_size
select name,space_limit,space_used,number_of_files from v$recovery_file_dest;
alter system set db_recovery_file_dest_size=8G scope=both;

 

 

-----------------------------我是分隔线-----------------------------------

--------------------------------------------------------------------------

错日志报一例：
ORA-19815: WARNING: db_recovery_file_dest_size of 214748364800 bytes is 100.00% used, and has 22528 remaining bytes available.

Sun Sep 18 10:49:39 2016

************************************************************************

You have following choices to free up space from flash recovery area:

1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,

   then consider changing RMAN ARCHIVELOG DELETION POLICY.

2. Back up files to tertiary device such as tape using RMAN

   BACKUP RECOVERY AREA command.

3. Add disk space and increase db_recovery_file_dest_size parameter to

   reflect the new space.

4. Delete unnecessary files using RMAN DELETE command. If an operating

   system command was used to delete files, then use RMAN CROSSCHECK and

   DELETE EXPIRED commands.

************************************************************************

Sun Sep 18 10:49:39 2016

Errors in file /arp/oraarp/admin/arpdb/bdump/arpdb_arc0_4771.trc:

ORA-19809: limit exceeded for recovery files

ORA-19804: cannot reclaim 198636544 bytes disk space from 214748364800 limit

ARC0: Error 19809 Creating archive log file to '/arp/oraarp/flash_recovery_area/ARPDB/archivelog/2016_09_18/o1_mf_1_18034_6120_.arc'

ARC0: Failed to archive thread 1 sequence 18034 (19809)

ARCH: Archival stopped, error occurred. Will continue retrying

Sun Sep 18 10:49:39 2016

ORACLE Instance arpdb - Archival Error

Sun Sep 18 10:49:39 2016

ORA-16038: log 6 sequence# 18034 cannot be archived

ORA-19809: limit exceeded for recovery files

ORA-00312: online log 6 thread 1: '/arp/oraarp/oradata/arpdb/redo06.log'

Sun Sep 18 10:49:39 2016

Errors in file /arp/oraarp/admin/arpdb/bdump/arpdb_arc0_4771.trc:

ORA-16038: log 6 sequence# 18034 cannot be archived

ORA-19809: limit exceeded for recovery files

ORA-00312: online log 6 thread 1: '/arp/oraarp/oradata/arpdb/redo06.log'

ARC0: Archiving not possible: No primary destinations

ARC0: Failed to archive thread 1 sequence 18034 (4)

ARCH: Archival stopped, error occurred. Will continue retrying

Sun Sep 18 10:49:39 2016

ORACLE Instance arpdb - Archival Error

Sun Sep 18 10:49:39 2016

ORA-16014: log 6 sequence# 18034 not archived, no available destinations

ORA-00312: online log 6 thread 1: '/arp/oraarp/oradata/arpdb/redo06.log'

Sun Sep 18 10:49:39 2016

Errors in file /arp/oraarp/admin/arpdb/bdump/arpdb_arc0_4771.trc:

ORA-16014: log 6 sequence# 18034 not archived, no available destinations

ORA-00312: online log 6 thread 1: '/arp/oraarp/oradata/arpdb/redo06.log'

Sun Sep 18 10:50:39 2016

ARC1: Archiving not possible: No primary destinations

ARC1: Failed to archive thread 1 sequence 18034 (4)

Sun Sep 18 10:51:39 2016

ARC0: Archiving not possible: No primary destinations

ARC0: Failed to archive thread 1 sequence 18034 (4)

Sun Sep 18 10:52:39 2016

ARC1: Archiving not possible: No primary destinations

ARC1: Failed to archive thread 1 sequence 18034 (4)

Sun Sep 18 10:53:39 2016

ARC0: Archiving not possible: No primary destinations

ARC0: Failed to archive thread 1 sequence 18034 (4)

Sun Sep 18 10:54:39 2016

ARC0: Archiving not possible: No primary destinations

ARC0: Failed to archive thread 1 sequence 18034 (4)

Sun Sep 18 10:54:40 2016

db_recovery_file_dest_size of 204800 MB is 26.05% used. This is a

user-specified limit on the amount of space that will be used by this

database for recovery-related files, and does not reflect the amount of

space available in the underlying filesystem or ASM diskgroup.

Archiver process freed from errors. No longer stopped

Sun Sep 18 10:57:34 2016

-------------
select FILE_TYPE,PERCENT_SPACE_USED from v$flash_recovery_area_usage;