ORA-16014:no available destinations

测试库重启

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博客 ” ，链接：http://blog.itpub.net/24419958/viewspace-672286/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24419958/viewspace-672286/