11g asm md_backup md_restore
============================
11g中增加了对asm metadata备份恢复的命令
md_backup
md_restore
命令帮助如下：
ASMCMD [+] > help md_backup
md_backup
[-G '
Perform. ASM metadata backup for disk groups.
Back up into backup file disk group metadata information including
fail groups, disks, attributes, aliases, and templates.
Store information into
-G Disk groups to backup. All diskgroups are backed up by default.
ASMCMD [+] > help md_restore
md_restore
[--full|--nodg|--newdg] [-S
[-G '
[-o '
Perform. ASM Metadata restore for disk groups.
Read metadata information from
--silent Ignore errors. Normally if md_restore encounters an error, it
will stop. Specifying this flag ignores that.
--full create disk group and restore metadata.
--nodg restore metadata only.
--newdg create disk group with a different name and restore
metadata; -o is required.
-S Write SQL commands to
-G Select the disk groups to be restored. If no disk groups defined,
all of them will be restored.
-o Rename disk group
----------------------------------
md_backup
使用比较简单
第一条命令为备份所有元数据到指定文件中
第二天命令添加了-G,可以指定备份特定的磁盘组
md_backup /tmp/asm_meta.bak
md_backup /tmp/asm_meta_DATA.bak -G DATA
----------------------------------
md_restore
使用md_backup备份出的内容，恢复元数据
相对于备份，恢复的选项稍多
命令可选参数有
--silent 忽略恢复中的错误，但一旦出错恢复将停止
--full 创建磁盘组并回复元数据
--nodg 仅恢复元数据
--newdg 创建重新命名的磁盘组，需要和-o一同使用
-S 生成sql语句，不执行命令
-G 指定磁盘组组
-o 重命名磁盘组
第一条命令使用/tmp/asm_meta.bak重建并回复全部元数据
第二条命令使用/tmp/asm_meta_DATA.bak重建并恢复磁盘组DATA
第三条命令使用/tmp/asm_meta.bak生成创建磁盘组的sql脚本
第四条命令使用/tmp/asm_meta_DATA.bak重新创建磁盘组DATA，并重命名为NEW_DG
md_restore --full /tmp/asm_meta.bak
md_restore --full -G DATA /tmp/asm_meta_DATA.bak
md_restore -S create_oradg.sql /tmp/asm_meta.bak
md_restore --newdg -o DATA:NEW_DG /tmp/asm_meta_DATA.bak
--------------------------------------
ASMCMD [+] > md_backup /tmp/asm_meta.bak
Disk group metadata to be backed up: DATA2
Disk group metadata to be backed up: DATA
Current alias directory path: DB11/TEMPFILE
Current alias directory path: DB11/CONTROLFILE
Current alias directory path: ASM/ASMPARAMETERFILE
Current alias directory path: DB11/PARAMETERFILE
Current alias directory path: ASM
Current alias directory path: DB11/DATAFILE
Current alias directory path: DB11
Current alias directory path: DB11/ONLINELOG
ASMCMD [+] > ASMCMD [+] > exit
-bash-3.2$ more /tmp/asm
asm.ora asm_meta.bak
-bash-3.2$ more /tmp/asm_meta.bak
@diskgroup_set = (
{
'DISKSINFO' => {
'FG2' => {
'VOL2' => {
'TOTAL_MB' => '5114',
'FAILGROUP' => 'FG2',
'NAME' => 'VOL2',
'DGNAME' => 'DATA2',
'PATH' => 'ORCL:VOL2'
}
},
'FG1' => {
'VOL1' => {
'TOTAL_MB' => '5114',
'FAILGROUP' => 'FG1',
'NAME' => 'VOL1',
'DGNAME' => 'DATA2',
'PATH' => 'ORCL:VOL1'
}
}
},
'DGINFO' => {
'DGTORESTORE' => 0,
'DGCOMPAT' => '10.1.0.0.0',
'DGNAME' => 'DATA2',
'DGDBCOMPAT' => '10.1.0.0.0',
'DGTYPE' => 'NORMAL',
'DGAUSZ' => '1048576'
},
'ALIASINFO' => {},
'TEMPLATEINFO' => {
'11' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'TEMPFILE',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
},
'7' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'CHANGETRACKING',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
},
'2' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'ASM_STALE',
'REDUNDANCY' => 'HIGH',
'SYSTEM' => 'Y'
},
'17' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'DUMPSET',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
},
'1' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'ASMPARAMETERFILE',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
},
'18' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'ASMPARAMETERBAKFILE',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
},
'0' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'PARAMETERFILE',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
},
'16' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'FINE',
'TEMPNAME' => 'CONTROLFILE',
'REDUNDANCY' => 'HIGH',
'SYSTEM' => 'Y'
},
'13' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'ONLINELOG',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
},
'6' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'FLASHBACK',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
},
'3' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'OCRBACKUP',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
},
'9' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'AUTOBACKUP',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
},
'12' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'DATAFILE',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
},
'14' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'ARCHIVELOG',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
},
'15' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'FLASHFILE',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
},
'8' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'XTRANSPORT',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
},
'4' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'OCRFILE',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
},
'10' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'BACKUPSET',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
},
'5' => {
'DGNAME' => 'DATA2',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'DATAGUARDCONFIG',
'REDUNDANCY' => 'MIRROR',
'SYSTEM' => 'Y'
}
}
},
{
'ATTRINFO' => {
'TEMPLATE.PARAMETERFILE.MIRROR_REGION' => '0',
'TEMPLATE.TEMPFILE.REDUNDANCY' => '17',
'TEMPLATE.OCRBACKUP.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' => '5h',
'TEMPLATE.FLASHBACK.MIRROR_REGION' => '0',
'TEMPLATE.AUTOBACKUP.REDUNDANCY' => '17',
'TEMPLATE.DUMPSET.REDUNDANCY' => '17',
'TEMPLATE.ASM_STALE.REDUNDANCY' => '17',
'TEMPLATE.DUMPSET.PRIMARY_REGION' => '0',
'TEMPLATE.DUMPSET.MIRROR_REGION' => '0',
'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.0.0.0',
'TEMPLATE.FLASHFILE.PRIMARY_REGION' => '0',
'TEMPLATE.ONLINELOG.MIRROR_REGION' => '0',
'TEMPLATE.FLASHFILE.REDUNDANCY' => '17',
'TEMPLATE.OCRBACKUP.PRIMARY_REGION' => '0',
'TEMPLATE.OCRFILE.STRIPE' => '0',
'TEMPLATE.ASM_STALE.PRIMARY_REGION' => '0',
'TEMPLATE.AUTOBACKUP.MIRROR_REGION' => '0',
'TEMPLATE.XTRANSPORT.PRIMARY_REGION' => '0',
'TEMPLATE.ASMPARAMETERBAKFILE.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.XTRANSPORT.MIRROR_REGION' => '0',
'TEMPLATE.CONTROLFILE.PRIMARY_REGION' => '0',
'TEMPLATE.BACKUPSET.REDUNDANCY' => '17',
'TEMPLATE.XTRANSPORT.STRIPE' => '0',
'TEMPLATE.ASMPARAMETERBAKFILE.REDUNDANCY' => '17',
'TEMPLATE.CHANGETRACKING.MIRROR_REGION' => '0',
'COMPATIBLE.ASM' => '11.2.0.0.0',
'TEMPLATE.ASMPARAMETERFILE.PRIMARY_REGION' => '0',
'TEMPLATE.ASMPARAMETERBAKFILE.MIRROR_REGION' => '0',
'TEMPLATE.AUTOBACKUP.STRIPE' => '0'
},
'DISKSINFO' => {
'DATA' => {
'DATA' => {
'TOTAL_MB' => '5114',
'FAILGROUP' => 'DATA',
'NAME' => 'DATA',
'DGNAME' => 'DATA',
'PATH' => 'ORCL:DATA'
}
}
},
'DGINFO' => {
'DGTORESTORE' => 0,
'DGCOMPAT' => '11.2.0.0.0',
'DGNAME' => 'DATA',
'DGDBCOMPAT' => '11.2.0.0.0',
'DGTYPE' => 'EXTERN',
'DGAUSZ' => '1048576'
},
'ALIASINFO' => {
'6' => {
'DGNAME' => 'DATA',
'LEVEL' => 1,
'ALIASNAME' => 'DB11/TEMPFILE',
'REFERENCE_INDEX' => '33554803'
},
'1' => {
'DGNAME' => 'DATA',
'LEVEL' => 0,
'ALIASNAME' => 'DB11',
'REFERENCE_INDEX' => '33554591'
},
'4' => {
'DGNAME' => 'DATA',
'LEVEL' => 1,
'ALIASNAME' => 'DB11/CONTROLFILE',
'REFERENCE_INDEX' => '33554697'
},
'0' => {
'DGNAME' => 'DATA',
'LEVEL' => 0,
'ALIASNAME' => 'ASM',
'REFERENCE_INDEX' => '33554485'
},
'3' => {
'DGNAME' => 'DATA',
'LEVEL' => 1,
'ALIASNAME' => 'DB11/PARAMETERFILE',
'REFERENCE_INDEX' => '33554856'
},
'7' => {
'DGNAME' => 'DATA',
'LEVEL' => 1,
'ALIASNAME' => 'DB11/DATAFILE',
'REFERENCE_INDEX' => '33554644'
},
'2' => {
'DGNAME' => 'DATA',
'LEVEL' => 1,
'ALIASNAME' => 'ASM/ASMPARAMETERFILE',
'REFERENCE_INDEX' => '33554538'
},
'5' => {
'DGNAME' => 'DATA',
'LEVEL' => 1,
'ALIASNAME' => 'DB11/ONLINELOG',
'REFERENCE_INDEX' => '33554750'
}
},
'TEMPLATEINFO' => {
'11' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'ONLINELOG',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'7' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'AUTOBACKUP',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'2' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'OCRFILE',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'17' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'ASMPARAMETERFILE',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'1' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'ASM_STALE',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'18' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'OCRBACKUP',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'0' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'PARAMETERFILE',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'16' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'ASMPARAMETERBAKFILE',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'13' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'FLASHFILE',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'6' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'XTRANSPORT',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'3' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'DATAGUARDCONFIG',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'9' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'TEMPFILE',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'12' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'ARCHIVELOG',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'15' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'DUMPSET',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'14' => {
'DGNAME' => 'DATA',
'STRIPE' => 'FINE',
'TEMPNAME' => 'CONTROLFILE',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'8' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'BACKUPSET',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'4' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'FLASHBACK',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'10' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'DATAFILE',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
},
'5' => {
'DGNAME' => 'DATA',
'STRIPE' => 'COARSE',
'TEMPNAME' => 'CHANGETRACKING',
'REDUNDANCY' => 'UNPROT',
'SYSTEM' => 'Y'
}
}
}
);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/13177610/viewspace-714669/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
