1500字范文,内容丰富有趣,写作好帮手!
1500字范文 > Oracle ASM -- disk header

Oracle ASM -- disk header

时间:2023-04-29 09:05:35

相关推荐

Oracle ASM -- disk header

我们知道asm是以au为分配单元,默认一个au为1m,那么disk header位于第一个au的第一个数据块上,而asm block编号是从0开始

下面通过kfed工具来了解asm diskheader内容

[root@localhost~]#kfedread/dev/asm-diskbkfbh.endian:1;0x000:0x01kfbh.hard:130;0x001:0x82kfbh.type:1;0x002:KFBTYP_DISKHEAD--diskheaderkfbh.datfmt:1;0x003:0x01kfbh.block.blk:0;0x004:T=0NUMB=0x0kfbh.block.obj:2147483648;0x008:TYPE=0x8NUMB=0x0kfbh.check:2625524850;0x00c:0x9c7e5472kfbh.fcn.base:2795;0x010:0x00000aebkfbh.fcn.wrap:0;0x014:0x00000000kfbh.spare1:0;0x018:0x00000000kfbh.spare2:0;0x01c:0x00000000kfdhdb.driver.provstr:ORCLDISK;0x000:length=8kfdhdb.driver.reserved[0]:0;0x008:0x00000000kfdhdb.driver.reserved[1]:0;0x00c:0x00000000kfdhdb.driver.reserved[2]:0;0x010:0x00000000kfdhdb.driver.reserved[3]:0;0x014:0x00000000kfdhdb.driver.reserved[4]:0;0x018:0x00000000kfdhdb.driver.reserved[5]:0;0x01c:pat:186646528;0x020:0x0b200000kfdhdb.dsknum:0;0x024:0x0000kfdhdb.grptyp:2;0x026:KFDGTP_NORMAL--磁盘组冗余方式kfdhdb.hdrsts:3;0x027:KFDHDR_MEMBER--磁盘herder状态,3为可用kfdhdb.dskname:DATA_0000;0x028:length=9--磁盘名称kfdhdb.grpname:DATA;0x048:length=4--磁盘组名称kfdhdb.fgname:DATA_0000;0x068:length=9--failgroupnamekfdhdb.capname:;0x088:length=0kfdhdb.crestmp.hi:33006007;0x0a8:HOUR=0x17DAYS=0xdMNTH=0x8YEAR=0x7dekfdhdb.crestmp.lo:811750400;0x0ac:USEC=0x0MSEC=0x95SECS=0x6MINS=0xckfdhdb.mntstmp.hi:33006676;0x0b0:HOUR=0x14DAYS=0x2MNTH=0x9YEAR=0x7dekfdhdb.mntstmp.lo:1221844992;0x0b4:USEC=0x0MSEC=0xf8SECS=0xdMINS=0x12kfdhdb.secsize:512;0x0b8:0x0200kfdhdb.blksize:4096;0x0ba:0x1000--块大小kfdhdb.ausize:1048576;0x0bc:0x00100000--au单位,这是是byte,1Mkfdhdb.mfact:113792;0x0c0:0x0001bc80kfdhdb.dsksize:10240;0x0c4:0x00002800--磁盘大小这里为10Gkfdhdb.pmcnt:2;0x0c8:0x00000002kfdhdb.fstlocn:1;0x0cc:0x00000001kfdhdb.altlocn:2;0x0d0:0x00000002kfdhdb.f1b1locn:2;0x0d4:0x00000002--filedirectory所在au位置后面会有对单独详细解释kfdhdb.redomirrors[0]:0;0x0d8:0x0000kfdhdb.redomirrors[1]:0;0x0da:0x0000kfdhdb.redomirrors[2]:0;0x0dc:0x0000kfdhdb.redomirrors[3]:0;0x0de:0x0000kfdhdb.dbcompat:168820736;0x0e0:0x0a100000kfdhdb.grpstmp.hi:33006007;0x0e4:HOUR=0x17DAYS=0xdMNTH=0x8YEAR=0x7dekfdhdb.grpstmp.lo:811466752;0x0e8:USEC=0x0MSEC=0x380SECS=0x5MINS=0xckfdhdb.vfstart:0;0x0ec:0x00000000kfdhdb.vfend:0;0x0f0:0x00000000kfdhdb.spfile:0;0x0f4:0x00000000kfdhdb.spfflg:0;0x0f8:0x00000000kfdhdb.ub4spare[0]:0;0x0fc:0x00000000kfdhdb.ub4spare[1]:0;0x100:0x00000000....kfdhdb.acdb.aba.seq:0;0x1d4:0x00000000kfdhdb.acdb.aba.blk:0;0x1d8:0x00000000kfdhdb.acdb.ents:0;0x1dc:0x0000kfdhdb.acdb.ub2spare:0;0x1de:0x0000

上面对disk header 关键部分作了解释,关于这个命令不指定参数是默认是aun=0 blkn=0 因此 kfed read /dev/asm-diskb aun=0 blkn=0 也可以得到同样的结果

disk header的内容非常重要,如果disk header损坏,asm磁盘组将无法mount,下面通过3种方法描述disk header 备份恢复

一,使用linux dd命令

1)创建磁盘组

SQL>CREATEDISKGROUPditer2EXTERNALREDUNDANCYDISK'/dev/asm-diskj'ATTRIBUTE'compatible.asm'='11.2.0.0.0';Diskgroupcreated.

2)备份,注意前面看到disk heard 块大小是4096

[root@localhost~]#ddif=/dev/asm-diskjof=/tmp/disk_header.bakbs=4096count=11+0recordsin1+0recordsout4096bytes(4.1kB)copied,0.000115seconds,35.6MB/s

3)同样使用dd命令破坏 disk header

[root@localhost~]#ddif=/dev/zeroof=/dev/asm-diskjbs=4096count=11+0recordsin1+0recordsout4096bytes(4.1kB)copied,2.2e-05seconds,186MB/s

4) 重启后发现diter2无法mount

SQL>startup;ASMinstancestartedTotalSystemGlobalArea283930624bytesFixedSize2212656bytesVariableSize256552144bytesASMCache25165824bytesORA-15032:notallalterationsperformedORA-15017:diskgroup"DITER2"cannotbemountedORA-15063:ASMdiscoveredaninsufficientnumberofdisksfordiskgroup"DITER2"ORA-15080:synchronousI/Ooperationtoadiskfailed

5)通过kfed工具

[root@localhost~]#kfedread/dev/asm-diskjkfbh.endian:0;0x000:0x00kfbh.hard:0;0x001:0x00kfbh.type:0;0x002:KFBTYP_INVALIDkfbh.datfmt:0;0x003:0x00kfbh.block.blk:0;0x004:T=0NUMB=0x0kfbh.block.obj:0;0x008:TYPE=0x0NUMB=0x0kfbh.check:0;0x00c:0x00000000kfbh.fcn.base:0;0x010:0x00000000kfbh.fcn.wrap:0;0x014:0x00000000kfbh.spare1:0;0x018:0x00000000kfbh.spare2:0;0x01c:0x00000000ERROR!!!,failedtogettheoracoreerrormessage

6)恢复

[root@localhost~]#ddif=/tmp/disk_header.bakof=/dev/asm-diskjbs=4096count=11+0recordsin1+0recordsout4096bytes(4.1kB)copied,0.008171seconds,501kB/s--恢复后发现可以成功mountSQL>alterdiskgroupditer2mount;Diskgroupaltered.

二,通过kfed 备份恢复

1) 备份

[root@localhost~]#kfedread/dev/asm-diskjtext=/tmp/disk_header2.bak[root@localhost~]#cat/tmp/disk_header2.bakkfbh.endian:1;0x000:0x01kfbh.hard:130;0x001:0x82kfbh.type:1;0x002:KFBTYP_DISKHEADkfbh.datfmt:1;0x003:0x01kfbh.block.blk:0;0x004:T=0NUMB=0x0kfbh.block.obj:2147483648;0x008:TYPE=0x8NUMB=0x0kfbh.check:247870715;0x00c:0x0ec634fbkfbh.fcn.base:0;0x010:0x00000000kfbh.fcn.wrap:0;0x014:0x00000000kfbh.spare1:0;0x018:0x00000000kfbh.spare2:0;0x01c:0x00000000kfdhdb.driver.provstr:ORCLDISK;0x000:length=8kfdhdb.driver.reserved[0]:0;0x008:0x00000000kfdhdb.driver.reserved[1]:0;0x00c:0x00000000kfdhdb.driver.reserved[2]:0;0x010:0x00000000kfdhdb.driver.reserved[3]:0;0x014:0x00000000kfdhdb.driver.reserved[4]:0;0x018:0x00000000kfdhdb.driver.reserved[5]:0;0x01c:pat:186646528;0x020:0x0b200000kfdhdb.dsknum:0;0x024:0x0000kfdhdb.grptyp:1;0x026:KFDGTP_EXTERNALkfdhdb.hdrsts:3;0x027:KFDHDR_MEMBERkfdhdb.dskname:DITER2_0000;0x028:length=11kfdhdb.grpname:DITER2;0x048:length=6kfdhdb.fgname:DITER2_0000;0x068:length=11kfdhdb.capname:;0x088:length=0kfdhdb.crestmp.hi:33006692;0x0a8:HOUR=0x4DAYS=0x3MNTH=0x9YEAR=0x7dekfdhdb.crestmp.lo:3585968128;0x0ac:USEC=0x0MSEC=0x362SECS=0x1bMINS=0x35kfdhdb.mntstmp.hi:33006692;0x0b0:HOUR=0x4DAYS=0x3MNTH=0x9YEAR=0x7dekfdhdb.mntstmp.lo:3730122752;0x0b4:USEC=0x0MSEC=0x14aSECS=0x25MINS=0x37kfdhdb.secsize:512;0x0b8:0x0200kfdhdb.blksize:4096;0x0ba:0x1000kfdhdb.ausize:1048576;0x0bc:0x00100000kfdhdb.mfact:113792;0x0c0:0x0001bc80kfdhdb.dsksize:3072;0x0c4:0x00000c00kfdhdb.pmcnt:2;0x0c8:0x00000002kfdhdb.fstlocn:1;0x0cc:0x00000001kfdhdb.altlocn:2;0x0d0:0x00000002kfdhdb.f1b1locn:2;0x0d4:0x00000002kfdhdb.redomirrors[0]:0;0x0d8:0x0000kfdhdb.redomirrors[1]:0;0x0da:0x0000kfdhdb.redomirrors[2]:0;0x0dc:0x0000kfdhdb.redomirrors[3]:0;0x0de:0x0000kfdhdb.dbcompat:168820736;0x0e0:0x0a100000kfdhdb.grpstmp.hi:33006692;0x0e4:HOUR=0x4DAYS=0x3MNTH=0x9YEAR=0x7dekfdhdb.grpstmp.lo:3585892352;0x0e8:USEC=0x0MSEC=0x318SECS=0x1bMINS=0x35kfdhdb.vfstart:0;0x0ec:0x00000000kfdhdb.vfend:0;0x0f0:0x00000000kfdhdb.spfile:0;0x0f4:0x00000000kfdhdb.spfflg:0;0x0f8:0x00000000kfdhdb.ub4spare[0]:0;0x0fc:0x00000000kfdhdb.ub4spare[1]:0;0x100:0x00000000..kfdhdb.ub4spare[53]:0;0x1d0:0x00000000kfdhdb.acdb.aba.seq:0;0x1d4:0x00000000kfdhdb.acdb.aba.blk:0;0x1d8:0x00000000kfdhdb.acdb.ents:0;0x1dc:0x0000kfdhdb.acdb.ub2spare:0;0x1de:0x0000

2) 破坏

[root@localhost~]#ddif=/dev/zeroof=/dev/asm-diskjbs=4096count=11+0recordsin1+0recordsout4096bytes(4.1kB)copied,1.8e-05seconds,228MB/s

3)恢复

[root@localhost~]#kfedmerge/dev/asm-diskjtext=/tmp/disk_header2.bak[root@localhost~]#SQL>startup;ASMinstancestartedTotalSystemGlobalArea283930624bytesFixedSize2212656bytesVariableSize256552144bytesASMCache25165824bytesORA-15032:notallalterationsperformedORA-15017:diskgroup"DITER2"cannotbemountedORA-15063:ASMdiscoveredaninsufficientnumberofdisksfordiskgroup"DITER2"ORA-15080:synchronousI/OoperationtoadiskfailedSQL>alterdiskgroupditer2mount;Diskgroupaltered.

三 使用asmcmd的md_backup和md_restore命令备份恢复

1) 备份

ASMCMD>md_backup/tmp/diter2.bak-GDITER2Diskgroupmetadatatobebackedup:DITER2

2)破坏

[root@localhost~]#ddif=/dev/zeroof=/dev/asm-diskjbs=4096count=11+0recordsin1+0recordsout4096bytes(4.1kB)copied,1.8e-05seconds,228MB/s

3)恢复

ASMCMD>md_restore/tmp/diter2.bak--full-Gditer2ORA-03135:connectionlostcontactProcessID:27387SessionID:17Serialnumber:14(DBDERROR:OCIStmtExecute/Describe)[grid@localhost~]$asmcmdASMCMD>md_restore/tmp/diter2.bak--full-Gditer2CurrentDiskgroupmetadatabeingrestored:DITER2DiskgroupDITER2created!SystemtemplateAUTOBACKUPmodified!SystemtemplateONLINELOGmodified!SystemtemplateOCRBACKUPmodified!SystemtemplateASMPARAMETERBAKFILEmodified!SystemtemplateASMPARAMETERFILEmodified!SystemtemplateASM_STALEmodified!SystemtemplatePARAMETERFILEmodified!SystemtemplateOCRFILEmodified!SystemtemplateCHANGETRACKINGmodified!SystemtemplateARCHIVELOGmodified!SystemtemplateDUMPSETmodified!SystemtemplateTEMPFILEmodified!SystemtemplateXTRANSPORTmodified!SystemtemplateFLASHBACKmodified!SystemtemplateDATAGUARDCONFIGmodified!SystemtemplateDATAFILEmodified!SystemtemplateCONTROLFILEmodified!SystemtemplateBACKUPSETmodified!SystemtemplateFLASHFILEmodified!注意这里恢复后磁盘组会自动mount,如果在恢复过程中报下面错误ASMCMD>md_restore/tmp/diter2.bak--full-Gditer2CurrentDiskgroupmetadatabeingrestored:DITER2ASMCMD-09352:CREATEDISKGROUPfailedORA-15018:diskgroupcannotbecreatedORA-15283:ASMoperationrequirescompatible.rdbmsof11.1.0.7.0orhigher(DBDERROR:OCIStmtExecu将compatible.rdbms更改为11.2就可以了alterdiskgroupFRAsetattribute'compatible.rdbms'='11.2';

下面是通过md_bakcup 备份的文件内容,可以看到是备份了整个asm disk 的 metadata,所以asm元数据全部破坏,我们也可以恢复它

[root@localhost~]#cat/tmp/diter2.bak@diskgroup_set=({'ATTRINFO'=>{'TEMPLATE.OCRBACKUP.REDUNDANCY'=>'17','TEMPLATE.PARAMETERFILE.MIRROR_REGION'=>'0','TEMPLATE.TEMPFILE.REDUNDANCY'=>'17','TEMPLATE.TEMPFILE.MIRROR_REGION'=>'0','TEMPLATE.PARAMETERFILE.REDUNDANCY'=>'17','SECTOR_SIZE'=>'512','TEMPLATE.DATAGUARDCONFIG.REDUNDANCY'=>'17','ACCESS_CONTROL.UMASK'=>'066','TEMPLATE.ASM_STALE.STRIPE'=>'0','TEMPLATE.ARCHIVELOG.STRIPE'=>'0','TEMPLATE.DATAGUARDCONFIG.PRIMARY_REGION'=>'0','TEMPLATE.OCRBACKUP.STRIPE'=>'0','TEMPLATE.DATAFILE.STRIPE'=>'0','AU_SIZE'=>'1048576','TEMPLATE.ASMPARAMETERFILE.STRIPE'=>'0','TEMPLATE.CHANGETRACKING.PRIMARY_REGION'=>'0','TEMPLATE.CONTROLFILE.REDUNDANCY'=>'17','TEMPLATE.FLASHFILE.STRIPE'=>'0','TEMPLATE.BACKUPSET.PRIMARY_REGION'=>'0','TEMPLATE.ARCHIVELOG.PRIMARY_REGION'=>'0','TEMPLATE.CHANGETRACKING.STRIPE'=>'0','TEMPLATE.ONLINELOG.PRIMARY_REGION'=>'0','TEMPLATE.CHANGETRACKING.REDUNDANCY'=>'17','TEMPLATE.BACKUPSET.STRIPE'=>'0','TEMPLATE.OCRFILE.MIRROR_REGION'=>'0','DISK_REPAIR_TIME'=>'3.6h','TEMPLATE.AUTOBACKUP.REDUNDANCY'=>'17','TEMPLATE.DUMPSET.REDUNDANCY'=>'17','TEMPLATE.FLASHBACK.MIRROR_REGION'=>'0','TEMPLATE.DUMPSET.MIRROR_REGION'=>'0','TEMPLATE.DUMPSET.PRIMARY_REGION'=>'0','TEMPLATE.ASM_STALE.REDUNDANCY'=>'17','TEMPLATE.FLASHBACK.PRIMARY_REGION'=>'0','TEMPLATE.CONTROLFILE.STRIPE'=>'1','TEMPLATE.DATAFILE.REDUNDANCY'=>'17','TEMPLATE.XTRANSPORT.REDUNDANCY'=>'17','TEMPLATE.AUTOBACKUP.PRIMARY_REGION'=>'0','TEMPLATE.CONTROLFILE.MIRROR_REGION'=>'0','TEMPLATE.DATAFILE.PRIMARY_REGION'=>'0','TEMPLATE.ASMPARAMETERFILE.REDUNDANCY'=>'17','TEMPLATE.FLASHFILE.MIRROR_REGION'=>'0','TEMPLATE.ASM_STALE.MIRROR_REGION'=>'0','TEMPLATE.FLASHBACK.REDUNDANCY'=>'17','TEMPLATE.DATAGUARDCONFIG.STRIPE'=>'0','CELL.SMART_SCAN_CAPABLE'=>'FALSE','TEMPLATE_VERSION'=>'186646528','TEMPLATE.PARAMETERFILE.STRIPE'=>'0','TEMPLATE.DATAFILE.MIRROR_REGION'=>'0','TEMPLATE.PARAMETERFILE.PRIMARY_REGION'=>'0','TEMPLATE.BACKUPSET.MIRROR_REGION'=>'0','TEMPLATE.OCRBACKUP.MIRROR_REGION'=>'0','TEMPLATE.ONLINELOG.REDUNDANCY'=>'17','TEMPLATE.ASMPARAMETERBAKFILE.STRIPE'=>'0','ACCESS_CONTROL.ENABLED'=>'FALSE','TEMPLATE.DATAGUARDCONFIG.MIRROR_REGION'=>'0','TEMPLATE.TEMPFILE.PRIMARY_REGION'=>'0','COMPATIBLE.RDBMS'=>'11.2','TEMPLATE.FLASHFILE.PRIMARY_REGION'=>'0','TEMPLATE.ONLINELOG.MIRROR_REGION'=>'0','TEMPLATE.FLASHFILE.REDUNDANCY'=>'17','TEMPLATE.OCRBACKUP.PRIMARY_REGION'=>'0','TEMPLATE.OCRFILE.STRIPE'=>'0','TEMPLATE.AUTOBACKUP.MIRROR_REGION'=>'0','TEMPLATE.ASM_STALE.PRIMARY_REGION'=>'0','TEMPLATE.ASMPARAMETERBAKFILE.PRIMARY_REGION'=>'0','TEMPLATE.XTRANSPORT.PRIMARY_REGION'=>'0','TEMPLATE.DUMPSET.STRIPE'=>'0','TEMPLATE.TEMPFILE.STRIPE'=>'0','TEMPLATE.OCRFILE.PRIMARY_REGION'=>'0','TEMPLATE.ONLINELOG.STRIPE'=>'0','TEMPLATE.ARCHIVELOG.REDUNDANCY'=>'17','TEMPLATE.OCRFILE.REDUNDANCY'=>'17','TEMPLATE.ARCHIVELOG.MIRROR_REGION'=>'0','TEMPLATE.ASMPARAMETERFILE.MIRROR_REGION'=>'0','TEMPLATE.FLASHBACK.STRIPE'=>'0','TEMPLATE.CONTROLFILE.PRIMARY_REGION'=>'0','TEMPLATE.XTRANSPORT.MIRROR_REGION'=>'0','TEMPLATE.BACKUPSET.REDUNDANCY'=>'17','TEMPLATE.ASMPARAMETERBAKFILE.REDUNDANCY'=>'17','TEMPLATE.XTRANSPORT.STRIPE'=>'0','TEMPLATE.CHANGETRACKING.MIRROR_REGION'=>'0','COMPATIBLE.ASM'=>'11.2.0.0.0','TEMPLATE.ASMPARAMETERBAKFILE.MIRROR_REGION'=>'0','TEMPLATE.ASMPARAMETERFILE.PRIMARY_REGION'=>'0','TEMPLATE.AUTOBACKUP.STRIPE'=>'0'},'DISKSINFO'=>{'DITER2_0000'=>{'DITER2_0000'=>{'TOTAL_MB'=>'3072','FAILGROUP'=>'DITER2_0000','NAME'=>'DITER2_0000','DGNAME'=>'DITER2','PATH'=>'/dev/asm-diskj'}}},'DGINFO'=>{'DGTORESTORE'=>0,'DGCOMPAT'=>'11.2.0.0.0','DGNAME'=>'DITER2','DGDBCOMPAT'=>'11.2.0.0.0','DGTYPE'=>'EXTERN','DGAUSZ'=>'1048576'},'ALIASINFO'=>{},'TEMPLATEINFO'=>{'11'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'AUTOBACKUP','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'7'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'ONLINELOG','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'2'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'ASMPARAMETERBAKFILE','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'17'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'OCRBACKUP','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'1'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'ASMPARAMETERFILE','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'18'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'ASM_STALE','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'0'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'PARAMETERFILE','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'16'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'OCRFILE','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'13'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'CHANGETRACKING','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'6'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'ARCHIVELOG','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'3'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'DUMPSET','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'9'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'TEMPFILE','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'12'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'XTRANSPORT','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'14'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'FLASHBACK','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'15'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'DATAGUARDCONFIG','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'8'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'DATAFILE','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'4'=>{'DGNAME'=>'DITER2','STRIPE'=>'FINE','TEMPNAME'=>'CONTROLFILE','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'10'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'BACKUPSET','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'},'5'=>{'DGNAME'=>'DITER2','STRIPE'=>'COARSE','TEMPNAME'=>'FLASHFILE','REDUNDANCY'=>'UNPROT','SYSTEM'=>'Y'}}});关于md_resotre命令我们也可以生成sql脚本恢复ASMCMD>md_restore-hUnknownoption:husage:md_restore<backup_file>[--silent][--full|--nodg|--newdg][-S<sql_script_file>][-G'<diskgroup_name>,<diskgroup_name>,...'][-o'<old_diskgroup_name>:<new_diskgroup_name>,...']help:helpmd_restoreASMCMD>md_restore-S/tmp/diter2.sql/tmp/diter2.bakCurrentDiskgroupmetadatabeingrestored:DITER2ASMCMD>quit[grid@localhost~]$cat/tmp/diter2.sqlcreatediskgroupDITER2EXTERNALredundancydisk'/dev/asm-diskj'nameDITER2_0000size3072Mattribute'compatible.asm'='11.2.0.0.0','compatible.rdbms'='11.2','au_size'='1048576','sector_size'='512','cell.smart_scan_capable'='FALSE';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.TEMPFILE.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.PARAMETERFILE.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.OCRBACKUP.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.TEMPFILE.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.PARAMETERFILE.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.DATAGUARDCONFIG.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'ACCESS_CONTROL.UMASK'='066';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ASM_STALE.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ARCHIVELOG.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.DATAGUARDCONFIG.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.OCRBACKUP.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.DATAFILE.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.CONTROLFILE.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ASMPARAMETERFILE.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.CHANGETRACKING.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.BACKUPSET.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.FLASHFILE.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ARCHIVELOG.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.CHANGETRACKING.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ONLINELOG.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.CHANGETRACKING.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.BACKUPSET.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.OCRFILE.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'DISK_REPAIR_TIME'='3.6h';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.AUTOBACKUP.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.DUMPSET.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.FLASHBACK.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.DUMPSET.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.DUMPSET.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ASM_STALE.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.FLASHBACK.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.XTRANSPORT.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.DATAFILE.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.CONTROLFILE.STRIPE'='1';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.AUTOBACKUP.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.CONTROLFILE.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.DATAFILE.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.FLASHFILE.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ASMPARAMETERFILE.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ASM_STALE.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.FLASHBACK.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.DATAGUARDCONFIG.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE_VERSION'='186646528';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.PARAMETERFILE.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.DATAFILE.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.PARAMETERFILE.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.BACKUPSET.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.OCRBACKUP.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ONLINELOG.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ASMPARAMETERBAKFILE.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'ACCESS_CONTROL.ENABLED'='FALSE';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.DATAGUARDCONFIG.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.TEMPFILE.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.FLASHFILE.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ONLINELOG.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.FLASHFILE.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.OCRBACKUP.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.OCRFILE.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.AUTOBACKUP.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ASM_STALE.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.XTRANSPORT.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ASMPARAMETERBAKFILE.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.DUMPSET.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.TEMPFILE.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.OCRFILE.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.OCRFILE.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ARCHIVELOG.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ONLINELOG.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ARCHIVELOG.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.FLASHBACK.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ASMPARAMETERFILE.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.XTRANSPORT.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.CONTROLFILE.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.BACKUPSET.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.XTRANSPORT.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ASMPARAMETERBAKFILE.REDUNDANCY'='17';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.CHANGETRACKING.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ASMPARAMETERFILE.PRIMARY_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.ASMPARAMETERBAKFILE.MIRROR_REGION'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2setattribute'TEMPLATE.AUTOBACKUP.STRIPE'='0';alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateAUTOBACKUPattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateONLINELOGattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateOCRBACKUPattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateASMPARAMETERBAKFILEattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateASMPARAMETERFILEattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateASM_STALEattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplatePARAMETERFILEattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateOCRFILEattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateCHANGETRACKINGattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateARCHIVELOGattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateDUMPSETattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateTEMPFILEattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateXTRANSPORTattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateFLASHBACKattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateDATAGUARDCONFIGattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateDATAFILEattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateCONTROLFILEattributes(UNPROTECTEDFINE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateBACKUPSETattributes(UNPROTECTEDCOARSE);alterdiskgroup/*ASMCMDAMBR*/DITER2altertemplateFLASHFILEattributes(UNPROTECTEDCOARSE);

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。