166. You are working on a database, where you have three redo log gro
ups. When the database is down for a backup, an operating system (OS)
user deletes all the redo log files in a group. What will happen whe
n you open your database?
A. The instance starts, the database is mounted, but efforts to open
the database fail, and an error about the missing redo log group is d
isplayed.
B. Before the instance starts, you receive an error about the missing
redo log files of a group.
C. The instance starts and the database opens with an error message w
ritten to the alert log file.
D. The instance starts and the database opens because two redo log gr
oups still exist.
E. The instance starts and the database opens, but every attempt to w
rite to redo log files fails with an error.
Answer: A
在关机状态下丢失redo log group 数据库是无法启动的,只能到mount 状
态,在control file 里有日志文件位置的信息
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/11312660/viewspace-718228/
,如需转载,请注明出处,否则将追究法律责任。