- 最后登录
- 2017-9-1
- 在线时间
- 19 小时
- 威望
- 42
- 金钱
- 450
- 注册时间
- 2012-1-10
- 阅读权限
- 10
- 帖子
- 26
- 精华
- 1
- 积分
- 42
- UID
- 163
|
1#
发表于 2012-2-23 16:32:17
|
查看: 6206 |
回复: 8
官方文档B14191.PDF中64页,关于CONSISTENT备份有如下描述:
Consistent :
A backup taken when the database is mounted (but not open) after a
normal shutdown. The checkpoint SCNs in the datafile headers match the
header information in the control file. None of the datafiles has changes
beyond its checkpoint. Consistent backups can be restored without
recovery.
Note: If you restore a consistent backup and open the database in
read/write mode without recovery, transactions after the backup are lost.
You still need to perform an OPEN RESETLOGS.
我的问题是NOTE里说: 如果恢复CONSISTENT 备份不做RECOVER动作,并以读写模式打开数据库,备份以后以来的TRANSACTIONS将丢失,需要做OPEN RESETLOGS
我的疑惑点是,既然我的备份是CONSISTENT的,那么我直接就能打开数据库,哪里来备份后的TRANSACTION, 因为CONSISTENT备份情况下我的库并不处于OPEN状态,怎么会有TRANSACTION?? 怎么还要OPEN RESETLOGS. 因为我恢复CONSISTENT备份就可以直接正常以读写模式OPEN啊。 |
|