052-60

In which of the scenarios will the DBA perform recovery? (Choose all that apply.)
A.The alert log file is corrupted.
B.A tablespace is accidentally dropped.
C.One of the redo log members is corrupted.
D.A database user terminates the session abnormally.
E.The hard disk on which the data file is stored is corrupted.

A 错误,alert 日志损坏不影响数据库的正常运行,可以删除掉,数据库会自动生成新的
B 正确,误删表空间属于用户误操作,需要 DBA 执行恢复
C 错误,redo 日志损坏的是一个成员,不会影响数据库运行,可删除重建一个
D 错误,会话终止属于进程失败,数据库会自动恢复正在进行的事务,不需要人工干预
E 正确,磁盘损坏属于介质故障,需要人工恢复

posted @ 2017-12-07 15:30  巴啦啦大魔王  阅读(95)  评论(0编辑  收藏  举报