数据库：是如何区分热备的呢?A standby server that cannot be connected to until it is promoted to a master server is called a “warm standby server”,and one that can accept connections and serves read-only queries is called a “hot sta
来源：学生作业帮助网 编辑：六六作业网 时间：2024/12/26 11:43:33
数据库：是如何区分热备的呢?A standby server that cannot be connected to until it is promoted to a master server is called a “warm standby server”,and one that can accept connections and serves read-only queries is called a “hot sta
数据库：是如何区分热备的呢?
A standby server that cannot be connected to until it is promoted to a master server is called a “warm standby server”,and one that can accept connections and serves read-only queries is called a “hot standby server”.
这两个热备说法有什么区别呢?
数据库：是如何区分热备的呢?A standby server that cannot be connected to until it is promoted to a master server is called a “warm standby server”,and one that can accept connections and serves read-only queries is called a “hot sta
热备份支持在数据库不停机的情况下进行备份,冷备份是必须在数据库shutdown以后使用操作系统的命令对表空间进行拷贝进行的备份.
热备份适用于重要的数据库,比如7x24不能中断的生产系统,同时可以保证数据库在出现崩溃时结合归档日志可以恢复到任意一个时间点,不会造成数据丢失.
冷备份在数据库出现问题是 只会恢复到备份时的那一时间点,备份完成到数据库出现问题需要恢复时的这一时间段内的所有新数据、修改记录都无法恢复.
热备份只能在归档模式下进行,冷备份不需要归档模式,归档模式会对系统性能尤其是磁盘I/O造成一定的影响,但是相对于归档的好处和安全性,相信大多数DBA都会选择归档模式.