DB2 RECOVER概述

本文介绍了数据库恢复的基本概念,包括如何使用IBM DataStudio版本3.1及后续版本的任务向导来恢复数据库到指定时间点,以及恢复过程中不支持的特定命令选项。详细解释了不同类型的数据库恢复(如崩溃恢复、灾难恢复、版本恢复、增量备份恢复等),并讨论了恢复性能优化、所需权限和注意事项。
摘要由CSDN通过智能技术生成

 

Recover overview

恢复概述

The recover utility performs the necessaryrestore and roll-forward operations to recover a database to a specified time,based on information found in the recovery history file. When you use thisutility, you specify that the database be recovered to a point-in-time or tothe end of the log files. The utility will then select the best suitable backupimage and perform the recovery operations.

恢复工具执行必要的还原和rollforward操作去恢复一个数据库到一个特定的时间.当你使用这个工具,你指定数据库被恢复的时间点或者日志文件的结束。这个工具将选择最合适的备份镜像执行恢复操作。

For recovering databases, you can usethe task assistant available in IBM® Data Studio Version 3.1 orlater. Task assistants can guide you through the process of setting options,reviewing the automatically generated commands to perform the task, and runningthese commands. For more details, see Administeringdatabases with task assistants.

恢复数据库,你可以使用IBM data studio version3.1或者以后版本中的任务向导。

The recover utility does not support thefollowing RESTORE DATABASE command options:

恢复工具不支持以下restore database命令选项

  • TABLESPACE tablespace-name. Table space restore operations are not supported.
  • TABLESPACE表空间名。表空间还原操作不被支持
  • INCREMENTAL. Incremental restore operations are not supported.
  • INCREMENTAL增量还原操作不被支持
  • OPEN num-sessions SESSIONS. You cannot indicate the number of I/O sessions that are to be used with TSM or another vendor product.
  • OPEN会话。你不能指定IO会话数(用TSM或者其他厂商的产品)
  • BUFFER buffer-size. You cannot set the size of the buffer used for the restore operation.
  • BUFFER缓冲池大小。你不能设置还原操作的缓冲池大小。
  • DLREPORT file name. You cannot specify a file name for reporting files that become unlinked.
  • WITHOUT ROLLING FORWARD. You cannot specify that the database is not to be placed in roll-forward pending state after a successful restore operation.
  • WITHOUT ROLLING FORWARD。你不能在成功的还原操作之后指定数据库置于rollforward等待状态
  • PARALLELISM n. You cannot indicate the degree of parallelism for the restore operation.
  • WITHOUT PROMPTING. You cannot specify that a restore operation is to run unattended你不能指定一个还原操作(无人参与情况下)

In addition, the recover utility does notallow you to specify any of the REBUILD options. However, therecovery utility will automatically use theappropriate REBUILD option if it cannot locate any database backupimages based on the information in the recovery history file.

另外,recover工具不允许你去指定任何的REBUILD选项。然而recover工具将自动使用对应的REBUILD选项,如果他不能定位任何的数据库备份镜像。

For the RECOVER DATABASE command,you cannot use the TABLESPACE option orthe INCREMENTAL option from the RESTORE DATABASE command.

同RECOVER DATABASE命令一样,你不能为restore database使用tablespace选项或者incremental选项

For the RECOVER DATABASE command, restore optionis automated. Same applies for the REBUILD option in the RESTORE command.

对于recover database命令来说,restore选项是自动的。与restore命令的rebuild选项应用时相同的。

Parent topic: Data recovery

 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值