ocp-166

QUESTION NO: 166
You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) and the
database has crashed. What would be the appropriate order of operations to correct the situation?
a. Mount the database with the startup mount command.
b. Take the SYSTEM datafile offline with the alter database command.
c. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs.
d. Restore all SYSTEM tablespace–related datafiles from backup media.
e. Issue the recover tablespace SYSTEM command.
f. Issue the recover datafile SYSTEM_01.dbf command.
g. Open the database with the alter database open command.
h. Open the database with the alter database open resetlogs command.

A. a, c, f, g
B. b, d, e, h
C. a, b, c, f, g
D. d, a, e, g
E. b, c, f, e, g
Answer: D


您已经失去了所有的系统表空间的数据文件( system_01.dbf和system_02.dbf)并且数据库已崩溃。什么是适
当的操作顺序来纠正这种情况?
D. d, a, e, g
d.从备份介质还原所有系统表空间相关的数据文件。
a.用启动挂载命令挂载数据库。
e.发出恢复系统表空间命令。
g.用改变数据库打开命令打开数据库。

First you would restore the missing datafiles. Notice in the question that there are two datafiles that were
lost. Next you would mount the database and then you would recover the SYSTEM tablespace. Since it is
the SYSTEM tablespace, you would not be able to open the database first. Then you open the database
with the alter database open command.


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值