完成;select * from V $ FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE ,,,,,,,,,,,,,,PERCENT_SPACE_USED - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 控制FILE ,,,,,,,,,,,,,,,,,,0 ,,,,,,0,,,,0
重做LOG ,,,,,,,,,,,,,,,,,,0 ,,,,,,0,,,,0
存档LOG ,,,,,,,,,,,,,,,, ,,,,,,0,,,,,,16
FILE_TYPE ,,,,,,,,,,,,,,PERCENT_SPACE_USED - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 备份PIECE ,,,,,,,,,,,,,,,,,,0 ,,,,,,0,,,,0
COPY 形象;,,,,,,,,,,,,,,,,,,0 ,,,,,,0,,,,0
闪回LOG ,,,,,,,,,,,,,,,,,,0 ,,,,,,0,,,,0
FILE_TYPE ,,,,,,,,,,,,,,PERCENT_SPACE_USED - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 外国LOG 存档;,,,,,,,,,,,,,,,,0 ,,,,,,0,,,,0
7行选择。 完成;显示参数db_recovery_file_dest;
NAME ,,,,,,,,,,类型 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 价值 ------------------------------ db_recovery_file_dest ,,,,,,字符串/picclife/app/oracle/fast_reco very_area db_recovery_file_dest_size ,,,,大整数 4182米 完成;选择总和(percent_space_used) * 3/100 v $ flash_recovery_area_usage;
总和(PERCENT_SPACE_USED) * 3/100 ----------------------------- ,,,,,,,,2.8524
RMAN>删除ARCHIVELOG之前完成所有“SYSDATE-7”; 再次查看 完成;select * from V $ FLASH_RECOVERY_AREA_USAGE;
FILE_TYPE ,,,,,,,,,,,,,,PERCENT_SPACE_USED - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 控制FILE ,,,,,,,,,,,,,,,,,,0 ,,,,,,0,,,,0
重做LOG ,,,,,,,,,,,,,,,,,,0 ,,,,,,0,,,,0
存档LOG ,,,,,,,,,,,,,, ,,,,,,0,,,,5
FILE_TYPE ,,,,,,,,,,,,,,PERCENT_SPACE_USED - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - 备份PIECE ,,,,,,,,,,,,,,,,,,0 ,,,,,,0,,,,0