网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

Inyourdatabase,allthetablespacesarelocallymanaged.YoustartedRecoveryManager(RMAN)usingrecoverycatalogandrestoredthecontrolfilebyusingthefollowingcommand:RMAN>RESTORECONTROLFILEWhichtwooperationsdoyouneedtoperformafterrestoringthecontrolfilefrombackup?()

A.shutdownandrestarttheinstance

B.addnewtempfilestothetemporarytablespacesafterrecovery

C.performamediarecoveryandopenthedatabasewiththeRESETLOGSoption

D.performamediarecoveryandbringthedatabasetoNOARCHIVELOGmode


参考答案

更多 “ Inyourdatabase,allthetablespacesarelocallymanaged.YoustartedRecoveryManager(RMAN)usingrecoverycatalogandrestoredthecontrolfilebyusingthefollowingcommand:RMANRESTORECONTROLFILEWhichtwooperationsdoyouneedtoperformafterrestoringthecontrolfilefrombackup?()A.shutdownandrestarttheinstanceB.addnewtempfilestothetemporarytablespacesafterrecoveryC.performamediarecoveryandopenthedatabasewiththeRESETLOGSoptionD.performamediarecoveryandbringthedatabasetoNOARCHIVELOGmode ” 相关考题
考题 YouexecutedthefollowingcommandinRecoveryManager(RMAN):RMAN>RESTORECONTROLFILEWhichoperationmustyouperformbeforethiscommandisexecuted?() A.backupthecontrolfiletotraceB.bringdatabasetotheMOUNTstateC.openaconnectiontotheRMANrecoverycatalog,whichcontainstheRMANmetadataforthetargetdatabaseD.setthedatabaseID(DBID),butonlyiftheDB_NAMEparameterassociatedwiththetargetdatabaseisuniqueintherecoverycatalog

考题 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:couldnottranslatetablespacenameUSERSWhatisthelikelycauseoftheerror?()A.ThedatabaseisinARCHIVELOGmode.B.Thereisnotacurrentbackupofthedatabaseavailable.C.TheUSERStablespacehasdependentobjectsinothertablespacesandcannotbeapartofaTSPITRalone.D.TheUSERStablespaceisnoteligibleforTSPITRbecauseithasinvalidobjects.E.Therecovertablespacecommandisincorrectandgeneratestheerror.

考题 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

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

考题 ThebackupretentionpolicyisconfiguredasRECOVERYWINDOW2.YouexecutedthefollowingcommandinRecoveryManager(RMAN)againstyourdatabase:RMAN>REPORTOBSOLETE;Whatwouldyouseeintheoutput?() A.alistofallthosefilesthathavebeendeletedinthelasttwodaysB.alistofallthosefilesthathavebeenrecoveredwithinthelasttwodaysC.alistofalltheexpiredbackupsandcopiesD.alistofbackupsandcopiesthatareoutsidetherangecoveredbythecurrentretentionpolicy

考题 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 thresholdB. Implementing Database Resource ManagerC. Enabling resumable timeout for user sessionsD. Decreasing the value of the IDLE_TIME resource limit in the default profile

考题 Inyourdatabase,youdiscoveredthatatempfileinalocallymanagedtemporarytablespacehasbeendeletedattheoperatingsystemlevel.Howwouldyourecoverthetablespace?() A.flashbackthedatabaseB.performpoint-in-timerecoveryC.performafulldatabaserecoveryD.dropandre-createthetablespaceE.useRecoveryManager(RMAN)torecoverthedatabase

考题 YouexecutedthefollowingcommandinRecoveryManager(RMAN)againstyourOracle10gdatabase:RMAN>REPORTNEEDBACKUPdays3;Whatwouldbetheoutputofthiscommand?() A.alistoffilesthatrequireabackupwithinthreedaysB.alistoffilesthathavenotbeenbackedupforthreedaysC.alistoffilesthatRMANrecommendsbebackeduponlyonceineverythreedays,basedonlowvolatilityD.alistoffilesforwhichabackuphasalreadybeenperformedandmayneedabackupafterthreedays

考题 Inyourdatabase,onlineredologfilesaremultiplexedandoneofthemembersinagroupislostduetomediafailure?Howwouldyourecoverthelostredologmember?() A.importthedatabasefromthelastexportB.restoreallthemembersinthegroupfromthelastbackupC.dropthelostmemberfromthedatabaseandthenaddanewmembertothegroupD.restoreallthedatabasefilesfromthebackupandthenperformacompleterecoveryE.restoreallthedatabasefilesfromthebackupandthenperformanincompleterecovery