ORACLE:
C:\Users\vidor>sqlplus/nolog
SQL*Plus: Release 10.2.0.1.0 - Production on 星期三 9月 18 17:04:09 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn sys/orcl as sysdba
已连接。
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.85 0 82
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
已选择6行。
SQL> alter system set DB_RECOVERY_FILE_DEST_SIZE=10g
2 ;
系统已更改。
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 20.95 0 85
BACKUPPIECE 0 0 0
IMAGECOPY 0 0 0
FLASHBACKLOG 0 0 0
已选择6行。
以上方法不能从根源上解决这个问题,但是,可以使当前问题解决。