RMAN中RESTORE 命令的until 使用

2009532140

最先答对且答案未经编辑的cuber将根据试题的难度可能获得10-50不等的积分悬赏：
注意：会员需对此贴答案进行说明和简要分析，无说明者不能获得奖励。
或者，给出相关的文档说明，如果能用实验模拟的积分翻倍。

What is the purpose of the until change option of the restore command?

A.  It allows you to select the SCN that you want to restore to.
B.  It allows you to select the log sequence number you want to restore to.
C.  It allows you to select the timestamp you want to restore to.
D.  It allows you to manually stop the restore at any time as online redo logs are applied.
E.  None of the above.

www_xylove

SCN吧
A

Syntax Element        Description
UNTIL SCN = integer        Specifies an SCN as an upper limit. RMAN selects only files that can be used to restore or recover up to but not including the specified SCN. For example, RESTORE DATABASE UNTIL SCN 1000 chooses only backups that could be used to recover to SCN 1000.

2009532140

看官方文档B,C貌似也可以啊。等我明天把页面发上来…

www_xylove

回复 3# 2009532140

你去查一下，我确认是A。

until change 是指until scn
并非until sequence
并非until timestamp

A是恢复到一个SCN号
B是恢复到一个日志序列号
C是恢复到一个时间点
D是手工指定到一个时间点
E是上面的都不对

我再次确信是A

谢谢



   

2009532140

回复 4# www_xylove


    To recover the database until a specified time, SCN, or log sequence number

www_xylove

回复 5# 2009532140

看清楚题意：
"....until change option ..."

你这个“To recover the database until a specified time, SCN, or log sequence number”，的确是这样的，但是题意只有你选择SCN。
明白吗？




   

2009532140

回复 4# www_xylove


    Type of Recovery        Function
  -------------------     ----------------------------
  Time-based recovery     Recovers the data up to a specified point in time.
  Cancel-based recovery   Recovers until you issue the CANCEL statement (not available when using Recovery Manager).
  Change-based recovery   Recovers until the specified SCN.
  Log sequence recovery   Recovers until the specified log sequence number (only available when using Recovery Manager).

www_xylove

题意就是Change-based recovery   Recovers until the specified SCN. 这个。