单项选择题

Whatisthepurposeofthecatalogcommand?()

A.ToreviewRMANcontrolfileandrecoverycatalogmetadataandensurethatitscorrect
B.TodeleteRMANbackup-relatedmetadatafromtherecoverycatalog
C.Tocreatemetadatainthecontrolfileandtherecoverycatalogrelatedtobackupsetpieces
D.Tocreateareportthatlistsdatabasebackups
E.Torebuildtherecoverycatalog
热门 试题

单项选择题
YourdatabaseisinARCHIVELOGmode.OnFridayevening,youperformanonlinedatabasebackupbyusingtheBACKUPDATABASEcommandattheRecoveryManager(RMAN)promptandclosethedatabase.OnMonday,theSystemAdministratorinformsyouaboutthefailureoftwoharddisks.Oneofthelostdiskscontainstwodatafiles,HR1.DBFandHR2.DBF,bothofwhichbelongtoaread writetablespacenamedHR.Thediskalsocontainsadatafile,USERS.DBF,whichbelongstoaread writetablespacenamedUSERS.YouneedtorestoreandrecoverthedatabasebackupthatwasperformedonFridayevening.Aftermountingthedatabase,youissuethefollowingRMANcommands:RMAN>RESTOREDATABASE;RMAN>RECOVERDATABASE;AftersuccessfullyexecutingtheseRMANcommands,youissuethefollowingstatementusingSQL*Plus:SQL>ALTERDATABASEOPEN;Youreceivethefollowingerrorswhenattemptingtoopenthedatabase:ORA-01157:cannotidentify lockdatafile10seeDBWRtracefileORA-01110:datafile10:’D: USERS.DBF’Whatisthecauseoftheseerrors?()