Oracle ASM -- disk header
发表于：2025-02-21 作者：千家信息网编辑
千家信息网最后更新 2025年02月21日，我们知道asm是以au为分配单元，默认一个au为1m，那么disk header位于第一个au的第一个数据块上，而asm block编号是从0开始下面通过kfed工具来了解asm diskheader
千家信息网最后更新 2025年02月21日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安全错误
数据库的锁怎样保障安全
公安机关网络安全工作会
最难的软件开发
服务器优化插件七日杀
服务器如何上传自己的软件
上位机温度显示软件开发
17年自考计算机网络技术
福州康为网络技术有限公司官网
筑牢防火墙做网络安全小卫士
数据库程序设计mysql
广东东莞兔印网络技术有限公司
广电e家亲 建立服务器
学软件开发有哪些优势
自己家弄服务器安全吗
我的世界北方服务器推荐
数据库工作方式
数据库的对应英文
sql数据库sum函数
下载软件找不到服务器怎么办
数据库表的命名分类
网络安全进校园新闻稿
软件开发如何防止源代码泄露
南京计算机网络技术推广设备
选修课web服务器教什么
关于什么是数据库
宿松县网络安全宣传
db2 备份远程数据库
宁畅服务器管理口加载镜像
牙科医疗软件开发
计算机网络技术 英文论文
普洱服务器显卡价格
