OCP 1Z0 053 154

154.A database is running in ARCHIVELOG mode and regular backups are performed. A user receives 
the following error message: 

Which is the recommended sequence of operations you need to perform for the query successfully? 
A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace. 
B. Take the affected datafile offline (if not already offline), restore the damaged image of the datafile, and 
then bring it online. 
C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then 
open the database with resetlogs. 
D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover 
the tablespace, and then put the database in normal operational mode. 
Answer: C

数据文件找不到了,可以单恢复数据文件,不用恢复整个表空间

file:///G:/book/Oracle/E11882_01/backup.112/e10642/rcmquick.htm#i999413

Restoring and Recovering Database Files

Use the RESTORE and RECOVER commands for RMAN restore and recovery of physical database files. Restoring data files is retrieving them from backups as needed for a recovery operation. Media recovery is the application of changes from redo logs and incremental backups to a restored data file to bring the data file forward to a desired SCN or point in time.


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

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

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值