在这个卷组上定义了DB 2数据库的所有存储组件,包括表空间、日志和备份。
All storage components of the DB2 database were defined on this volume group, including tablespaces, log, and backups.
完全备份——备份整个数据库,包括所有的文件组合事务日志。
Full backup — Backs up the full database, including all file groups and transaction logs.
关闭数据库,备份所有数据以及所有日志和控制文件。
Shut the database down and back up all data and all log and control files.
只要涉及到资源管理器和库服务器数据库,一旦有了一次原始备份,并且所有日志均完好无损,即可保证不损失任何数据。
As far as Resource Manager and Library Server databases are concerned, once you have a baseline backup and all logs are intact, there is a guarantee that there will be no loss of data.
如果系统或媒体发生失败,您可以使用事务日志和第三方备份实用工具恢复数据库。
Then if a system or media failure occurs, you can use the transaction log and a third-party backup utility to recover your database.
对于DB 2LUW,您可以备份的内容取决于数据库的日志模式。
For DB2 LUW, what you can backup depends on the logging mode of the database.
打开存档日志时需要执行一次离线全数据库备份。
Turning archive logging on requires an offline full database backup.
然后还原最近的干净的数据库备份和随后的日志备份,包含上一步做的日志备份.
Then restore the latest clean database backup and the subsequent log backups, including the one taken in above step.
另一种机制通过使用全备份,并前滚事务日志,使数据库恢复到最近的状态,这种机制也叫前滚恢复。
The second restores to the most recent state, using a combination of full backup plus rolling forward the transaction log, called rollforward recovery.
在使数据库进入备份模式之前,需要使用归档日志。
Before you can put a database in hot backup mode, you need to use the archive log.
清单4:从备份恢复salesdb数据库并将事务日志放在不同的位置。
Listing 4: Restoring the salesdb database from a backup and placing the transaction log in different location.
最后,数据库和表空间的在线备份镜像将包括一组日志文件,在将备份镜像恢复到某个一致的时间点时,这些文件是必需的。
Finally, online backup images of databases and table Spaces will include the set of log files necessary to restore and recover the backup image to a consistent point in time.
在该场景的某一个步骤中,您在更改了日志记录选项后,对数据库执行完全离线备份。
During one of the steps of the scenario, you perform a full offline backup of the database after changing the logging option.
如果使用在线备份,要知道除非具有在DB 2备份数据库时发生的所有事务的日志,否则备份映像没有任何作用。
If using online backup, recognize that the backup image will be useless without the logs of all transactions that occurred while DB2 was backing up the database.
当执行离线数据库备份时,需要单独备份编目分区。但是,在线备份时就不需要这样,因为日志是包括在备份镜像中的。
When performing an offline database backup, the catalog partition needs to be backed separately; however, this is not a concern with online backups, as the logs are included in the backup image.
在数据库处于循环日志记录模式时,单个表空间的备份不受支持。
Backing up individual table Spaces is not supported while the database is in circular logging mode.
DB 2提供了一种自动调度备份任务的机制,还可以保存事务日志,可以使用事务日志将数据库恢复到发生崩溃的时间点。
DB2 provides a mechanism to automatically schedule backups and to keep transaction logs that can be used to restore to the exact point of the crash.
如果数据库处于循环日志记录模式,只允许脱机备份数据库。
If the database is in a circular logging mode, only offline backup of the database is allowed.
您可以在数据库上启用归档日志记录模式,并开始联机备份数据库以及备份数据库中的一组表空间。
You can enable archive logging mode on the database and start taking online backups of the database as well as backups of a set of table Spaces in the database.
在使用循环日志时,只能进行离线全数据库备份。
With circular logging, only offline full database backup is possible.
RECOVER会恢复最近的备份,然后执行一个日志应用进程,将表空间或数据库带到一个指定的数据点。
RECOVER will do the RESTORE of the most recent backup, followed by a log apply process to bring the table space or database to a specified point in time.
在对数据库进行在线备份之前,首先需要将日志机制从默认的循环日志改为存档日志。
Before any attempts to back up a database online, first and foremost, the logging mechanism needs to be modified from the default circular logging to archive logging.
转到想执行备份的数据库(例如Sample),右击Backup注意,屏幕上显示了日志记录的状态。
Go to the desired database (for example Sample) and right click on Backup Note that the status of your logging is displayed.
GRANT:为任意主机上的任意用户提供访问db2备份镜像和日志文件的能力,这些镜像和日志文件与发出GRANT选项的节点上生成的数据库有关。
GRANT: Provides any user on any host the ability to access the db2 backup images and log files associated with databases generated on the node issuing the GRANT option.
重要提示:不允许在包含不记入日志的对象(比如不记入日志的blobspaces与不记入日志的数据库)的RSS服务器上执行外部备份。
Important: Performing external backup on an RSS server containing non-logged objects such as non-logged blobspaces, and non-logged databases will not be allowed.
如果让发布能够从备份中初始化,则一旦创建了发布,就会在发布数据库日志中跟踪对已发布表的更改。
If you enable a publication to be initialized from a backup, changes to published tables are tracked in the publication database log as soon as the publication is created.
如果能够在出现故障后备份日志尾部,则可以使用完整恢复模式将数据库恢复到故障点。
The full recovery model allows a database to be recovered to the point of failure, assuming that the tail of the log can be backed up after the failure.
用于备份操作(例如,数据库、日志或文件备份)中的内部数据结构同步。
Used for internal data structure synchronization within a backup operation, such as database, log, or file backup.
因此,极力建议您在切换之前备份日志,这样可允许您将数据库恢复到该点。
Therefore, we strongly recommend that you back up the log immediately before switching, which allows you to recover the database up to that point.
因此,极力建议您在切换之前备份日志,这样可允许您将数据库恢复到该点。
Therefore, we strongly recommend that you back up the log immediately before switching, which allows you to recover the database up to that point.
应用推荐