recover database until scn 100 ,

Maclean Liu(刘相兵

Question :recover database until scn 100 ,包不包含100这个时刻的数据？

Maclean Liu(刘相兵

Answer:

Until change
Performs a incomplete recovery.
The number that follows until change is an SCN. In order to recover up to and including SCN 999, use recover until change 1000.

recover until  scn 100  ， 不recover 到包含scn 100 时刻的数据变化，  但是recover 包含 到scn 99的数据变化。

Maclean Liu(刘相兵

其他的选项如 until sequence 、 until time 也是类似的:

Following are examples of typical date settings in RMAN commands:

BACKUP ARCHIVELOG FROM TIME 'SYSDATE-31' UNTIL TIME 'SYSDATE-14';
RESTORE DATABASE UNTIL TIME "TO_DATE('09/20/00','MM/DD/YY')";
Keywords and Parameters

Syntax Element         Description
UNTIL TIME = 'date_string'

Specifies a time as an upper limit. RMAN selects only files that can be used to recover up to but not including the specified time. For example, LIST BACKUP UNTIL TIME 'SYSDATE-7' lists all backups that could be used to recover to a point one week ago.

UNTIL SCN = integer

Specifies an SCN as an upper limit. RMAN selects only files that can be used to 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.

UNTIL SEQUENCE = integer THREAD = integer

Specifies a redo log sequence number and thread as an upper limit. RMAN selects only files that can be used to recover up to but not including the specified sequence number. For example, REPORT OBSOLETE UNTIL SEQUENCE 8000 THREAD 1 reports only backups that could be used to recover through log sequence 7999.

lory

如果指定恢复到until change 123，那么不包含到123，是到122
但是datafile恢复的checkpoint_change#却是123
db:9.2.0.4
os:windows 2003 32 bit

如下
SQL> recover database using backup controlfile until change 46778968271
ORA-00279: change 46778968269 generated at 12/19/2012 11:28:47 needed for
thread 1
ORA-00289: suggestion : E:\ARCHIVELOG\ARC1154506.001
ORA-00280: change 46778968269 for thread 1 is in sequence #1154506


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
Log applied.
Media recovery complete.
SQL> select distinct checkpoint_change# from v$datafile_header;

CHECKPOINT_CHANGE#
------------------
        4.6779E+10

SQL> set numw 12
SQL> r
  1* select distinct checkpoint_change# from v$datafile_header

CHECKPOINT_CHANGE#
------------------
       46778968271

SQL>