======== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/05/2015 16:49:01
RMAN-06556: datafile 1 must be restored from backup older than SCN 543532
–datafile 1 当前的scn是543533晚于543532，until scn 改为543533
sys@TEST> select file#,name,status,checkpoint_change# from v$datafile;
FILE# NAME STATUS CHECKPOINT_CHANGE#
1 /home/u01/app/oracle/oradata/test/system01.dbf SYSTEM 543533
2 /home/u01/app/oracle/oradata/test/sysaux01.dbf RECOVER 543533
3 /home/u01/app/oracle/oradata/test/undotbs01.dbf RECOVER 543533
4 /home/u01/app/oracle/oradata/test/users01.dbf RECOVER 543533
5 /home/u01/app/oracle/oradata/test/test.dbf RECOVER 542863
6 /home/u01/app/oracle/oradata/test/example.dbf RECOVER 543533
7 /home/u01/app/oracle/oradata/test/indx.dbf RECOVER 543533
8 /home/u01/app/oracle/oradata/test/tool.dbf RECOVER 543533
9 /home/u01/app/oracle/oradata/test/oltp.dbf RECOVER 543533
RMAN> recover database until scn 543533;
Starting recover at 05-MAR-15
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 3 is already on disk as file /home/u01/app/oracle/archivelog/1_3_873486141.dbf
archived log for thread 1 with sequence 4 is already on disk as file /home/u01/app/oracle/archivelog/1_4_873486141.dbf
archived log for thread 1 with sequence 5 is already on disk as file /home/u01/app/oracle/archivelog/1_5_873486141.dbf
archived log for thread 1 with sequence 1 is already on disk as file /home/u01/app/oracle/oradata/test/redo01.log
archived log file name=/home/u01/app/oracle/archivelog/1_3_873486141.dbf thread=1 sequence=3
archived log file name=/home/u01/app/oracle/archivelog/1_4_873486141.dbf thread=1 sequence=4
archived log file name=/home/u01/app/oracle/archivelog/1_5_873486141.dbf thread=1 sequence=5
media recovery complete, elapsed time: 00:00:01
Finished recover at 05-MAR-15
10.打开数据库，并验证
sys@TEST> alter database open resetlogs;
Database altered.
sys@TEST> select count(*) from test.a;