对于数据库,表空间级备份是否就够了,还是需要完整的数据库备份?
For the database, are table space level backups sufficient, or are full database backups necessary?
DB 2HighPerformanceUnload还能够重新分配数据,帮助提高备份和恢复操作的速度,它启用了从完整的数据库备份卸载和恢复单个表的功能。
DB2 High Performance unload can also repartition data and help speed backup and recovery operations by enabling unload and recovery of single tables from a full database backup.
目前,确保全面回滚能力的唯一方法是在部署前进行完整的文件系统和数据库备份。
Currently, the only way to ensure total rollback capability is to do a full file system and database backup before the deployment.
换句话说,您必须对数据库进行完整的备份,从而为执行增量备份提供一个基准点。
In other words, you must take a full database backup so that you have a baseline against which incremental backups can be taken.
由于总是可以而进行完整而又精确的数据库备份,所以您可以更快地恢复数据,从而更好地遵守sla并显著降低停机成本。
Because a complete and accurate data backup is always available, you can recover data more quickly for better compliance with SLAs and for a significantly reduced cost of downtime.
检查备份镜像的完整性使用db2ckbkp命令。要检查整个数据库的健康状况,可使用HealthCenterGUI。
To check the integrity for backup images, use db2ckbkp command for the entire database health systemwide, use the health Center GUI.
备份与恢复是数据库管理员维护数据库安全性和完整性的重要操作。
The database manager defends the database security and the complete important operation is the backup with restores.
维护和跟踪这些完整备份是一种耗时的任务,所需空间可能会超过完整数据库备份的所需空间。
Maintaining and keeping track of a complete set of these backups can be a time-consuming task that might outweigh the space requirements of full database backups.
上述命令支持完整数据库备份的数据库恢复,不支持表空间级别的数据库恢复。
SQL2560N The target database is not identical to the source database for a restore from a table space level backup.
上述命令支持完整数据库备份的数据库恢复,不支持表空间级别的数据库恢复。
SQL2560N The target database is not identical to the source database for a restore from a table space level backup.
应用推荐