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
参考:
http://docs.oracle.com/cd/E11882_01/server.112/e10897/backrest.htm#ADMQS09211
题意是:在FRA空间满的情况下,你没有权限去扩充空间,数据库为归档模式,归档日志存放在FRA,系统发生日志切换,会发生什么情况?
1、日志切换引发归档,事务会HANG住;
2、在FRA空间满的情况下,服务器会根据备份保留策略来删除过期的备份,释放更多的空间;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2120583/
,如需转载,请注明出处,否则将追究法律责任。