oracle 11gR2 asmcmd 工具增加md_backup和md_restore命令

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:703

oracle 11gR2 asmcmd 工具增加md_backup和md_restore命令

oracle 11gR2 版本增加对磁盘组元数据备份与恢复的命令
md_backup :Creates a backup of the metadata of mounted disk groups.

md_restore :Restores disk groups from a backup of the metadata.
md_backup :
Syntax and Description
md_backup backup_file
[-G 'diskgroup [,diskgroup,...]']
Example 12–38 Using md_backup
ASMCMD [+] > md_backup /tmp/dgbackup20090716
ASMCMD [+] > md_backup /tmp/dgbackup20090716 -G data,fra
Disk group metadata to be backed up: DATA
Disk group metadata to be backed up: FRA
Current alias directory path: ASM/ASMPARAMETERFILE
Current alias directory path: ORCL/DATAFILE
Current alias directory path: ORCL/TEMPFILE
Current alias directory path: ORCL/CONTROLFILE
Current alias directory path: ORCL/PARAMETERFILE
Current alias directory path: ASM
Current alias directory path: ORCL/ONLINELOG
Current alias directory path: ORCL
Current alias directory path: ORCL/CONTROLFILE
Current alias directory path: ORCL/ARCHIVELOG/2009_07_13
Current alias directory path: ORCL/BACKUPSET/2009_07_14
Current alias directory path: ORCL/ARCHIVELOG/2009_07_14
Current alias directory path: ORCL
Current alias directory path: ORCL/DATAFILE
Current alias directory path: ORCL/ARCHIVELOG
Current alias directory path: ORCL/BACKUPSET
Current alias directory path: ORCL/ONLINELOG

md_restore :
Syntax and Description
md_restore backup_file [--silent]
[--full|--nodg|--newdg -o 'old_diskgroup:new_diskgroup [,...]']
[-S sql_script_file] [-G 'diskgroup [,diskgroup...]']
Example
The first example restores the disk group data from the backup script. and creates a
copy. The second example takes an existing disk group data and restores its metadata.
The third example restores disk group data completely but the new disk group that is
created is called data2. The fourth example restores from the backup file after
applying the overrides defined in the override.sql script. file.
Example 12–39 Using md_restore
ASMCMD [+] > md_restore –-full –G data –-silent /tmp/dgbackup20090714
ASMCMD [+] > md_restore –-nodg –G data –-silent /tmp/dgbackup20090714
ASMCMD [+] > md_restore –-newdg -o 'data:data2' --silent /tmp/dgbackup20090714
ASMCMD [+] > md_restore -S override.sql --silent /tmp/dgbackup20090714

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】