恢复控制文件后，数据库使用resetlogs方式打开，在线日志的序列被重置。
恢复控制文件后，数据库使用resetlogs方式打开，在线日志的序列被重置。
sys@practice >select group#,sequence#,archived,status,first_change#,next_change# from v$log;
group# sequence# arc status first_change# next_change#
---------- ---------- --- ---------------- ------------- ------------
1 1 no current 1014415 2.8147e+14
2 0 yes unused 0 0
3 0 yes unused 0 0
如果没有被resetlog截断的话当前日志的序列号应该是7，8，9
sys@practice >select recid,sequence#,first_change#,next_change# from v$log_history;
recid sequence# first_change# next_change#
---------- ---------- ------------- ------------
1 1 925702 955284
2 2 955284 955847
3 3 955847 971151
4 4 971151 987800
5 5 987800 997957
6 6 997957 1010981
7 1 1010981 1013463
8 2 1013463 1013471
9 3 1013471 1014415
如果恢复完控制文件，不使用resetlogs是打不开数据库的。
我们可以采取手工创建控制文件的方法打开数据库，保持联机日志的sequence#连续。下面的实验来演示具体操作过程。
在实验之前先手工切换3次日志，使得在线日志的序列号产生变化。在恢复结束后作为参考。
sys@practice >alter system archive log current;
sys@practice >alter system archive log current;
sys@practice >alter system archive log current;
切换后当前连接日志状态如下
sys@practice >select group#,sequence#,archived,status,first_change#,next_change# from v$log;
group# sequence# arc status first_change# next_change#
---------- ---------- --- ---------------- ------------- ------------
1 4 no current 1030130 2.8147e+14
2 2 yes inactive 1030109 1030117
3 3 yes active 1030117 1030130
1，恢复控制文件
rman> startup force nomount;
oracle instance started
total system global area 580395008 bytes
fixed size 2255392 bytes
variable size 402654688 bytes
database buffers 171966464 bytes
redo buffers 3518464 bytes
rman> restore controlfile from autobackup;
starting restore at 06-oct-14
using target database control file instead of recovery catalog
allocated channel: ora_disk_1
channel ora_disk_1: sid=19 device type=disk
recovery area destination: /u01/fast_recovery_area
database name (or database unique name) used for search: practice
channel ora_disk_1: autobackup /u01/fast_recovery_area/practice/autobackup/2014_10_06/o1_mf_s_860251717_b35s05gm_.bkp found in the recovery area
channel ora_disk_1: looking for autobackup on day: 20141006
channel ora_disk_1: restoring control file from autobackup /u01/fast_recovery_area/practice/autobackup/2014_10_06/o1_mf_s_860251717_b35s05gm_.bkp
channel ora_disk_1: control file restore from autobackup complete
output file name=/u01/oradata/practice/control01.ctl
output file name=/u01/fast_recovery_area/practice/control02.ctl
finished restore at 06-oct-14
2，启动数据库到mount状态
rman> mount database;
database mounted
released channel: ora_disk_1
3，恢复数据库
rman> recover database;