restore 后没有恢复，时的scn 情况

SQL> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#
------------------
1272749453

SQL> select file#,checkpoint_change#,last_change# from v$datafile;

FILE# CHECKPOINT_CHANGE# LAST_CHANGE#
---------- ------------------ ------------
1 1272750081
2 1272750082
3 1272750134
4 1272750135

SQL> select file#,checkpoint_change# from v$datafile_header;

FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 1272750081
2 1272750082
3 1272750134
4 1272750135

SQL> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#
------------------
1272749453

SQL> select group#,sequence#,first_change# ,status from v$log;

GROUP# SEQUENCE# FIRST_CHANGE# STATUS
---------- ---------- ------------- ----------------
1 1 1272749452 ACTIVE
3 0 0 UNUSED
2 2 1272750072 CURRENT

recover 后的 scn 变化：

SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Dec 18 10:42:42 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: FCARD (DBID=2783238366, not open)

RMAN> recover database;

Starting recover at 18-DEC-07
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=276 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=275 devtype=DISK

starting media recovery

archive log thread 1 sequence 2 is already on disk as file /u01/oracle/oradata/fcard/redo02.log
archive log filename=/u01/oracle/oradata/fcard/redo02.log thread=1 sequence=2
media recovery complete, elapsed time: 00:00:02
Finished recover at 18-DEC-07

RMAN> exit

Recovery Manager complete.

$ sqlplus "/ as sysdba"

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Dec 18 10:43:14 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#
------------------
1272749453

SQL> select file#,checkpoint_change#,last_change# from v$datafile;

FILE# CHECKPOINT_CHANGE# LAST_CHANGE#
---------- ------------------ ------------
1 1272750701 1272750701
2 1272750701 1272750701
3 1272750701 1272750701
4 1272750701 1272750701

SQL> select file#,checkpoint_change# from v$datafile_header;

FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 1272750701
2 1272750701
3 1272750701
4 1272750701

SQL> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#
------------------
1272749453

SQL> select group#,sequence#,first_change# ,status from v$log;

GROUP# SEQUENCE# FIRST_CHANGE# STATUS
---------- ---------- ------------- ----------------
1 1 1272749452 ACTIVE －－－－状态是archive ,所以系统检查点1272749453
3 0 0 UNUSED
2 2 1272750072 CURRENT

resetlog 后各部分 scn各个变化：

SQL> alter database open resetlogs;

Database altered.

SQL> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#
------------------
1272750703

SQL> select file#,checkpoint_change#,last_change# from v$datafile;

FILE# CHECKPOINT_CHANGE# LAST_CHANGE#
---------- ------------------ ------------
1 1272750703
2 1272750703
3 1272750703
4 1272750703

SQL> select file#,checkpoint_change# from v$datafile_header;

FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 1272750703
2 1272750703
3 1272750703
4 1272750703

SQL> select group#,sequence#,first_change# ,status from v$log;

GROUP# SEQUENCE# FIRST_CHANGE# STATUS
---------- ---------- ------------- ----------------
1 0 0 UNUSED
2 1 1272750702 CURRENT
3 0 0 UNUSED