Oracle 10g默认的归档日志存放在flash_recovery_area，如果归档日志超过了默认值的大小,则会报ORA-16014的错误.
1.出错
SQL*Plus: Release 10.2.0.2.0 - Production on Sun May 30 10:32:43 2010
Copyright (c) 1982, 2005, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, Oracle Label Security, OLAP and Data Mining options
SQL> startup mount
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1260396 bytes
Variable Size 96470164 bytes
Database Buffers 180355072 bytes
Redo Buffers 7127040 bytes
Database mounted.
SQL> alter database open
2 /
alter database open
*
ERROR at line 1:
ORA-16014: log 1 sequence# 86 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'
2.查看归档日志区的大小
SQL> show parameter db_rec
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/flash_recovery
_area
db_recovery_file_dest_size big integer 2G
db_recycle_cache_size big integer 0
3.检查flash recovery area的使用情况
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 98.77 0 52
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
6 rows selected.
SQL> select sum( PERCENT_SPACE_USED )*3/100 from v$flash_recovery_area_usage;
SUM(PERCENT_SPACE_USED)*3/100
-----------------------------
2.9631
4.计算后,发现使用了2.96G>2G,将值设为4G,重新启动,成功
SQL> alter system set db_recovery_file_dest_size =4G;
System altered.
SQL> alter database open;
Database altered.
SQL>
posted on 2010-05-30 13:02
xrzp 阅读(742)
评论(0) 编辑 收藏 所属分类:
oracle-基础