其他

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/

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

如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

如下面这段监听配置中,sid_name的值来自于哪个参数? SID_LIST_LISTENER = (SID_DESC =(GLOBAL_DBNAME = orcl ) (ORACLE_HOME = ／u01／app／oracle／product／ 10. 2.0／db_1) (SID_NAME = orcl ) )()

A. INSTANCE_NAME

B. DB_NAME

C. DB_UNIQUE_NAME

D. SERVICE_NAMES

E. GLOBAL_NAMES


参考答案A

第2题：

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

第3题：

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

第4题：

WhenyoutrytostarttheDatabaseControlbyusingtheemctlstartdbconsolecommandthefollowingerrorisdisplayed：TZsettoAmerica/New_yorkOC4JConfigurationissue./u01/app/oracle/product/10.1.0/db_1/oc4j/j2ee/OC4J_DBConsole_orcl.us.oracle.comnotfound.WhichtwoenvironmentvariablesdoyouneedtosetappropriatelytoavoidsucherrorsandstarttheDatabaseControlsuccessfully？（）

A.NLS_LANG

B.ORACLE_SID

C.ORACLE_HOME

D.ORACLE_BASE

E.LD_LIBRARY_PATH


参考答案：B, C

第5题：

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

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

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

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

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

相关内容