ITPub博客

首页 > 数据库 > Oracle > Oracle 11G OCP 1Z0-053 657

Oracle 11G OCP 1Z0-053 657

原创 Oracle 作者:LuiseDalian 时间:2014-11-17 07:20:05 0 删除 编辑
(657)The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted.

What steps should you take to recover from this tempfile loss in an efficient manner?

A. Allow the database to continue running,drop the TEMP tablespace,and then re-create it with new tempfiles

B. Shut down the database,restore and recover the tempfile from backup,and then open the database with RESETLOGS

C. Allow the database to continue running,take the TEMP tablespace offline,drop the missing tempfile,and then create a new tempfile

D. Allow the database to continue running,add a new tempfile to TEMP tablespace with a new name,and drop the tempfile that has been corrupted.

答案:(D)

重复:699

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

请登录后发表评论 登录
全部评论

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    6040856