[每天一题] 11gOCP 1z0-052 :2013-09-1 RMAN- repair failure.A20

[每日一题] 11gOCP 1z0-052 :2013-09-1 RMAN-- repair failure........................................A20

转载请注明出处：http://blog.csdn.net/guoyjoe/article/details/10859315

正确答案：D

一、模拟上题的错误：

１、删除4号文件

RMAN> repair failure;Strategy: The repair includes complete media recovery with no data lossRepair script: /u01/app/oracle/diag/rdbms/ocm/ocm/hm/reco_3275375759.hmcontents of repair script:   # restore and recover datafile   restore datafile 4;   recover datafile 4;   sql 'alter database datafile 4 online';Do you really want to execute the above repair (enter YES or NO)? Yexecuting repair scriptStarting restore at 01-SEP-13using channel ORA_DISK_1channel ORA_DISK_1: starting datafile backup set restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setchannel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/ocm/users01.dbfchannel ORA_DISK_1: reading from backup piece /u01/app/oracle/product/11.2.0/dbs/0uoiptgq_1_1channel ORA_DISK_1: piece handle=/u01/app/oracle/product/11.2.0/dbs/0uoiptgq_1_1 tag=TAG20130901T230250channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: restore complete, elapsed time: 00:00:03Finished restore at 01-SEP-13Starting recover at 01-SEP-13using channel ORA_DISK_1starting media recoverymedia recovery complete, elapsed time: 00:00:01Finished recover at 01-SEP-13sql statement: alter database datafile 4 onlinerepair failure completeDo you want to open the database (enter YES or NO)? Ydatabase opened

QQ：252803295

学习交流QQ群：
DSI&Core Search  Ⅰ 群：127149411（技术:已满）
DSI&Core Search  Ⅱ 群：177089463（技术:未满）
DSI&Core Search  Ⅲ 群：284596437（技术:未满）
DSI&Core Search  Ⅳ 群：192136702（技术:未满）
DSI&Core Search  Ⅴ 群：285030382（闲聊:未满）