ocp1z数据恢复指导可处理以下两种情况一种是因必需数据库文件缺失

IdentifytwosituationsinwhichyoucanuseDataRecoveryAdvisorforrecovery.(ChooseTheuserhasdroppedanimportanttablethatneedstobeThedatabasefilesarecorruptedwhenthedatabaseisYouarenotabletostartupthedatabaseinstancebecausetherequireddatabasefilesareThearchivedlogfilesaremissingforwhichbackupisnotAnswer:BCExaminethefollowingvaluesoftheinitializationparametersinthedatabasehavingtheSIDTheenvironmentvariableshavethefollowingWhatisthelocationoftheAutomaticDiagnosticRepository(ADR)Answer:如果ORACLE_BASE环境变量已设置，则DIAGNOSTIC_DEST被设置为$ORACLE_BASE theADRrootdirectoryisknownasADRbase.ItslocationissettheDIAGNOSTIC_DESTinitializationparameter.Ifthisparameterisomittedorleftnull,thedatabasesetsDIAGNOSTIC_DESTuponstartupasfollows:IfenvironmentvariableORACLE_BASEisset,DIAGNOSTIC_DESTissettothedirectorydesignatedbyORACLE_BASE.IfenvironmentvariableORACLE_BASEisnotset,DIAGNOSTIC_DESTissettoWithinADRbase,therecanbemultipleADRhomes,whereeachADRhomeistherootdirectoryforalldiagnosticdata—traces,dumps,thealertlog,andsoon—foraparticularinstanceofaparticularOracleproductorcomponent.Forexample,inanOracleRealApplicationClustersenvironmentwithOracleASM,eachdatabaseinstance,OracleASMinstance,andlistenerhasanADRhome.ObservethefollowingPL/SQLWhichstatementiscorrectregardingtheabovePL/SQLItautomaticallypurgestheSQLmanagementobjectswhenSMBoccupiesmorethan30%oftheSYSAUXtablespace.Itreserves30%ofthespaceintheSYSAUXtablespaceforSQLManagementBaseItreserves30%ofthespaceintheSYSTEMtablespaceforItgeneratesaweeklywarninginthealertlogfilewhenSMBoccupiesmorethan30%oftheSYSAUXtablespace.Answer:参考 WhenthespaceoccupiedbySQLmanagementbaseexceedsthedefinedspacebudgetlimit,aweeklydatabasealertisgenerated.Table136-6Names&ValuesforCONFIGUREProcedureumpercentofSYSAUXspacethatcanbeusedforSQLmanagementbase1,2,…,Numberofweekstoretainunusednsbeforetheyarepurged5,6,…,DBMS_SPMSQLSQL执行计划，SQL计划管理功能SQLSQL语SQL计划基线能够随后用于保证适当的性能，即使是在系统发生改变SQLSQL执行计划：SQL计划基线能显著地减少由于数据库更新带来的性能问题。有时部署新的系统模块相当于新的SQL语句到系统中，应用程序需要有适当的SQLSQL计划基线能在随DBMS_SPMSYSADMINISTERSQLMANAGEMENTOBJECT权限才可以执行这个包CONFIGURESQLparameter/value的格式。这个函数CONFIGUREThisproceduresetsconfigurationoptionsforSQLmanagementbase,inparameter/valueformat.Thisfunctioncanbecallednumeroustimes,eachtimesettingadifferentconfigurationoption. INNUMBER);Table136-5CONFIGUREProcedureNameofparametertoset(seetableValueofparametertouse(seetableTable136-6Names&ValuesforCONFIGUREProcedureumpercentofSYSAUXspacethatcanbeusedforSQLmanagementbase1,2,…,Numberofweekstoretainunusednsbeforetheyarepurged5,6,…,UsageThedefaultspacebudgetforSQLmanagementbaseisnomorethantenpercentofthesizeofSYSAUXtablespace.Thespacebudgetcanbesettoaumof50%.Thedefaultunusednretentionperiodisoneyearandoneweek,whichmeansanwillbeautomaticallypurgedifithasnotbeenusedformorethanayear.Theretentionperiodcanbesettoaumof523weeks(i.e.alittleover10years).WhenthespaceoccupiedbySQLmanagementbaseexceedsthedefinedspacebudgetlimit,aweeklydatabasealertisgenerated.这个参数是设置最大的在SYSAUX空间上的百分比，并且如果超过空间阈值则每周会告警,D参考 15.6.1DiskSpaceDiskspaceusedbytheSMBisregularlycheckedagainstalimitbasedonthesizeoftheSYSAUXtablespace.Bydefault,thelimitfortheSMBisnomorethan10%ofthesizeofSYSAUX.Theallowablerangeforthislimitisbetween1%and50%.AweeklybackgroundprocessmeasuresthetotalspaceoccupiedbytheSMB.Whenthedefinedlimitisexceeded,theprocesswritesawarningtothealertlog.Thedatabasegeneratesalertsweeklyuntiloneofthefollowingconditionsismet:TheSMBspacelimitisThesizeoftheSYSAUXtablespaceisThediskspaceusedbytheSMBisdecreasedbypurgingSQLmanagementobjects(SQLnbaselinesorSQLprofiles)Tochangethepercentagelimit,usetheCONFIGUREprocedureoftheDBMS_SPMpackage.Thefollowingexamplechangesthespacelimitto30%:/OCP-1Z0-053-V13.02-477YouaremanaginganOracleDatabase11gASMinstancehavingthreedisksinadiskgroupwithASMcompatibilityattributesetto11.1.0andredundancysettohigh.Oneofthedisksinthediskgroup esunavailablebecauseofpowerfailure.Whichstatementswillbetrueinthisscenario?(Chooseallthatapply.)ThediskisimmediaydroppedfromthediskTheASMtrackstheextentsthataremodifiedduringtheTheASMmigratestheextentsfromtheunavailabledisktotheremainingThediskautomaticallygoesAnswer:BDACWhichstatementsaretrueregardingtablecompression?(ChooseallthatItsavesdiskspaceandreducesmemoryItsavesdiskspacebuthasnoeffectonmemoryItincursextraCPUoverheadduringDMLaswellasdirectloadingItincursextraCPUoverheadduringDMLbutnotdirectloadingIt pressoperationduringAnswer:参考 ConsiderUsingTableAsyourdatabasegrowsinsize,considerusingtablecompression.Compressionsavesdiskspace,reducesmemoryuseinthedatabasebuffercache,andcansignificantlyspeedqueryexecutionduringreads.CompressionhasacostinCPUoverheadfordataloadingandDML.However,thiscostmightbeoffsetbyreducedI/Orequirements.YouareworkingasaDBAonthedecisionsupportsystem.Thereisabusinessrequirementtotrackandstorealltransactionsforatleastthreeyearsforafewtablesinthedatabase.Automaticundomanagementisenabledinthedatabase.Whichconfigurationshouldyouuseto thistask?EnableFlashbackDataArchivefortheSpecifyundoretentionguaranteefortheEnablesupplementalloggingfortheQueryV$UNDOSTATtodeterminetheamountofundothatwillbegeneratedandcreateanundotablespaceforthatsize.CreateFlashbackDataArchiveonthetablespaceonwhichthetablesareAnswer:参考：闪回数据归档概述：闪回数据归档实验测试：WhichcomponentsareneededforsuccessfulandmostefficientThebackupRB3andthecurrentonlineredologthebackupRB2andthearchivedredologfilesafterthelogsequencenumberBackupR81andthearchivedredologhiesafterthelogsequencenumberThebackupRB3andthearchivedredologfilesafterthelogsequencenumberAnswer:redoYouaremanaginganOracleDatabase11ginstancewithASMstorage.YoulostanASMdiskgroupDATA.YouhaveRMANbackupofdataaswellasASMmetadatabackup.Youwanttore-createthemissingdiskgroupbyusingtheASMCMDmd_restorecommand.Whichofthesemethodswouldyouusetoachievethis?(Chooseallthatapply.)Restorethediskgroupwiththeexactconfigurationasthebacked-updiskgroup,usingthesamediskgroupname,samesetofdisks,failuregroupconfigurations,anddataonthediskgroup.Restorethediskgroupwiththeexactconfigurationasthebacked-updiskgroup,usingsamediskgroupname,samesetofdisks,andfailuregroupRestorethediskgroupwithchangeddiskgroupspecification,failuregroupspecification,diskgroupname,andotherdiskattributes.RestoremetadatainanexistingdiskgroupbypassingtheexistingdiskgroupnameasaninputAnswer:md_restoredataAWhichstatementdescribestheeffectoftableredefinitiononthetriggersattachedtotheAlltriggersonthetableareinvalidatedandareautomaticallyrevalidatedwiththenextDMLexecutiononthetable.Alltriggersonthetableareinvalidatedandmustbemanually piledbeforethenextDMLexecutiononthetable.AlltriggersonthetableremainOnlytriggersthatareaffectedbythechangestothestructureofthetableareinvalidatedandautomaticallyrevalidatedwiththenextDMLexecutiononthetable.Answer:题目解答：只有YountocollecttheAutomaticWorkloadRepository(AWR)dataeveryMondaymorningforamonth.YouwantOracleDatabasetoautomaticallycreateabaselineeveryMondayandremovetheoldbaseline.Whatisthecorrectactiontoachievethis?CreateandpopulateaSQLTuningSetfromtheAWRoneveryChangetheRETENTIONsettingfortheAWRsnapshotsto7daysonCreatearepeatingbaselinetemInsertafindingdirectiveforfutureADDMAnswer:参考 CreatingaRepeatingBaselineTemThissectiondescribeshowtocreatearepeatingbaselinetemte.Arepeatingbaselinetemtecanbeusedtoautomaticallycreatebaselinesthatrepeatduringaparticulartimeintervaloveraspecificperiodinthefuture.Forexample,youcancreatearepeatingbaselinetemtetogenerateabaselinethatrepeatseveryMondayfrom5:00p.m.to8:00p.m.fortheyear2009.Tocreatearepeatingbaselinetemte,usetheCREATE_BASELINE_TEMTEprocedure:/

day_of_week=>'monday',hour_in_day=>17,duration=>3,expiration=>30,start_time=>'2009-04-0217:00:00end_time=>'2009-12-3120:00:00baseline_name_prefix=>'baseline_2009_mondays_',temte_name=>'temte_2009_mondays',dbid Theday_of_weekparameterspecifiesthedayoftheweekonwhichthebaselinewillrepeat.Thehour_in_dayparameterspecifiesthehourinthedaywhenthebaselinewillstart.Thedurationparameterspecifiestheduration,innumberofhours,thatthebaselinewilllast.Theexpirationparameterspecifiesthenumberofdaystoretaineachcreatedbaseline.IfsettoNULL,thenthebaselinesneverexpires.Thestart_timeparameterspecifiesthestarttimeforthebaselinetobecreated.Theend_timeparameterspecifiestheendtimeforthebaselinetobecreated.Thebaseline_name_prefixparameterspecifiesthenameofthebaselineprefixthatwillbeappendedtothedatainformationwhenthebaselineiscreated.Thetemte_nameparameterspecifiesthenameofthebaselinetemte.Theoptionaldbidparameterspecifiesthedatabaseidentifier.Ifunspecified,thenthelocaldatabaseidentifierisusedasthedefaultvalue.Inthisexample,abaselinetemtenamedtemte_2009_mondaysiscreatedthatwillgenerateabaselineoneveryMondayfrom5:00p.m.to8:00p.m.beginningonApril2,2009at5:00p.m.andendingonDecember31,2009at8:00p.m.onthedatabasewithadatabaseID .Eachofthebaselineswillbecreatedwithabaselinenamewiththeprefixbaseline_2009_mondays_andwillexpireafter30days.DropaBaselineTemThissectiondescribeshowtodropanexistingbaselinetemte.Periodically,youmaywanttoremovebaselinestemtesthatarenolongerusedtoconservediskspace.TodropabaselinetemReviewtheexistingbaselinesintheDBA_HIST_BASELINE_TEMTEviewtodeterminethebaselinetemteyouwanttodrop.UsetheDROP_BASELINE_TEMTEproceduretodropthedesiredbaselinetemte:temte_name=>'temte_2009_mondays',dbid=> /Thetemte_nameparameterspecifiesthenameofthebaselinetemtethatwillbedropped.Intheexample,thenameofbaselinetemtethatwillbedroppedistemte_2009_mondays.Theoptionaldbidparameterspecifiesthedatabaseidentifier,whichinthisexample .Ifyoudonotspecifyavaluefordbid,thenthelocaldatabaseidentifierisusedasthedefaultvalue.Whichthreestatementsaretrueregardingpersistentlightweightjobs?(ChoosePersistentlightweightjobsmodifyseveraltablesinthedatadictionarytogeneratealotofTheusercannotsetprivilegesonpersistentlightweightPersistentlightweightjobsareusefulwhenusersneedtocreatealargenumberofjobsinashorttime.Persistentlightweightjobsareusefulwhenusersneedtocreateasmallnumberofjobsthatruninfrequently.TheuseofatemteismandatorytocreatepersistentlightweightAnswer:638题：向磁盘写入状态信息，所以在执行时应该量改进。持久轻量作业有多种限制：用户无法设置对这些作业的权限，它们将从父作业模板中继承其权限。--B必须使用模板，无法创建完全自包含的持久轻量作业。E（10100个作业（作业模板）可供使用，则最适合使用轻量作业。--C对Yourdatabaseinitializationparameterfilehasthefollowingentry:WhichstatementistrueregardingthisItdropstheconnectionafterthespecifiednumberofloginattemptsfailforanyItisendonlyifthepasswordprofileisenabledfortheItlockstheuseraccountafterthespecifiednumberofItdropstheconnectionafterthespecifiednumberofloginattemptsfailonlyforuserswhohavetheSYSDBAprivilege.Answer:A考 SEC_MAX_FAILED_LOGIN_ATTEMPTSspecifiesthenumberofauthenticationattemptsthatcanbemadebyaonaconnectiontotheserverprocess.Afterthespecifiednumberoffailureattempts,theconnectionwillbeautomaticallydroppedbytheserverprocess.WhichstatementistrueregardingvirtualprivateAvirtualprivatecatalogownercancreatealocalstoredscript,andhaveread/writeaccesstoaglobalstoredscript.ThevirtualprivatecatalogownercannotcreateandmodifythestoredThesetofviewsandsynonymsthatmakeupthevirtualprivatecatalogisstoredintheschemaoftheRMANrecoverycatalogowner.ToperformmostoftheRMANoperations,thevirtualcatalogownermusthavetheSYSDBAorSYSOPERprivilegeonthetargetdatabase.Answer:参考：作为虚 所有者，你只能查看授予了你权限的数据库 RMAN 的所有者必须对目标数据库具有SYSDBASYSOPERWhichtaskscanbe plishedusingtheEnterpriseManagerSupportWorkbenchinOracleDatabase11g?(Chooseallthatapply.)GeneratereportsondatafailuresuchasdatafileYoucantracktheServiceRequest(SR)andimplementYoucanpackageanduploaddiagnosticdatatoOracleYoucanmanuallyrunhealthcheckstogatherdiagnosticdataforaAnswer:参考：C.Oracle支持。WhataretheadvantagesofvariableextentsizesupportforlargeASMfiles?(ChooseItimprovesresyncoperationswhenthediskcomesonlineafterbeingtakenofflineformaintenancepurposes.Itimprovesperformanceintheextendedclusterconfigurationbyreadingfromalocalcopyofanextent.Fewerextentpointersareneededtodescribethefileandlessmemoryisrequiredtomanagetheextentmapsinthesharedpool.Thisfeatureenablesfasterfileopensbecauseofthereductionintheamountofmemorythatisrequiredtostorefileextents.Answer:参考 D.此功能可以更快地打开文件，因为需要文件区的内存量减少。ThecontentsofOracleASMfilesarestoredinadiskgroupasaset,orcollection,ofextentsthatarestoredonindividualdiskswithindiskgroups.Eachextentresidesonanindividualdisk.Extentsconsistofoneormoreallocationunits(AU).To modateincreasinglylargerfiles,OracleASMusesvariablesizeextents.VariablesizeextentsenablesupportforlargerOracleASMdatafiles,reduceSGAmemoryrequirementsforverylargedatabases,andimproveperformanceforfilecreateandopenoperations.Theinitialextentsizeequalsthediskgroupallocationunitsizeanditincreasesbyafactorof4or16atpredefinedthresholds.Thisfeatureisautomaticfornewlycreatedandresizeddatafileswhenspecificdiskgroupcompatibilityattributesaresetto11.1orhigher.TheextentsizeofafilevariesasExtentsizealwaysequalsthediskgroupAUsizeforthefirst20000extentsets(0-19999).Extentsizeequals4*AUsizeforthenext20000extentsets(20000-39999).Extentsizeequals16*AUsizeforthenext20000andhigherextentsetsWhichtwoaretheusesoftheASMmetadatabackupandrestore(AMBR)feature?(ChooseItcanbeusedtobackupalldataonASMItcanbeusedtorecoverthedamagedASMdiskgroupalongwiththeItcanbeusedtogatherinformationaboutapreexistingASMdiskgroupwithdiskpaths,diskname,failuregroups,attributes,temtes,andaliasdirectorystructure.Itcanbeusedtore-createtheASMdiskgroupwithitsAnswer:题目解答:ABdata是不能的,WhichtwochangesandtheireffectonthesystemcanbetestedbyusingtheDatabaseReyfeature?(Choosetwo.)multiplexingofthecontroladdingtheredologmembertothedatabaseandoperatingsystemchangingthedatabasestoragetoASM-managedAnswer:题目解答:ABWhichisthesourceusedbyAutomaticSQLTuningthatrunsaspartoftheAUTOTASKSQLstatementsthatarepartoftheAWRbaselineSQLstatementsbasedontheAWRtopSQLSQLstatementsthatarepartoftheavailableSQLTuningSet(STS)SQLstatementsthatareavailableinthecursorcacheandexecutedbyauserotherthanAnswer:题目解答AConly错,DWhileperformingthebackupoftheflashrecoveryarea,younoticethatoneofthearchivedredologfilesismissing.Youhavemultipledestinationsforarchivedredologfiles.Whatimplicationsdoesithaveonthebackupoftheflashrecoveryarea?ThebackupfailsbecauseoneofthearchivedredologfilesisThebackupsucceedsbutitwouldbewithoutthemissingarchivedDuringbackup,youarepromptedforthealternativedestinationforthemissingarchivedredologfile.ThebackupsucceedsbecauseitfailsovertooneofthealternativearchivedredologAnswer:YouaremanaginganOracleDatabase11ginstanceandanOracleDatabase10ginstanceonthesamemachine.BothinstancesusetheASMinstanceasstorage.WhichstatementregardingtheASMdiskgroupcompatibilityattributesaretrueinthisscenario?(Chooseallthatapply.) patibilityversionsettingsforeachinstancemustbegreaterthanorequaltotheRDBMScompatibilityofallASMdiskgroupsusedbythatdatabaseinstances.RDBMScompatibilityandthedatabaseversiondetermineswhetheradatabaseinstancecanmounttheASMdiskgroup.TheRDBMScompatibilitysettingsforadiskgroupcontroltheformatofdatastructuresforASMmetadataonthedisk.ASMcompatibilitycontrolswhichfeaturesfortheASMwillbeAnswer:ABDASM磁盘组的兼容性有三种：涉及描述磁盘组的持久性数据结构，客户机（磁盘组的使用者“ASM兼容性”“RDBMS兼容性”和“ADVM兼容性”。每个磁盘组的兼容性都可以独立控制。这是支持包含OracleDatabase10gOracleDatabase11g磁盘组的异构环境所必需的。ASM•RDBMSRDBMSASM实例与数据库(RDBMS)实例间交换消息的格式。ASM实例可以支持RDBMSASM实例通常在不同的OracleASM实例不同的软件版本。数据库ASM实例时，系统会协定这两个实例都支持的最高版本。•ASMASM元数据的数据结构格式的持久性兼容性设置。ASMRDBMSASMASM元数据的格式相关。文件内容的格式取决于数据库实例。例如，可以ASM11.0RDBMS10.1。这11.0ASM10.1ADVMOracleASM11.2或更高。设COMPATIBLE.ASM11.2ADVM卷但是，提高磁盘组兼容性是一个不可逆的操作。可以使用CREATEDISKGROUP命令或ALTERDISKGROUP命令来设置磁盘组兼容性。据库或ASM实例，具体取决于instance_type参数。例如，将该参数设置为10.1将使OracleDatabase11g中引入的任何新功能（磁盘联机/脱机、可变区等。WhichthreestatementsaretrueregardingthefunctioningoftheAutotaskBackgroundProcess(ABP)?(Choosethree.)ItcreatesjobswithoutconsideringtheprioritiesassociatedwithIttranslatestasksintojobsforexecutionbytheItdeterminesthelistofjobsthatmustbecreatedforeachmaintenanceItisspawnedbytheMMONbackgroundprocessatthestartofthemaintenanceItmaintainsarepositoryintheSYSTEMtablespacetostorethehistoryoftheexecutionofallAnswer:AEWhichstatementsaretrueregardingtheconceptofproblemsandsinthefaultdiagnosabilityinfrastructureforOracleDatabase11g?(Chooseallthatapply.)OnlythemetadataanddumpsarestoredintheAutomaticDiagnosticRepositoryTheproblemkeyisthesameastheThedatabasesendsanalerttotheOracleEnterpriseManagerDatabaseHomeEveryproblemhasaproblemkey,whichisatextstringthatdescribestheThedatabasemakesanentryintothealertlogfilewhenproblemsandsAnswer:Whattwostatementsaretrueregardingthe mendationsreceivedfromtheSQLAccessAdvisor?(Choosetwo.)Itcannot mendationsthatsupportmultipleworkloadItcan mendpartitioningontablesprovidedthattheworkloadshavesomepredicatesandjoinsonthecolumnsoftheNUMBERorDATEtype.It mendpartitioningonlyontablesthathaveatleast10,000It mendonlyB-treeindexesandnotbitmaporfunction-basedAnswer:题目解答A能,D中索引都可以BCYouaremanagingOracleDatabase11gwithanASMstoragewithhighredundancy.Thefollowingcommandwasissuedtodropthedisksfromthedgadiskgroupafterfivehours:ALTERDISKGROUPdgaOFFLINEDISKSINFAILGROUPf2DROPAFTERWhichstatementistrueinthisItstartstheASMfastmirrorAllthedisksinthedgadiskgroupwouldbeOFFLINEandtheDISK_REPAIR_TIMEdiskattributewouldbesetto5hours.ItdropsalldiskpathsfromthedgadiskAllthedisksinthedgadiskgroupinfailuregroupf2wouldbeOFFLINEandtheDISK_REPAIR_TIMEdiskattributewouldbesetto5hours.Answer:参考 Usethedisk_offline_clausetotakeoneormoredisksoffline.Thisclausefailsiftheredundancylevelofthediskgroupwouldbeviolatedbytakingthespecifieddisksoffline.Specifydisk_nameasshownintheNAMEcolumnoftheV$ASM_DISKdynamicperformanceTheQUORUMandREGULAR havethesamesemanticshereastheyhavewhenaddingadisktoadiskgroup.Bydefault,OracleASMdropsadiskshortlyafteritistakenoffline.Youcandelaythisoperationbyspecifyingthetimeout_clause,whichgivesyoutheopportunitytorepairthediskandbringitbackonline.Youcanspecifythetimeoutvalueinunitsofminuteorhour.Ifyouomittheunit,thenthedefaultishour.Youcanchangethetimeoutperiodbyspecifyingthisclausemultipletimes.Eachtimeyouspecifyit,OracleASMmeasuresthetimefromthemostrecentpreviousdisk_offline_clausewhilethediskgroupismounted.TolearnhowmuchtimeremainsbeforeOracleASMwilldropanofflinedisk,querytherepair_timercolumnofV$ASM_DISK.Thisclauseoverridesanyprevioussettingofthedisk_repair_timeWhichstatementdescribesthesignificanceoftheCHANGEFAILUREcommandinRMAN?(Chooseallthatapply.)ItisusedtochangefailurepriorityonlyforHIGHorLOWItisusedtoexecutetheadvisedrepairItisusedtochangefailurepriorityonlyfortheCRITICALItisusedtoexplicitlyclosetheopenItisusedtoinformthedatabaseabouttherepairaftertherepairscriptAnswer:参考 Ifappropriate,youcanuseCHANGEFAILUREcommandatanytimeintheDataRecoveryAdvisorworkflowtochangethepriorityofafailurefromLOWtoHIGHorHIGHtoLOW,orcloseafailurethathasbeenfixedmanually.ChangingFailureStatusandInsomesituations,youmaywanttousetheCHANGEFAILUREcommandtoalterthestatusorpriorityofafailure.Forexample,ifablockcorruptionhasHIGHpriority,youmaywanttochangeittoLOWtemporarilyiftheblockisinalittle-usedtablespace.IfyourepairafailurebyameansotherthantheREPAIRFAILUREcommand,thenDataRecoveryAdvisorclosesitimplicitlythenexttimeyouexecuteLISTFAILURE.Forthisreason,youdonotnormallyneedtoexecutetheCHANGEFAILURE...CLOSEDcommand.Youshouldneedtousethiscommandonlyiftheautomaticfailurerevalidationfails,butyoubelievethefailurenolongerexists.IfyouuseCHANGEFAILUREtocloseafailurethatstillexists,thenDataRecoveryAdvisorre-createsitwithadifferentfailureIDwhentheappropriatedataintegritycheckisexecuted.Typically,youspecifythefailuresbyfailurenumber.YoucanalsochangefailuresinbulkbyspecifyingALL,CRITICAL,HIGH,orLOW.YoucanchangeafailuretoCLOSEDortoPRIORITYHIGHorPRIORITYLOW.TochangethestatusorpriorityofaListfailuresasdescribedin"ListingAllThefollowingexamplelistsonefailureinvolvingcorruptdatablocks.RMAN>LISTFAILURE;ListofDatabaseFailureIDPriority TimeDetected Oneormorenon-systemare containsoneormorecorruptblocksExecuteCHANGEFAILUREwiththedesiredThefollowingexamplechangesthepriorityofablockcorruptionfailurefromHIGHtoLOW.RMAN>CHANGEFAILURE101PRIORITYLOW;ListofDatabaseFailureIDPriority TimeDetected Datafile25:'/disk1/oradata/prod/example01.dbf'containsoneormorecorruptblocksDoyoureallywanttochangetheabovefailures(enterYESorNO)?YESchanged1failurestoLOWpriorityOptionally,executeLISTFAILUREALLtoviewtheIfyouexecuteLISTFAILUREwithoutALL,thenthecommandlistsfailureswithLOWpriorityonlyifnoCRITICALorHIGHpriorityfailuresexist.RMAN>LISTFAILUREListofDatabaseFailureIDPriority TimeDetected Oneormorenon-systemare containsoneormorecorruptblocks126.Which126.Whichstatementsaretrueregardingthecreationof packagefilebyusingtheEMWorkbenchSupport?(ChooseallthatYoucanaddorremovethetracefilestotheYoucancreatetheincrementalpackageZIPfilefornewormodifieddiagnosticinformationforthepackagealreadycreated.YoucanaddSQLtestcasestotheYoucannotcreateanincrementalpackagewhenthephysicalfilesarepurgedromtheAnswer:参考 AboutQuickPackagingandCustomTheEnterpriseManagerSupportWorkbenchprovidestwomethodsforcreatinganduploadinganpackage:thequickpackagingmethodandthecustompackagingmethod.QuickPackaging—Thisisthemoreautomatedmethodwithaminimumofsteps,organizedinaguidedworkflow(awizard).Youselectasingleproblem,provideapackagenameandandthenscheduleuploadofthepackagecontents,eitherimmediayorataspecifieddateandtime.TheSupportWorkbenchautomaticallycesdiagnosticdatarelatedtotheproblemintothepackage,finalizesthepackage,createsthezipfile,andthenuploadsthefile.Withthismethod,youdonothavetheopportunitytoadd,edit,orremovepackagefilesoraddotherdiagnosticdatasuchasSQLtestcases.However,itisthesimplestandquickestwaytogetfirst-failurediagnosticdatatoOracleSupport.Quickpackagingisthemethodusedintheworkflowdescribedin"Investigating,Reporting,andResolvingaProblem".Notethatwhenquickpackagingiscomplete,thepackagethatwascreatedbythewizardremains.YoucanthenmodifythepackagewithcustompackagingoperationsatalatertimeandmanuallyCustomPackaging—Thisisthemoremanualmethod,withmoresteps.ItisintendedforexpertSupportWorkbenchuserswhowantmorecontroloverthepackagingprocess.Withcustompackaging,youcancreateanewpackagewithoneormoreproblems,oryoucanaddoneormoreproblemstoanexistingpackage.Youcanthenperformavarietyofoperationsontheneworupdatedpackage,including:AddingorremovingproblemsorAdding,editing,orremovingtracefilesinthepackageAddingorremovingexternalfilesofanytypeAddingotherdiagnosticdatasuchasSQLtestManuallyfinalizingthepackageandthenviewingpackagecontentstodetermineifyoumusteditorremovesensitivedataorremovefilestoreducepackagesize.Youmightconducttheseoperationsoverseveraldays,beforedecidingthatyouhaveenoughdiagnosticinformationtosendtoOracleSupport.Withcustompackaging,youcreatethezipfileandrequestuploadtoOracleSupportastwoseparatesteps.Eachofthesestepscanbeperformedimmediayorscheduledforafuturedateandtime.10.SelecttheFullorIncrementaloptiontogenerateafullpackagezipfileoranincrementalpackagezipfile.Forafullpackagezipfile,allthecontentsofthepackage(originalcontentsandallcorrelateddata)arealwaysaddedtothezipfile.Foranincrementalpackagezipfile,onlythediagnosticinformationthatisnewormodifiedsincethelasttimethatyoucreatedazipfileforthesamepackageisaddedtothezipfile.Forexample,iftraceinformationwasappendedtoatracefilesincethatfilewaslastincludedinthegeneratedphysicalfileforapackage,thetracefileisaddedtotheincrementalpackagezipfile.Conversely,ifnochangesweremadetoatracefilesinceitwaslastuploadedforapackage,thattracefileisnotincludedintheincrementalpackagezipfile.Note:TheIncrementaloptionisdimmed(unavailable)ifanuploadfilewasnevercreatedfortheTheapplicationtablesownedbytheuserTESTinatestdatabaseneedtobeexportedtotheAPPSschemaintheproductiondatabasebyusingDataPump.WhichoptionofDataPumpImportwouldyouuseto plishthis?Answer:参考 Default:ThereisnodefaultLoadsallobjectsfromthesourceschemaintoatargetschema.SyntaxandDescriptionMultipleREMAP_SCHEMAlinescanbespecified,butthesourceschemamustbedifferentforeachone.However,differentsourceschemascanmaptothesametargetschema.Themapmaynotbe100percentcomplete,becausetherearecertainschemareferencesthatImportisnotcapableoffinding.Forexample,Importwillnotfindschemareferencesembeddedwithinthebodyofdefinitionsoftypes,views,procedures,andpackages.Iftheschemayouareremaptodoesnotalreadyexist,thentheimportoperationcreatesit,providedthatthedumpfilesetcontainsthenecessaryCREATEUSERmetadataforthesourceschema,andprovidedthatyouareimportingwithenoughprivileges.Forexample,thefollowingExportcommandscreatedumpfilesetswiththenecessarymetadatatocreateaschema,becauseth