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 th

题目

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.
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题：

ExaminethecommandsexecutedinaDBAsession：SQL>CREATEBIGFILETABLESPACEMRKT2DATAFILE’/u01/app/oracle/oradata/orcl/mrkt.dbf’size10MLOGGING3EXTENTMANAGEMENTLOCALSEGMENTSPACEMANAGEMENTAUTO；Tablespacecreated.SQL>ALTERDATABASEDEFAULTTABLESPACEMRKT；Databasealtered.WhichtwostatementsaretrueregardingtheMRKTtablespace（）

A.Nomoredatafilescanbeaddedtothetablespace.

B.Segmentspaceismanagedbyfreelistsinthetablespace.

C.Ausercreatedwithoutbeingassignedadefaulttablespaceusesthistablespace.

D.Thetablespacecanbedroppedwiththecurrentsettingwithsegmentspresentinit

参考答案：A, C

第2题：

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_1

B./u01/app/oracle

C.$ORACLE_HOME/bdump

D.$ORACLE_HOME/log

参考答案：B

第3题：

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

参考答案：C

第4题：

Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database. RMAN> COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’； Which two statements are true regarding the backup created using this command？（）

A、 The copy of the datafile created is stored in the RMAN repository.
B、 The copy of the datafile created can be viewed using the LIST BACKUP command.
C、 The copy of the datafile created using this COPY command can be placed only on the disk.
D、 The copy of the datafile created is similar to the backup of the file created using the BACKUP command.
E、 The copy of the datafile created can be used for recovering the database using the user-managed recovery method.

正确答案:C,E

第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

第6题：

Youwanttocheckthedetailsoffewerrorsthatusershavereported.Yousearchforthealertlogfileandexecutefewcommandstofindthelocationofthealertlogfile.ViewtheExhibitandcheckthecommandsexecuted.Whatisthelocationofthealert_orcl.logfile（）

A.ORACLE_HOME/dbs

B.ORACLE_HOME/rdbms

C./u01/app/oracle/admin/orcl/adump

D./u01/app/oracle/flash_recovery_area

E.ORACLE_BASE/diag/rdbms/orcl/orcl/alert

F.ORACLE_BASE/diag/rdbms/orcl/orcl/trace

参考答案：F

第7题：

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

第8题：

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.

参考答案：A

第9题：

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

第10题：

While working on the database， you receive the following error： 01578： ORACLE data block corrupted （file# 6， block # 54） ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’ You decide to recover the corrupted data block by using the Block Media Recovery feature. Which option is NOT a disadvantage of using block media recovery？（）

A、 Block Media Recovery must be used with RMAN.
B、 You must perform complete recovery of individual blocks.
C、 You must have a full RMAN backup， not an incremental backup.
D、 You must use the DBVERIFY utility before using the Block Media Recovery feature.

正确答案:D

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

题目

相似问题和答案

更多相关问题

相关内容