Oracle OCP题库解析（16）

ITAA-OCM

You notice this warning in the alert log file:

ORA-19815: WARNING:  db_recovery_file_dest_size of 3221225472 bytes is 100.00% used, and has 0 remaining bytes available.

What would you do to reclaim the used space in the Flash Recovery Area?

A) Back up the Flash Recovery Area.

B) Increase the retention time for the files.

C) Decrease the retention time for the files.

D) Manually delete all the archived log files from the Flash Recovery Area by using operating system (OS) commands.

Answer: A,C

默认请况下Oracle会将归档日志文件，备份数据文件，备份控制文件，闪回文件放到db_recovery_file_dest_size所指定的目录下。备份走Flash Recovery Area可以减少空间。假如retention设为7天，那么7天内备份文件不会被覆盖，所以应该减少retention的时间。如果是归档到闪回区的，你在os 上手工删除后，rman 仍然认为是available，rman 还是认为那文件存在，只有执行了crosscheck 才会将available 转成expired，delete expired 后，rman就不会觉得那空间还没占用的

crosscheck archivelog all;

delete expired archivelog all;

rangeover

rangeover

wish_start

学习了

houweichenzuofe

edfeng222

太棒了，感谢楼主太棒了，感谢楼主太棒了，感谢楼主