测试库重启

ORA-16014: log 3 sequence# 7 not archived, no available destinations
ORA-00312: online log 3 thread 1: '/u01/oracle/oradata/t1db/redo03.log'

查看alertlog

Wed Sep 1 08:59:59 2010
Errors in file /u01/oracle/admin/t1db/bdump/t1db_arc1_7154.trc:
ORA-16014: log 3 sequence# 7 not archived, no available destinations
ORA-00312: online log 3 thread 1: '/u01/oracle/oradata/t1db/redo03.log'
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive thread 1 sequence 7 (4)

查看已经使用recovery空间大小

SQL> show parameter recovery
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      /u01/oracle/flash_recovery_area
db_recovery_file_dest_size           big integer 2G

查看recovery使用情况

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                 8.53                        0               6
BACKUPPIECE                   0                         0               0
IMAGECOPY                     0                         0               0
FLASHBACKLOG                0                         0               0

6 rows selected.

查看linux空间使用情况，发现空间已满。删除冗余文件，删除swap分区，打开数据库。OK。
引起这种现象的原因是：在linux系统中，临时文件的分配并没有分配到实际大小（只指定了文件上限）。

ITPub博客

ORA-16014:no available destinations

最新文章