此时空间得到释放:
$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.1.0.2.0 - Production on Mon Mar 28 12:02:19 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SYS AS SYSDBA on 28-MAR-05 >SELECT substr(name, 1, 30) name, space_limit AS quota,
2 space_used AS used,
3 space_reclaimable AS reclaimable,
4 number_of_files AS files
5 FROM v$recovery_file_dest ;
NAME QUOTA USED RECLAIMABLE FILES
---------------------------- ---------- ---------- ----------- ----------
/data5/flash_recovery_area 2147483648 9959424 0 1
SYS AS SYSDBA on 28-MAR-05 >
解决方法：
可以通过执行如下命令:
RMAN> backup recovery area来解决此问题。
（注：将闪回区的内容备份到第三方介质，同样可以解决此问题）
（责任编辑：卢兆林）
<<上一页
1
2
