118. 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? (choose two)
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.
答案：AC
Editor’s note:you can see the deail description of this error:
Cause: DB_RECOVERY_FILE_DEST is running out of disk space.
Action: One of the following:
1. Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
2. Backup files to tertiary device using RMAN.
3. Consider changing RMAN retention policy.
4. Consider changing RMAN archivelog deletion policy.
5. Delete files from recovery area using RMAN.
6. 将归档设置到其他目录，修改alter system set log_archive_dest = 其他路径 可事先用show parameter log_archive_dest查看
When you see the step 3,you will know why answer C is right.
如果是归档到闪回区的，你在os上手工删除后，rman仍然认为是available，rman还是认为那文件存在，只有执行了crosscheck才会将available转成expired，delete expired后，rman就不会觉得那空间还没占用的
crosscheck archivelog all; delete expired archivelog all;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718621/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
