oracle闪回区管理 - 数据库编程

log file name=/home/oracle/product/11.1.0/db_1/dbs/arch1_17_750871897.dbf RECID=8 STAMP=753646377
deleted archived log
archived log file name=/home/oracle/product/11.1.0/db_1/dbs/arch1_18_750871897.dbf RECID=9 STAMP=753747854

RMAN> exit

Recovery Manager complete.

再查看闪回区的信息，SPACE_USED已经释放。

select * from v$recovery_file_dest;

NAME /home/oracle/flash_recovery_area
SPACE_LIMIT 2147483648
SPACE_USED 0
SPACE_RECLAIMABLE 0
NUMBER_OF_FILES 0

作者：积微成著

oracle闪回区管理(三)