Oracle 10g默認(rèn)的歸檔日志存放在flash_recovery_area，如果歸檔日志超過(guò)了默認(rèn)值的大小,則會(huì)報(bào)ORA-16014的錯(cuò)誤.
1.出錯(cuò)
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.查看歸檔日志區(qū)的大小
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.計(jì)算后,發(fā)現(xiàn)使用了2.96G>2G,將值設(shè)為4G,重新啟動(dòng),成功
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 閱讀(751)
評(píng)論(0) 編輯 收藏 所屬分類:
oracle-基礎(chǔ)