备份中断引起的数据文件一致性问题

[复制链接]
查看11 | 回复6 | 2011-11-1 16:23:26 | 显示全部楼层 |阅读模式
今天看文档里有这段话,其中加黑部份不是很理解。谁能给解释一下?
RMAN backups called by media management vendors’ software can be automated to the extent that your involvement as a DBA is minimal. This is sometimes executed and controlled by the backup coordinator, which may reside within the systems administrators group. When the backup terminates for some reason, it is often difficult for you to know the extent of a backup failure and why a backup has failed, unless good communication is set up, thus leaving the database partially in backup mode with some tablespaces and the associated datafiles active in backup. Furthermore, jobs could be incomplete and hanging in the recovery catalog.

What happens when the database goes down when a tablespace or all tablespaces are in is in backup mode? The datafile is not checkpointed so that it is consistent with the rest of the database.When the database is restarted, the datafile is marked as inconsistent and in need of recovery.This situation can come as an unwanted surprise when you are bouncing the database for some reason.
You can remedy this situation without recovery by issuing the ALTER DATAFILE ‘datafile name’ END BACKUP command to fix this tablespace or by issuing the new Oracle 10g command ALTER DATABASE END BACKUP for all tablespaces at the same time. However, this situation can be avoided by checking the V$BACKUP table to validate that it is safe to shut down the database.


回复

使用道具 举报

千问 | 2011-11-1 16:23:26 | 显示全部楼层
看一下oracle 关于热备方面的工作原理就知道了~就是checkpoint在热备的开始结束各个阶段的变化~
这个文档的意义不大~基本没人这么备份了
回复

使用道具 举报

千问 | 2011-11-1 16:23:26 | 显示全部楼层
iori809 发表于 2013-1-9 14:26
看一下oracle 关于热备方面的工作原理就知道了~就是checkpoint在热备的开始结束各个阶段的变化~
这个文档的 ...

你有啥好文档推荐一下吗?
回复

使用道具 举报

千问 | 2011-11-1 16:23:26 | 显示全部楼层
LQF33 发表于 2013-1-9 14:53
你有啥好文档推荐一下吗?

这个就是用户管理的热备啊!
回复

使用道具 举报

千问 | 2011-11-1 16:23:26 | 显示全部楼层
LQF33 发表于 2013-1-9 14:53
你有啥好文档推荐一下吗?

这个就是用户管理的热备啊!
回复

使用道具 举报

千问 | 2011-11-1 16:23:26 | 显示全部楼层
LQF33 发表于 2013-1-9 14:53
你有啥好文档推荐一下吗?

这个就是用户管理的热备啊!
回复

使用道具 举报

千问 | 2011-11-1 16:23:26 | 显示全部楼层
LQF33 发表于 2013-1-9 14:53
你有啥好文档推荐一下吗?

这个就是用户管理的热备啊!
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行