Oracle ASM -- disk header
发表于：2025-01-20 作者：千家信息网编辑
千家信息网最后更新 2025年01月20日，我们知道asm是以au为分配单元，默认一个au为1m，那么disk header位于第一个au的第一个数据块上，而asm block编号是从0开始下面通过kfed工具来了解asm diskheader
千家信息网最后更新 2025年01月20日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安全错误
数据库的锁怎样保障安全
北京服务器包装找哪家
跨专业网络安全难吗
软件开发模型喷泉
诺亚之心账号服务器踢人
大华c9100自带数据库
华为服务器打不开网页管理
电脑版服务器怎么清楚掉落物
erp软件开发公司估值
dell的服务器 2021增长
安徽加工软件开发怎么样
用手机制作数据库
华三服务器外部健康灯闪烁
软件开发岗位综合实践
MySQL数据库
招行软件开发子公司
战地5服务器需要人一直在吗
长春定制软件开发
软件开发服务开票税率
网络安全等级保护制度3.0
软件开发试验总结报告
软件开发的淘宝客服
为什么网络安全还是重要
智慧党建平台网络安全
2022年网络安全宣传周
梦幻手游雷霆万钧服务器怎么找
银行签约支付宝过程 软件开发
网络安全方面的实习报告
浙江戴尔服务器虚拟化定做
数据库的视图属于
瑞思数据库怎么查找个股
