Oracle 数据库OCP-053-635

最新推荐文章于 2024-10-14 22:42:36 发布

cke63021

最新推荐文章于 2024-10-14 22:42:36 发布

阅读量101

点赞数

文章标签：数据库

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
Answer: BC
解析：在归档模式下，你的闪回恢复区空间不足，你又没有权限增加空间，问当你切换日志时，会发生什么？

首先你应该了解闪回恢复区的都有哪些内容：所有和恢复相关的文件都可以存放到闪回恢复区

SQL>select file_type from v$flash_recovery_area_usage;
FILE_TYPE
------------------------
CONTROLFILE
ONLINELOG
ARCHIVELOG
BACKUPPIECE
IMAGECOPY
FLASHBACKLOG
已选择6行。

上面的视图中可以看出，包括controfile,online redo logfile,archive logfile,rman backuppiece,rman image copy, flashback log等，都可以利用闪回恢复区来存放、管理。

B选项：闪回恢复区空间不足导致不能归档，而日志切换时，会触发归档，所以就会导致事务挂起，因为事务发生之前，要先写日志，不能归档，也就不能写日志，所以事务要挂起，B选项对，

C选项:服务器进程会根据备份保留策略来删除过期的本分文件，来释放一些空间，故C正确。