QUESTION 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
答案是BC
当数据库在ARCHIVELOG模式使用,而监控数据库中的空间,你发现
闪回恢复区域没有足够的自由空间来容纳任何更多的文件,而你没有
权限,以增加更多的空间。
在一个日志切换事件中可以确定发生哪两件事情?
B .直到空闲空间在闪回恢复区可用,该日志交换才发生事务
C.oracle数据库服务 删除已过时文件列表中的文件,使得闪回恢复区有空闲的空间