ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 042-075

042-075

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-15 03:52:37 0 删除 编辑
75. In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database? (Choose two.)
A) The database instance aborts.
B) The database operation temporarily halts till the member becomes available.
C) Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
D) The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
E) The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.
答案:CD
日志组中的某成员损坏并不会影响数据库的正常使用,同时该成员将被标记为stale(陈旧)状态,错误信息会被写到alert日志里
一个数据库可以有多个日志组,组内也可以有多少日志成员,成员之间成镜像关系
增加日志成员用 alter database add logfile member '路径+名字' to group 3 这样组中的两个成员就成了镜像关系
Oracle 10g文档原文 (Your database's redo log consists of groups of redo log files. A group consists of a redo log file and its multiplexed copies. Each identical copy is said to be a member of that group. Each group is defined by a number, such as Group 1.)

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718571/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 043-072
下一篇: 042-076
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    205707