您还可以将受影响的行复制到备份表,以防万一!
And yes, you might also copy the affected row to a backup table just in case!
备份是严格按照顺序进行的,这意味着在备份了表空间1中的数据文件后,将继续备份表空间2中的数据文件。
The backup is restricted to sequential backup meaning after backing up data files in tablespace1 then go on for data files in tablespace2.
由于可以在表空间级进行备份,所以还可以进行粒度控制。
You also have granular control since you can back up at the table space level.
能够从表空间备份映像中重新构建数据库。
The ability to rebuild databases from table space backup images.
在备份之后,增量备份就可以包含新的表空间。
After the backup, incremental backups are permitted to contain the new table space.
按照这些步骤对数据库或表空间进行在线备份。
Follow these steps to back up databases or table Spaces online.
注意,允许进行组合数据库和表空间增量备份。
Note that the combination database and table space incremental backups are permitted.
用好的备份映像联机恢复表空间。
作为一种更好、更灵活的维护选项,可以选择在表空间级进行备份。
For a better and more flexible maintenance option, you can choose to back up at the table space level.
表空间级备份。
在采用默认行为时,用户必须对进行装载的每个表空间进行备份。
With the default behavior, the user is forced to take backups of each tablespace that was loaded into.
但有时候,对较大的数据库执行表空间级备份会更经济。
However, sometimes it is more economical to do tables space level backup for larger size databases.
在一些后续步骤中,您需要用到被删除表备份id和DDL。
You will need the backup ID and the DDL for the dropped table in the subsequent steps.
除了RUNSTATS外,还可以将数据库备份和REORG(表和索引数据整理)自动化。
In addition to the RUNSTATS, you can automate database backups and REORGs (defragmentation of table and index data).
要执行表空间级联机备份,可以发出以下命令。
To do a tables space level online backup, issue the command.
在没有前滚操作的情况下,使用备份映像来恢复表空间。
Restore table space using the backup image without rolling forward.
备份数据库或表空间。
对于大型环境,mysqldump执行起来很慢;但是,在备份重要的表时它非常有用。
Mysqldump is much slower to execute for larger environments; however, it's particularly useful when it comes to backing up important tables.
dump命令也可以用于备份数据库表。
The.dump command can also be used to back up a database table.
这样可以将那些关键的表分离出来进行备份,而留下其他那些不需要备份或者不需要经常备份的表。
This lets you isolate key tables for backup, leaving other tables that don't need to be backed up at all, or as often.
如果没有备份这个表空间,那么只能对其中包含的表进行查询,而无法更新它们。
If the table space is not backed up, tables within that table space can be queried, but not updated.
对于联机备份,有两种可以采用的备份级别:表空间级和数据库级联机备份。
For online backups, there are two levels of backups that can be taken, table space and database level online backup.
碎片整理程序不能在已分区分区、备份服务器、或者临时表上运行。
The defragmenter may not be run on the partition partition, secondary server, or a temporary table.
但是,如果选择表空间备份,那么必须在下个页面中选择要进行在线备份的表空间。
If, however, table space backup is selected, you have to select table Spaces that you desire to do online backup on the next page.
在数据库处于循环日志记录模式时,单个表空间的备份不受支持。
Backing up individual table Spaces is not supported while the database is in circular logging mode.
注意,这个操作是不可恢复的,因此如果需要将数据库恢复到完成表移动与备份之间的某个时间点,那么表可能会丢失。
Note that this operation is not recoverable, so if you need to recover your database to the point in time between the table move completion time and following backup, the table may get lost.
在DB2中运行在线备份的惟一约束是:当一个表空间正在被备份的时候,不能删除这个表空间。
The only restriction when running an online backup in DB2 is that you cannot drop a table space while that table space is actively being backed up.
对于数据库,表空间级备份是否就够了,还是需要完整的数据库备份?
For the database, are table space level backups sufficient, or are full database backups necessary?
用于添加保护之前,修改备份注册表。
For added protection, back up the registry before you modify it.
因此,在执行数据转移操作之后,应该执行数据库备份,至少是表空间备份。
Thus a database backup, or at least a tablespace backup, should be executed following the data movement operation.
应用推荐