ITPub博客

首页 > Linux操作系统 > Linux操作系统 > oracle 11gR2 asmcmd 工具增加md_backup和md_restore命令

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

原创 Linux操作系统 作者:paulyibinyi 时间:2010-04-30 16:15:09 0 删除 编辑

    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

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/7199859/viewspace-661716/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 今天买了个手机
请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    907
  • 访问量
    6894426