Inyourdatabase，allthetablespacesarelocallymanaged.YoustartedRecoveryManager（RMAN）usingrecoverycatalogandrestoredthecontrolfilebyusingthefollowingcommand：RMAN>RESTORECONTROLFILEWhichtwooperationsdoyouneedtoperformafterrestoringthecontrolfilefrombackup？（）A.

题目

Inyourdatabase，allthetablespacesarelocallymanaged.YoustartedRecoveryManager（RMAN）usingrecoverycatalogandrestoredthecontrolfilebyusingthefollowingcommand：RMAN>RESTORECONTROLFILEWhichtwooperationsdoyouneedtoperformafterrestoringthecontrolfilefrombackup？（）

A.shutdownandrestarttheinstance

B.addnewtempfilestothetemporarytablespacesafterrecovery

C.performamediarecoveryandopenthedatabasewiththeRESETLOGSoption

D.performamediarecoveryandbringthedatabasetoNOARCHIVELOGmode

相似考题

1.YouexecutedthefollowingcommandinRecoveryManager(RMAN):RMAN>RESTORECONTROLFILEWhichoperationmustyouperformbeforethiscommandisexecuted?()A.backupthecontrolfiletotraceB.bringdatabasetotheMOUNTstateC.openaconnectiontotheRMANrecoverycatalog，whichcontainstheRMANmetadataforthetargetdatabaseD.setthedatabaseID（DBID），butonlyiftheDB_NAMEparameterassociatedwiththetargetdatabaseisuniqueintherecoverycatalog

2.Examine the following RMAN command:RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which prerequisite must be met before accomplishing the backup?()A. Provide a password for the encryptionB. Set up an Oracle wallet for the encryptionC. No setup is required as it is a default encryption methodD. Both Oracle wallet and password must be set up for the encryption

3.Youareperformingadatabaserecoverybecauseauser’sschemaisdropped.Whileperformingtherecovery,youusetheUNTILSEQUENCEclause.Whichtypeofdatabaserecoveryareyouperforming?()A.usermanagedcompleterecoveryB.usermanagedincompleterecoveryC.RMAN-basedcompleterecoveryD.RMAN-basedincompleterecovery

4.Whenrunningthetablespacepoint-in-timecommandrecovertablespaceusersuntiltime,,10/06/2008:22:42:00auxiliarydestination,,c:\oracle\auxiliary;youreceivethefollowingerror:RMAN-00571:===========================================================RMAN-00569:===============ERRORMESSAGESTACKFOLLOWS===============RMAN-00571:===========================================================RMAN-03002:failureofrecovercommandat10/08/200816:00:30RMAN-20202:TablespacenotfoundintherecoverycatalogRMAN-06019:couldnottranslatetablespacename"USERS"Whatisthelikelycauseoftheerror?（）A.ThedatabaseisinARCHIVELOGmode.B.Thereisnotacurrentbackupofthedatabaseavailable.C.TheUSERStablespacehasdependentobjectsinothertablespacesandcannotbeapartofaTSPITRalone.D.TheUSERStablespaceisnoteligibleforTSPITRbecauseithasinvalidobjects.E.Therecovertablespacecommandisincorrectandgeneratestheerror.

更多“Inyourdatabase,allthetablespacesarelocallymanaged.YoustartedRecoveryManager(RMAN)usingreco ”相关问题

  • 第1题：

    ThebackupretentionpolicyisconfiguredasRECOVERYWINDOW2.YouexecutedthefollowingcommandinRecoveryManager(RMAN)againstyourdatabase:RMAN>REPORTOBSOLETE;Whatwouldyouseeintheoutput?()

    A.alistofallthosefilesthathavebeendeletedinthelasttwodays

    B.alistofallthosefilesthathavebeenrecoveredwithinthelasttwodays

    C.alistofalltheexpiredbackupsandcopies

    D.alistofbackupsandcopiesthatareoutsidetherangecoveredbythecurrentretentionpolicy


    参考答案：D

  • 第2题：

    Inyourdatabase,youdiscoveredthatatempfileinalocallymanagedtemporarytablespacehasbeendeletedattheoperatingsystemlevel.Howwouldyourecoverthetablespace?()

    A.flashbackthedatabase

    B.performpoint-in-timerecovery

    C.performafulldatabaserecovery

    D.dropandre-createthetablespace

    E.useRecoveryManager（RMAN）torecoverthedatabase


    参考答案：D

  • 第3题：

    Inyourdatabase,onlineredologfilesaremultiplexedandoneofthemembersinagroupislostduetomediafailure?Howwouldyourecoverthelostredologmember?()

    A.importthedatabasefromthelastexport

    B.restoreallthemembersinthegroupfromthelastbackup

    C.dropthelostmemberfromthedatabaseandthenaddanewmembertothegroup

    D.restoreallthedatabasefilesfromthebackupandthenperformacompleterecovery

    E.restoreallthedatabasefilesfromthebackupandthenperformanincompleterecovery


    参考答案：C

  • 第4题：

    In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.How would you accomplish this?()

    A. Setting a metric threshold

    B. Implementing Database Resource Manager

    C. Enabling resumable timeout for user sessions

    D. Decreasing the value of the IDLE_TIME resource limit in the default profile


    参考答案：D

  • 第5题：

    YouexecutedthefollowingcommandinRecoveryManager(RMAN)againstyourOracle10gdatabase:RMAN>REPORTNEEDBACKUPdays3;Whatwouldbetheoutputofthiscommand?()

    A.alistoffilesthatrequireabackupwithinthreedays

    B.alistoffilesthathavenotbeenbackedupforthreedays

    C.alistoffilesthatRMANrecommendsbebackeduponlyonceineverythreedays，basedonlowvolatility

    D.alistoffilesforwhichabackuphasalreadybeenperformedandmayneedabackupafterthreedays


    参考答案：B

相关内容