之前介绍了：Oracle数据库RMAN不完全恢复之基于SCN恢复，本文我们主要介绍一下Oracle数据库RMAN不完全恢复之基于日志序列号恢复的相关知识，希望能够对您有所帮助。

基于日志序列号恢复是指恢复数据库到指定日志序列号的状态。

--查看归档日志信息 
SQL>select*fromt_user; 
TEXT 
-------------------- 
java_ 
spring_ 
springmvc_ 
SQL>insertintot_userselect'oracle_'fromdual; 
1rowcreated. 
SQL>commit; 
Commitcomplete. 
SQL>altersystemswitchlogfile; 
Systemaltered. 
SQL>altersystemcheckpoint; 
Systemaltered. 
SQL>selectsequence#,name,first_change#fromv$archived_logwherestatus='A'orderbysequence#; 
SEQUENCE#NAMEFIRST_CHANGE# 
--------------------------------------------------------------------------------------------------------------------------- 
1/oracle/10g/oracle/log/archive_log/archive_1_1_760487088.arclog1214497 
1/oracle/10g/oracle/log/archive_log2/archive_1_1_760487088.arclog1214497 
1/oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_29/o1_mf_1_1_71214498 
5q9bh9d_.arc 
1/oracle/10g/oracle/log/archive_log/archive_1_1_760487985.arclog1214498 
1/oracle/10g/oracle/log/archive_log2/archive_1_1_760487985.arclog1214498 
1/oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_29/o1_mf_1_1_71214497 
5q95ksf_.arc 
6rowsselected. 
SQL>insertintot_userselect'oracle_seq3'fromdual; 
1rowcreated. 
SQL>commit; 
Commitcomplete. 
SQL>altersystemswitchlogfile;--生成日志序列号为2的归档日志 
Systemaltered. 
SQL>altersystemcheckpoint; 
Systemaltered. 
SQL>selectsequence#,name,first_change#fromv$archived_logwherestatus='A'orderbysequence#; 
SEQUENCE#NAMEFIRST_CHANGE# 
--------------------------------------------------------------------------------------------------------------------------- 
1/oracle/10g/oracle/log/archive_log/archive_1_1_760487088.arclog1214497 
1/oracle/10g/oracle/log/archive_log2/archive_1_1_760487088.arclog1214497 
1/oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_29/o1_mf_1_1_71214497 
5q95ksf_.arc 
1/oracle/10g/oracle/log/archive_log/archive_1_1_760487985.arclog1214498 
1/oracle/10g/oracle/log/archive_log2/archive_1_1_760487985.arclog1214498 
1/oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_29/o1_mf_1_1_71214498 
5q9bh9d_.arc 
2/oracle/10g/oracle/log/archive_log/archive_1_2_760487985.arclog1216167 
SEQUENCE#NAMEFIRST_CHANGE# 
--------------------------------------------------------------------------------------------------------------------------- 
2/oracle/10g/oracle/log/archive_log2/archive_1_2_760487985.arclog1216167 
2/oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_29/o1_mf_1_2_71216167 
5q9cvt1_.arc 
9rowsselected. 
SQL>insertintot_userselect'oracle_seq3_act'fromdual; 
1rowcreated. 
SQL>commit; 
Commitcomplete. 
SQL>altersystemswitchlogfile;--生成日志序列号为3的归档日志 
Systemaltered. 
SQL>altersystemcheckpoint; 
Systemaltered. 
SQL>selectsequence#,name,first_change#fromv$archived_logwherestatus='A'orderbysequence#; 
SEQUENCE#NAMEFIRST_CHANGE# 
--------------------------------------------------------------------------------------------------------------------------- 
1/oracle/10g/oracle/log/archive_log/archive_1_1_760487088.arclog1214497 
1/oracle/10g/oracle/log/archive_log2/archive_1_1_760487088.arclog1214497 
1/oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_29/o1_mf_1_1_71214497 
5q95ksf_.arc 
1/oracle/10g/oracle/log/archive_log/archive_1_1_760487985.arclog1214498 
1/oracle/10g/oracle/log/archive_log2/archive_1_1_760487985.arclog1214498 
1/oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_29/o1_mf_1_1_71214498 
5q9bh9d_.arc 
2/oracle/10g/oracle/log/archive_log/archive_1_2_760487985.arclog1216167 
SEQUENCE#NAMEFIRST_CHANGE# 
--------------------------------------------------------------------------------------------------------------------------- 
2/oracle/10g/oracle/log/archive_log2/archive_1_2_760487985.arclog1216167 
2/oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_29/o1_mf_1_2_71216167 
5q9cvt1_.arc 
3/oracle/10g/oracle/log/archive_log/archive_1_3_760487985.arclog1216186 
3/oracle/10g/oracle/log/archive_log2/archive_1_3_760487985.arclog1216186 
3/oracle/10g/oracle/product/10.2.0/db_1/flash_recovery_area/ORALIFE/archivelog/2011_08_29/o1_mf_1_3_71216186 
5q9f4d6_.arc 
12rowsselected. 
--恢复到日志序列号为3时的状态 
[oracle@localhost~]$rmantargetsys/oracle@oralifenocatalog 
RMAN>run{ 
startupforcemount; 
setuntilsequence=3; 
restoredatabase; 
recoverdatabase; 
sql'alterdatabaseopenresetlogs'; 
} 
--查看，可见不包括日志序列号为3的归档日志信息（oracle_seq3_act)，即恢复到日志序列号为2的归档日志 
SQL>connsys/oracle@oralifeassysdba 
Connected. 
SQL>select*fromt_user; 
TEXT 
-------------------- 
java_ 
spring_ 
oracle_ 
oracle_seq3 
springmvc_

可见不包括日志序列号为3的归档日志信息（oracle_seq3_act)，即恢复到日志序列号为2的归档日志。

在执行了不完全恢复之后，推荐删除早期所有备份，重新备份数据库。