alter database recover automatic standby datafile 3 until controlfile

[bjwang112006]

alter database recover automatic standby datafile 3 until controlfile


until controlfile是啥意思

[秋雨飘落]

1. recover database using backup controlfile

2. recover database until cancel

3. recover database using backup controlfile until cancel;

4. recover database until cancel using backup controlfile;


区别：


1. 如果丢失丢失当前控制文件，用冷备份的控制文件恢复的时候。用来告诉oracle，不要以controlfile中的scn作为恢复的终点；

2. 如果丢失current/active redo的时候。手动指定终点。

3. 如果 丢失当前controlfile并且current/active redo都丢失，会先去 自动 应用归档日志,可以实现最大的恢复；

4. 如果 丢失当前controlfile并且current/active redo都丢失，以旧的redo中的scn为恢复终点。因为没有应用归档日志，所有会丢失数据。

[bjwang112006]

[Quote=引用楼主 bjwang112006 的回复:]
alter database recover automatic standby datafile 3 until controlfile


until controlfile是啥意思
[/Quote]
谢谢你细心的回答，但不是我要的答案

[bjwang112006]

Specify UNTIL [CONSISTENT WITH] CONTROLFILE if you want the recovery of an old standby datafile or tablespace to use the current standby database control file. However, any redo in advance of the standby controlfile will not be applied. The keywords CONSISTENT WITH are optional and are provided for semantic clarity.

到底是恢复还是不恢复 old standby datafile 和current standby database control file之间相差的数据