Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

12

积分

0

好友

6

主题
1#
发表于 2013-2-5 16:48:53 | 查看: 2057| 回复: 1
请教大家:
用md_restore恢复asm元数据之后,除了recover,是否还可能有其它后续步骤?
总觉得模拟测试不很靠谱的样子
还是实践来的靠谱
2#
发表于 2013-2-5 16:55:54
目前没有使用该命令的经验, 相关的资料较少

可以参考资料:
  1. The options for the md_restore command are described below.
  2. backup_file - Reads the metadata information from backup_file.
  3. --silent - Ignore errors. Normally, if md_restore encounters an error, it will stop. Specifying this flag
  4. ignores any errors.
  5. --full - Specifies to create a disk group and restore metadata.
  6. --nodg - Specifies to restore metadata only.
  7. --newdg -o old_diskgroup:new_diskgroup - Specifies a comma separated list of old diskgroup
  8. name and new diskgroup names to create a disk group with a different name when restoring
  9. metadata. The -o option is required with --newdg.
  10. -S sql_script_file - Write SQL commands to the specified SQL script file instead of executing the
  11. commands.
  12. -G diskgroups - Comma separated list of disk groups to be restored. If no disk groups are
  13. defined, then all disk groups will be restored.
  14. Examples
  15. The first example restores the disk group DATA from the backup script
  16. and creates a copy. The second example takes an existing disk group
  17. DATA and restores its metadata. The third example restores disk group
  18. DATA completely but the new disk group that is created is called DATA2.
  19. The fourth example restores from the backup file after applying the
  20. overrides defined in the override.sql script file
  21. ASMCMD [+] > md_restore --full -G data --silent /tmp/dgbackup20090714 ASMCMD [+] > md_restore --
  22. nodg -G data --silent /tmp/dgbackup20090714
  23. ASMCMD [+] > md_restore --newdg -o 'data:data2' --silent
  24. /tmp/dgbackup20090714
  25. ASMCMD [+] > md_restore -S override.sql --silent /tmp/dgbackup20090714
复制代码

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-26 14:20 , Processed in 0.044593 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569