You executed the following command:RMAN> RECOVER COPY OF DATAFILE ‘／u01／app／oracle／oradata／orcl／users01.dbf‘;Which statement regarding the above command is correct?()A. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the image c

题目
You executed the following command:RMAN> RECOVER COPY OF DATAFILE ‘／u01／app／oracle／oradata／orcl／users01.dbf‘;Which statement regarding the above command is correct?()

A. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the image copy

B. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the last incremental backup

C. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are updated with all changes up to incremental backup SCN. ‘/ u01/app/oracle/oradata/orcl/users01.dbf

D. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are recovered using the above command if data file recovery fails

相似考题

1.AuserexecutesaqueryontheEMPtable，whichcontainsthousandsofrows，togetdetailsaboutemployeesinoneofthedepartments.Theuserreceivesthefollowingerror：SQL>SELECTenameFROMempWHEREdeptno=10ORDERBYsalSELECTenameFROMempWHEREdeptno=10ORDERBYsal*ERRORatline1：ORA01157：cannotidentify/lockdatafile201seeDBWRtracefileORA01110：datafile201：’/u01/app/oracle/oradata/orcl/temp01.dbf’Whatisapossiblereason？（）A.Thetempfilebelongingtothedefaulttemporarytablespaceismissing.B.Thedatabaseisopenedinrestrictedmode，soqueriesarenotallowed.C.Thedefaulttemporarytablespacerequiredtoexecutethequeryisoffline.D.Thedefaulttemporarytablespacerequiredtoexecutethequeryisdropped.E.Thedefaulttemporarytablespacerequiredtoexecutethequeryisreadonly.

2.Youwanttocheckthedetailsoffewerrorsthatusershavereported.Yousearchforthealertlogfileandexecutefewcommandstofindthelocationofthealertlogfile.ViewtheExhibitandcheckthecommandsexecuted.Whatisthelocationofthealert_orcl.logfile（）A.ORACLE_HOME/dbsB.ORACLE_HOME/rdbmsC./u01/app/oracle/admin/orcl/adumpD./u01/app/oracle/flash_recovery_areaE.ORACLE_BASE/diag/rdbms/orcl/orcl/alertF.ORACLE_BASE/diag/rdbms/orcl/orcl/trace

3.Examine the following values of the initialization parameters in the database having the SID ORCL:BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdumpUSER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udumpCORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdumpDIAGNOSTIC_DEST=The environment variables have the following value:ORACLE_BASE=/u01/app/oracleORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1What is the location of the Automatic Diagnostic Repository (ADR) home?（）A./u01/app/oracle/product/11.1.0/db_1B./u01/app/oracleC.$ORACLE_HOME/bdumpD.$ORACLE_HOME/log

4.ExaminethecommandsexecutedinaDBAsession：SQL>CREATEBIGFILETABLESPACEMRKT2DATAFILE’/u01/app/oracle/oradata/orcl/mrkt.dbf’size10MLOGGING3EXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO；Tablespacecreated.SQL>ALTERDATABASEDEFAULTTABLESPACEMRKT；Databasealtered.WhichtwostatementsaretrueregardingtheMRKTtablespace（）A.Nomoredatafilescanbeaddedtothetablespace.B.Segmentspaceismanagedbyfreelistsinthetablespace.C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit

更多“You executed the following command:RMAN> RECOVER COPY OF DATAFILE ‘／u01／app／oracle／oradata／orcl／users01.dbf‘;Which statement regarding the above command is correct?() ”相关问题

  • 第1题：

    Whileworkingonthedatabase，youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’YoudecidetorecoverthecorrupteddatablockbyusingtheBlockMediaRecoveryfeature.WhichoptionisNOTadisadvantageofusingblockmediarecovery？（）

    A.BlockMediaRecoverymustbeusedwithRMAN.

    B.Youmustperformcompleterecoveryofindividualblocks.

    C.YoumusthaveafullRMANbackup，notanincrementalbackup.

    D.YoumustusetheDBVERIFYutilitybeforeusingtheBlockMediaRecoveryfeature.


    参考答案：D

  • 第2题：

    Youissuethefollowingstatement：SQL>SELECTFIRSTNAME，LASTNAMEFROMHR.EMPLOYEE；Youreceivethefollowingerror：01578：ORACLEdatablockcorrupted（file6，block54）ORA-01110：datafile6：’u01/oracle/oradata/data1.dbf’Howwillyouresolvethisproblemofdatablockcorruptionbyreducingthemeantimetorecover（MTTR）？（）

    A.byusingtheDBMS_REPAIRpackage

    B.byusingtheDBVERIFYutility

    C.byusingBlockMediaRecovery

    D.byissuingtheANALYZETABLEHR.EMPLOYEESVALIDATESTRUCTUREcommand


    参考答案：C

  • 第3题：

    YouworkasadatabaseadministratoratCertkiller&ensp

    YouworkasadatabaseadministratoratCertkiller.com.YourdatabaseisopenandrunninginARCHIVELOGmode.YoutakeRMANfullbackupseverySundaynight.OnMondaymorning，whilequeryingtheuser1.employeestable，youreceivethefollowingerrormessage：

    01578：ORACLEdatablockcorrupted（file#5，block#51）

    ORA-01110：datafile5：’/u01/app/oracle/oradata/orcl/example01.dbf’

    Youneedtorectifythecorruptionwhileensuringthefollowing：

    Thedatafileshouldremainonline.

    Themeantimetorecover（MTTR）shouldbeminimal.

    Youarenotusingabackupcontrolfileandallthearchivedlogsareaccessible.

    Whichoptionwouldyouchoose？（）


    参考答案：D

  • 第4题：

    Youralertlogfilehasthefollowinginformation：TueMay2517：43：382004ORA-00060：Deadlockdetected.Moreinfoinfile/u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.Whatwouldyoudotoensurethatdatabaseisstillrunningcorrectly？（）

    A.examinethetracefileandkillthesessionthatcausedthedeadlock

    B.examinethetracefileandkillboththesessionsresponsibleforthedeadlock

    C.examinethetracefilefordetailsandasktheuserwhocausedthedeadlocktorollbackthetransaction

    D.examinethetracefilefordetailsandrememberthatdeadlocksareresolvedautomaticallybyOracledatabase

    E.examinethetracefilefordetailsandusetheUndoAdvisortorollbackthetransactionthatcausedthedeadlock


    参考答案：D

  • 第5题：

    Youexecutedthefollowingcommand:RMAN>RECOVERCOPYOFDATAFILE’／u01／app／oracle／oradata／orcl／users01.dbf’;Whichstatementregardingtheabovecommandiscorrect?()

    A.The’/u01/app/oracle/oradata/orcl/users01.dbf’datafileisrecoveredfromtheimagecopy.

    B.The’/u01/app/oracle/oradata/orcl/users01.dbf’datafileisrecoveredfromthelastincrementalbackup.

    C.Imagecopiesofthe’/u01/app/oracle/oradata/orcl/users01.dbf’datafileareupdatedwithallchangesuptoincrementalbackupSCN.

    D.Imagecopiesofthe’/u01/app/oracle/oradata/orcl/users01.dbf’datafilearerecoveredusingtheabovecommandifdatafilerecoveryfails.


    参考答案：C

相关内容