oracleocp題庫-dba經(jīng)典輔助學(xué)習(xí)les2asm

自管自管目課程目標(biāo)確定自 管理(ASM)的特啟動(dòng)和關(guān)閉ASMASM用RMAN移植你的數(shù)據(jù)庫到自自 管理:回靈活和高性能的集群文件系管理Oracle數(shù)據(jù)庫文數(shù)據(jù)被分散在磁盤上，以平衡綜合磁盤鏡數(shù)據(jù)解決許 管理文件系卷管操作系Review(notesonlyslide)…ASM體系結(jié)構(gòu)概要ASM為了使用ASM實(shí)例，以下任務(wù)你必須執(zhí)行ASMASM為了使用ASM實(shí)例，以下任務(wù)你必須執(zhí)行ASMASMASMASMASM實(shí)例初始化參數(shù)ASM實(shí)例初始化參數(shù)INSTANCE_TYPE=ASMDB_UNIQUE_NAME=+ASMASM_POWER_LIMIT=1ASM_DISKSTRING='/dev/rdsk/*s2','/dev/rdsk/c1*'ASM_DISKGROUPS=dgroupA,dgroupBLARGE_POOL_SIZE=8MB改變數(shù)據(jù)庫實(shí)例參數(shù)…INSTANCE_TYPE=RDBMSLARGE_POOL_SIZE=8MB…啟動(dòng)啟動(dòng)一個(gè)ASM實(shí)$export$sqlplusSQL>CONNECT/ASsysdbaConnectedtoanidleinstance.SQL>STARTUP;ASMinstanceTotalSystemGlobalArea147936196bytesFixed 324548Variable 96468992Database 50331648RedoBuffers 811008bytesASMdiskgroupsmounted所有操非破壞性操磁盤磁盤系(notesonlyslide)(notesonlyslide)ASMASMASM性能ASM配置關(guān)閉關(guān)閉一個(gè)ASM實(shí)數(shù)據(jù)庫實(shí)例數(shù)據(jù)庫實(shí)例2ASM實(shí)例311SHUTDOWNDBCA選磁盤組鏡像AU標(biāo)準(zhǔn)鏡磁盤組鏡像AU標(biāo)準(zhǔn)鏡組合每個(gè)磁盤上的AU主鏡外部冗余 硬件鏡正常的冗余高度冗余diskDataASMASMrawOracle 使用基于文件類型的coarse-或fine- 條帶故障故障磁盤組故障組 故障組 故障組控制器控制器控制器磁盤磁盤組動(dòng)態(tài)自配置發(fā)生變化，不需要I/O優(yōu)聯(lián)機(jī)移植到在系統(tǒng)中使ASM_POWER_LIMIT配置載管理磁盤組數(shù)據(jù)庫實(shí)ALTERDROPCREATEASM 創(chuàng)建磁盤組頁ASM創(chuàng)建磁盤組頁創(chuàng)建創(chuàng)建和丟棄磁盤組DROPDISKGROUPdgroupAINCLUDINGCREATEDISKGROUPdgroupANORMALFAILGROUPcontroller1'/devices/A1'NAMEdiskA1SIZE120GFORCE,FAILGROUPcontroller2DISK添加磁盤到磁盤組磁盤格式磁盤組ALTERDISKGROUPdgroupAADDDISKALTERDISKGROUPdgroupAADD'/dev/rdsk/c0t4d0s2'NAMEA5,'/dev/rdsk/c0t5d0s2'NAMEA6,'/dev/rdsk/c0t6d0s2'NAMEA7,'/dev/rdsk/c0t7d0s2'NAMEA8;AddingAddingDiskstoDiskGroups(notesonlyslide)各種ALTER命令從dgroupA移動(dòng)一個(gè)磁盤在一個(gè)單獨(dú)令中添加和丟棄一個(gè)磁盤取消一個(gè)磁盤丟棄操作ALTERDISKGROUPdgroupAUNDROPALTERDISKGROUPdgroupADROPDISKA6ADDFAILGROUPDISK'/dev/rdsk/c0t8d0s2'NAMEALTERDISKGROUPdgroupADROPDISK$ASMCMD>ls-l$ASMCMD>ls-l RedundStripedDATAFILEMIRRORCOARSEOCT0521:00:00SysDATAFILEMIRRORCOARSEOCT0521:00:00 SQL>CREATETABLESPACETablespaceTAFILE'+DGROUP1'SIZESQL>CREATETABLESPACEhrappsDATAFILE'+DGROUP1'SIZETablespace(notesonlyslide)ASMCREATETABLESPACEsampleDATAFILE1234在磁盤組 ASM文件自動(dòng)擴(kuò) 21ASMCMDASMCMD適應(yīng)程序移植你的數(shù)據(jù)庫到庫干凈地關(guān)閉你的數(shù)據(jù)庫關(guān)閉數(shù)據(jù)庫，并且修改你的服務(wù)器參數(shù)文件使用編輯和執(zhí)行下列 STARTUPRESTORECONTROLFILEFROM'/u1/c1.ctl';ALTERDATABASEMOUNT;BACKUPASCOPYDATABASEFORMAT'+dgroup1';SWITCHDATABASETOCOPY;SQL"ALTERDATABASERENAME'/u1/log1'TO'+dgroup1'#RepeatRENAMEcommandforallonlineredologmembers...ALTERDATABASEOPENSQL"ALTERDATABASETEMPFILE'/u1/temp1'MigratingMigratingYourDatabasetoASM(notesonly總在這課中你應(yīng)該學(xué)會以