Inyourdatabase，allthetablespacesarelocallymanaged.YoustartedRecoveryManager（RMAN）usingrecoverycatalogandrestoredthecontrolfilebyusingthefollowingcommand：RMANRESTORECONTROLFILEWhichtwooperationsdoyouneedtoperformafterrestoringthecontrolfilefrombackup？（）A.shutdownandrestarttheinstanceB.addnewtempfilestothetemporarytablespacesafterrecoveryC.performamediarecoveryandopenthedatabasewiththeRESETLOGSoptionD.performamediarecoveryandbringthedatabasetoNOARCHIVELOGmode
Inyourdatabase，allthetablespacesarelocallymanaged.YoustartedRecoveryManager（RMAN）usingrecoverycatalogandrestoredthecontrolfilebyusingthefollowingcommand：RMAN>RESTORECONTROLFILEWhichtwooperationsdoyouneedtoperformafterrestoringthecontrolfilefrombackup？（）
A.shutdownandrestarttheinstance
B.addnewtempfilestothetemporarytablespacesafterrecovery
C.performamediarecoveryandopenthedatabasewiththeRESETLOGSoption
D.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