网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
Intheparameterfileofyourproductiondatabase,theCONTROL_FILE_RECORD_KEEP_TIMEparameterissetto31.WhatwouldbetheimpactofthissettingonthebackupthatisbeingperformedbyusingRecoveryManager(RMAN)?()
A.Thebackupwouldberetainedonthemediafor31days.
B.Thebackupwouldbemaintainedintherecoverycatalogfor31days.
C.Thebackupmetadatawouldberetainedinthecontrolfilefor31days.
D.Thebackupmetadatawouldbemaintainedintherecoverycatalogfor31days.
E.Automaticbackupsofthecontrolfilewillberetainedintheflashrecoveryareafor31days.
参考答案
更多 “ Intheparameterfileofyourproductiondatabase,theCONTROL_FILE_RECORD_KEEP_TIMEparameterissetto31.WhatwouldbetheimpactofthissettingonthebackupthatisbeingperformedbyusingRecoveryManager(RMAN)?() A.Thebackupwouldberetainedonthemediafor31days.B.Thebackupwouldbemaintainedintherecoverycatalogfor31days.C.Thebackupmetadatawouldberetainedinthecontrolfilefor31days.D.Thebackupmetadatawouldbemaintainedintherecoverycatalogfor31days.E.Automaticbackupsofthecontrolfilewillberetainedintheflashrecoveryareafor31days. ” 相关考题
考题
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.
考题
Intheparameterfileofyourproductiondatabase,theFAST_START_MTTR_TARGETparameteris setto300tooptimizeinstancerecovery.Whileobservingtheperformanceofthedatabaseduringinstancerecovery,youfindthattheredologfilesarenotsizedproperlytosupportthisactivity.Whichtwosourcescouldyouusetodeterminetheoptimalsizeoftheredologfiles?()A.theV$LOGviewB.theV$DBFILEviewC.theV$LOGFILEviewD.theV$INSTANCE_RECOVERYviewE.OracleEnterpriseManagerDatabaseControl
考题
Yourdatabaseisconfiguredonnon-ASMdiskstorage.YouneedtomigrateyourdatabasetoASMdiskstorage.Whichstatementistrueaboutmigratingfromnon-ASMdiskstoragetoASMdiskstorage?()
A.Youcanusetheoperatingsystemutilitytomigratefromnon-ASMdiskstoragetoASMdiskstorage.B.Youcannotperformadatabasebackupfromnon-ASMdiskstoragetotapeandthenmoveittoASMdiskstorage.C.YoucanusetheSWITCHDATABASETOCOPYRecoveryManager(RMAN)commandtoswitchbacktonon-ASMdiskstorageifyouhavenotdeletedyouroriginaldatafiles.D.YoucannotuseRecoveryManager(RMAN)tomigratefromnon-ASMdiskstoragetoASMdiskstorageifyouarenotusingRMANforyourbackupandrecoverystrategies.
考题
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
考题
YouwanttoimplementthebackupandrecoverystrategyinyourdatabaseusingRecoveryManager(RMAN).YouhavechosenthecontrolfileofthetargetdatabasefortheRMANrepository.Whichcommand-lineRMANcommandwouldyouusetoestablishalocalconnectionbetweenRMANandtheRMANrepositoryifyourdatabaseisusingpasswordfileauthentication?()A.rmanTARGET/NOCATALOGB.rmanTARGETsys/passwordC.rmanTARGETsys/passwordASSYSDBAD.rmanTARGETsys/password@db_nameCATALOGrman_user/rman_password@rcat
考题
ThebackupretentionpolicyisconfiguredasRECOVERYWINDOW2.YouexecutedthefollowingcommandinRecoveryManager(RMAN)againstyourdatabase:RMAN>REPORTOBSOLETE;Whatwouldyouseeintheoutput?()
A.alistofallthosefilesthathavebeendeletedinthelasttwodaysB.alistofallthosefilesthathavebeenrecoveredwithinthelasttwodaysC.alistofalltheexpiredbackupsandcopiesD.alistofbackupsandcopiesthatareoutsidetherangecoveredbythecurrentretentionpolicy
考题
YouexecutedthefollowingcommandinRecoveryManager(RMAN)againstyourOracle10gdatabase:RMAN>REPORTNEEDBACKUPdays3;Whatwouldbetheoutputofthiscommand?()
A.alistoffilesthatrequireabackupwithinthreedaysB.alistoffilesthathavenotbeenbackedupforthreedaysC.alistoffilesthatRMANrecommendsbebackeduponlyonceineverythreedays,basedonlowvolatilityD.alistoffilesforwhichabackuphasalreadybeenperformedandmayneedabackupafterthreedays
热门标签
最新试卷