Oracle ASM -- disk header
发表于：2025-11-07 作者：千家信息网编辑
千家信息网最后更新 2025年11月07日，我们知道asm是以au为分配单元，默认一个au为1m，那么disk header位于第一个au的第一个数据块上，而asm block编号是从0开始下面通过kfed工具来了解asm diskheader
千家信息网最后更新 2025年11月07日Oracle ASM -- disk header
我们知道asm是以au为分配单元，默认一个au为1m，那么disk header位于第一个au的第一个数据块上，而asm block编号是从0开始
下面通过kfed工具来了解asm diskheader内容
[root@localhost ~]# kfed read /dev/asm-diskbkfbh.endian: 1 ; 0x000: 0x01kfbh.hard: 130 ; 0x001: 0x82kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD --disk headerkfbh.datfmt: 1 ; 0x003: 0x01kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0kfbh.block.obj: 2147483648 ; 0x008: TYPE=0x8 NUMB=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: 0x00000000kfdhdb.compat: 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 --fail group namekfdhdb.capname: ; 0x088: length=0kfdhdb.crestmp.hi: 33006007 ; 0x0a8: HOUR=0x17 DAYS=0xd MNTH=0x8 YEAR=0x7dekfdhdb.crestmp.lo: 811750400 ; 0x0ac: USEC=0x0 MSEC=0x95 SECS=0x6 MINS=0xckfdhdb.mntstmp.hi: 33006676 ; 0x0b0: HOUR=0x14 DAYS=0x2 MNTH=0x9 YEAR=0x7dekfdhdb.mntstmp.lo: 1221844992 ; 0x0b4: USEC=0x0 MSEC=0xf8 SECS=0xd MINS=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: 0x00000001 kfdhdb.altlocn: 2 ; 0x0d0: 0x00000002kfdhdb.f1b1locn: 2 ; 0x0d4: 0x00000002 -- file directory 所在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=0x17 DAYS=0xd MNTH=0x8 YEAR=0x7dekfdhdb.grpstmp.lo: 811466752 ; 0x0e8: USEC=0x0 MSEC=0x380 SECS=0x5 MINS=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> CREATE DISKGROUP diter2 EXTERNAL REDUNDANCY DISK '/dev/asm-diskj' ATTRIBUTE 'compatible.asm' = '11.2.0.0.0';Diskgroup created.
2）备份，注意前面看到disk heard 块大小是4096
[root@localhost ~]# dd if=/dev/asm-diskj of=/tmp/disk_header.bak bs=4096 count=11+0 records in1+0 records out4096 bytes (4.1 kB) copied, 0.000115 seconds, 35.6 MB/s
3）同样使用dd命令破坏 disk header
[root@localhost ~]# dd if=/dev/zero of=/dev/asm-diskj bs=4096 count=11+0 records in1+0 records out4096 bytes (4.1 kB) copied, 2.2e-05 seconds, 186 MB/s
4） 重启后发现diter2无法mount
SQL> startup;ASM instance startedTotal System Global Area 283930624 bytesFixed Size 2212656 bytesVariable Size 256552144 bytesASM Cache 25165824 bytesORA-15032: not all alterations performedORA-15017: diskgroup "DITER2" cannot be mountedORA-15063: ASM discovered an insufficient number of disks for diskgroup"DITER2"ORA-15080: synchronous I/O operation to a disk failed
5）通过kfed工具
[root@localhost ~]# kfed read /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=0 NUMB=0x0kfbh.block.obj: 0 ; 0x008: TYPE=0x0 NUMB=0x0kfbh.check: 0 ; 0x00c: 0x00000000kfbh.fcn.base: 0 ; 0x010: 0x00000000kfbh.fcn.wrap: 0 ; 0x014: 0x00000000kfbh.spare1: 0 ; 0x018: 0x00000000kfbh.spare2: 0 ; 0x01c: 0x00000000ERROR!!!, failed to get the oracore error message
6）恢复
[root@localhost ~]# dd if=/tmp/disk_header.bak of=/dev/asm-diskj bs=4096 count=11+0 records in1+0 records out4096 bytes (4.1 kB) copied, 0.008171 seconds, 501 kB/s-- 恢复后发现可以成功mountSQL> alter diskgroup diter2 mount;Diskgroup altered.
二，通过kfed 备份恢复
1) 备份
[root@localhost ~]# kfed read /dev/asm-diskj text=/tmp/disk_header2.bak[root@localhost ~]# cat /tmp/disk_header2.bak kfbh.endian: 1 ; 0x000: 0x01kfbh.hard: 130 ; 0x001: 0x82kfbh.type: 1 ; 0x002: KFBTYP_DISKHEADkfbh.datfmt: 1 ; 0x003: 0x01kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0kfbh.block.obj: 2147483648 ; 0x008: TYPE=0x8 NUMB=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: 0x00000000kfdhdb.compat: 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=0x4 DAYS=0x3 MNTH=0x9 YEAR=0x7dekfdhdb.crestmp.lo: 3585968128 ; 0x0ac: USEC=0x0 MSEC=0x362 SECS=0x1b MINS=0x35kfdhdb.mntstmp.hi: 33006692 ; 0x0b0: HOUR=0x4 DAYS=0x3 MNTH=0x9 YEAR=0x7dekfdhdb.mntstmp.lo: 3730122752 ; 0x0b4: USEC=0x0 MSEC=0x14a SECS=0x25 MINS=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=0x4 DAYS=0x3 MNTH=0x9 YEAR=0x7dekfdhdb.grpstmp.lo: 3585892352 ; 0x0e8: USEC=0x0 MSEC=0x318 SECS=0x1b MINS=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 ~]# dd if=/dev/zero of=/dev/asm-diskj bs=4096 count=11+0 records in1+0 records out4096 bytes (4.1 kB) copied, 1.8e-05 seconds, 228 MB/s
3）恢复
[root@localhost ~]# kfed merge /dev/asm-diskj text=/tmp/disk_header2.bak [root@localhost ~]# SQL> startup;ASM instance startedTotal System Global Area 283930624 bytesFixed Size 2212656 bytesVariable Size 256552144 bytesASM Cache 25165824 bytesORA-15032: not all alterations performedORA-15017: diskgroup "DITER2" cannot be mountedORA-15063: ASM discovered an insufficient number of disks for diskgroup"DITER2"ORA-15080: synchronous I/O operation to a disk failedSQL> alter diskgroup diter2 mount;Diskgroup altered.
三 使用asmcmd的md_backup和md_restore命令备份恢复
1) 备份
ASMCMD> md_backup /tmp/diter2.bak -G DITER2Disk group metadata to be backed up: DITER2
2）破坏
[root@localhost ~]# dd if=/dev/zero of=/dev/asm-diskj bs=4096 count=11+0 records in1+0 records out4096 bytes (4.1 kB) copied, 1.8e-05 seconds, 228 MB/s
3）恢复
ASMCMD> md_restore /tmp/diter2.bak --full -G diter2ORA-03135: connection lost contactProcess ID: 27387Session ID: 17 Serial number: 14 (DBD ERROR: OCIStmtExecute/Describe)[grid@localhost ~]$ asmcmdASMCMD> md_restore /tmp/diter2.bak --full -G diter2Current Diskgroup metadata being restored: DITER2Diskgroup DITER2 created!System template AUTOBACKUP modified!System template ONLINELOG modified!System template OCRBACKUP modified!System template ASMPARAMETERBAKFILE modified!System template ASMPARAMETERFILE modified!System template ASM_STALE modified!System template PARAMETERFILE modified!System template OCRFILE modified!System template CHANGETRACKING modified!System template ARCHIVELOG modified!System template DUMPSET modified!System template TEMPFILE modified!System template XTRANSPORT modified!System template FLASHBACK modified!System template DATAGUARDCONFIG modified!System template DATAFILE modified!System template CONTROLFILE modified!System template BACKUPSET modified!System template FLASHFILE modified!注意这里恢复后磁盘组会自动mount，如果在恢复过程中报下面错误ASMCMD> md_restore /tmp/diter2.bak --full -G diter2Current Diskgroup metadata being restored: DITER2ASMCMD-09352: CREATE DISKGROUP failedORA-15018: diskgroup cannot be createdORA-15283: ASM operation requires compatible.rdbms of 11.1.0.7.0 or higher (DBD ERROR: OCIStmtExecu将compatible.rdbms更改为11.2就可以了alter diskgroup FRA set attribute '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 -hUnknown option: husage: md_restore [--silent] [--full|--nodg|--newdg] [-S ] [-G ',,...'] [-o ':,...']help: help md_restoreASMCMD> md_restore -S /tmp/diter2.sql /tmp/diter2.bakCurrent Diskgroup metadata being restored: DITER2ASMCMD> quit[grid@localhost ~]$ cat /tmp/diter2.sql create diskgroup DITER2 EXTERNAL redundancy disk '/dev/asm-diskj' name DITER2_0000 size 3072M attribute 'compatible.asm' = '11.2.0.0.0' , 'compatible.rdbms' = '11.2' , 'au_size' = '1048576', 'sector_size' = '512', 'cell.smart_scan_capable' = 'FALSE';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.TEMPFILE.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.PARAMETERFILE.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.OCRBACKUP.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.TEMPFILE.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.PARAMETERFILE.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.DATAGUARDCONFIG.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'ACCESS_CONTROL.UMASK' = '066';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ASM_STALE.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ARCHIVELOG.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.DATAGUARDCONFIG.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.OCRBACKUP.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.DATAFILE.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.CONTROLFILE.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ASMPARAMETERFILE.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.CHANGETRACKING.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.BACKUPSET.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.FLASHFILE.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ARCHIVELOG.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.CHANGETRACKING.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ONLINELOG.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.CHANGETRACKING.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.BACKUPSET.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.OCRFILE.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'DISK_REPAIR_TIME' = '3.6h';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.AUTOBACKUP.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.DUMPSET.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.FLASHBACK.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.DUMPSET.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.DUMPSET.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ASM_STALE.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.FLASHBACK.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.XTRANSPORT.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.DATAFILE.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.CONTROLFILE.STRIPE' = '1';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.AUTOBACKUP.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.CONTROLFILE.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.DATAFILE.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.FLASHFILE.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ASMPARAMETERFILE.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ASM_STALE.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.FLASHBACK.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.DATAGUARDCONFIG.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE_VERSION' = '186646528';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.PARAMETERFILE.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.DATAFILE.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.PARAMETERFILE.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.BACKUPSET.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.OCRBACKUP.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ONLINELOG.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ASMPARAMETERBAKFILE.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'ACCESS_CONTROL.ENABLED' = 'FALSE';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.DATAGUARDCONFIG.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.TEMPFILE.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.FLASHFILE.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ONLINELOG.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.FLASHFILE.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.OCRBACKUP.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.OCRFILE.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.AUTOBACKUP.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ASM_STALE.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.XTRANSPORT.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ASMPARAMETERBAKFILE.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.DUMPSET.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.TEMPFILE.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.OCRFILE.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.OCRFILE.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ARCHIVELOG.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ONLINELOG.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ARCHIVELOG.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.FLASHBACK.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ASMPARAMETERFILE.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.XTRANSPORT.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.CONTROLFILE.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.BACKUPSET.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.XTRANSPORT.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ASMPARAMETERBAKFILE.REDUNDANCY' = '17';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.CHANGETRACKING.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ASMPARAMETERFILE.PRIMARY_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.ASMPARAMETERBAKFILE.MIRROR_REGION' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 set attribute 'TEMPLATE.AUTOBACKUP.STRIPE' = '0';alter diskgroup /*ASMCMD AMBR*/DITER2 alter template AUTOBACKUP attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template ONLINELOG attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template OCRBACKUP attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template ASMPARAMETERBAKFILE attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template ASMPARAMETERFILE attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template ASM_STALE attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template PARAMETERFILE attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template OCRFILE attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template CHANGETRACKING attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template ARCHIVELOG attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template DUMPSET attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template TEMPFILE attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template XTRANSPORT attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template FLASHBACK attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template DATAGUARDCONFIG attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template DATAFILE attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template CONTROLFILE attributes (UNPROTECTED FINE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template BACKUPSET attributes (UNPROTECTED COARSE);alter diskgroup /*ASMCMD AMBR*/DITER2 alter template FLASHFILE attributes (UNPROTECTED COARSE);
备份
磁盘
命令
内容
大小
名称
工具
数据
重要
成功
中报
位置
关键
冗余
单位
单元
参数
所在
文件
方式
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
csgo国内服务器怎么加速
工业网络技术相关视频教程
网络安全大赛门票
数据库性别只能用
大话魔游记服务器关闭了吗
无锡选择软件开发怎么样
4块硬盘服务器
果蔬分拣系统软件开发
惠州微商软件开发咨询
网络安全二级等保包括什么
司法局开展网络安全警示教育
注册苹果id显示服务器问题
个人搭建云服务器配置
服务器机房静音措施
普通党员应该怎么做网络安全
网络安全掀起涨停潮
数据库中批量造数据的sql
软件开发项目实施
海南通讯软件开发服务检测中心
南开100题上机网络技术
软件开发行业代码是什么
深圳星科软件开发有限公司
网络安全与管理告知书
广东系统软件开发哪家便宜
严防手机网络安全问题招法
农村地区网络安全监测
目前流行的主流数据库有哪些
绝地求生服务器一直炸
体制内从事软件开发
网络技术不成熟
