053-635

While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.
Identify the two events that can occur in the event of a log switch? (Choose two.)
A. An entry is created in the alert log file and the database instance continues to function normally
B. The log switch hangs occur for transactions until free space is available in the flash recovery area
C. The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
D. The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

使用 FRA 的好处就是自动的空间管理。数据库会根据保留策略,在 FRA 空间不足的情况下,自动的删除过期的备份文件,来释放空间。 C 对
alert 日志中会出项告警信息,但是如果 FRA 空间满了,在归档模式下是无法进行日志切换的,实例是会夯住,不能正常工作。 B 对


posted @ 2017-11-16 11:02  巴啦啦大魔王  阅读(117)  评论(0编辑  收藏  举报