使用脚本，自动跳过丢失归档的恢复--------MODIFY SEQ

[oracle@lunar bbed]$ . ~/travel.env 

[oracle@lunar ~]$ env|grep ORA
ORACLE_SID=travel
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1
[oracle@lunar ~]$
[oracle@lunar ~]$ cd /test/clonedb/
[oracle@lunar clonedb]$  
[oracle@lunar clonedb]$ ls -lrt
total 934264
-rw-r----- 1 oracle oinstall  10493952 Aug 16 03:09 roger01.dbf.bak
-rw-r--r-- 1 oracle oinstall       629 Jan 28 00:42 pfilebb.ora
-rw-r--r-- 1 oracle oinstall       638 Jan 28 00:43 pfiletravel.ora
-rw-r--r-- 1 oracle oinstall      7959 Jan 28 00:47 ctl.bak
-rw-r----- 1 oracle oinstall  43470848 Jan 28 00:48 0vo0gofc_1_1.bak
-rw-r----- 1 oracle oinstall      4608 Jan 28 00:49 12o0gogl_1_1.bak
-rw-r----- 1 oracle oinstall  10493952 Feb  4 19:26 temp01.DBF
-rw-r----- 1 oracle oinstall   5251072 Feb  4 19:53 users01.DBF
-rw-r----- 1 oracle oinstall 209723392 Feb  4 19:53 undotbs01.DBF
-rw-r----- 1 oracle oinstall 524296192 Feb  4 19:53 SYSTEM01.DBF
-rw-r----- 1 oracle oinstall 115351552 Feb  4 19:53 sysaux01.DBF
-rw-r----- 1 oracle oinstall  10493952 Feb  4 19:53 roger01.dbf
-rw-r----- 1 oracle oinstall  10486272 Feb  4 19:53 redo03.log
-rw-r----- 1 oracle oinstall  10486272 Feb  4 19:53 redo02.log
-rw-r----- 1 oracle oinstall  10486272 Feb  4 19:53 redo01.log
[oracle@lunar clonedb]$ cp roger01.dbf.bak roger01.dbf
[oracle@lunar clonedb]$ ss


SQL*Plus: Release 11.2.0.3.0 Production on Mon Feb 4 19:53:53 2013


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


Connected to an idle instance.


SQL> startup
ORACLE instance started.


Total System Global Area  530288640 bytes
Fixed Size                  2230024 bytes
Variable Size             167774456 bytes
Database Buffers          352321536 bytes
Redo Buffers                7962624 bytes
Database mounted.
ORA-01113: file 5 needs media recovery
ORA-01110: data file 5: '/test/clonedb/roger01.dbf'




SQL> recover datafile 5;
ORA-00279: change 521392 generated at 08/16/2012 03:07:34 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_27_805858745.dbf
ORA-00280: change 521392 for thread 1 is in sequence #27




Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 521876 generated at 08/16/2012 03:21:17 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_28_805858745.dbf
ORA-00280: change 521876 for thread 1 is in sequence #28




ORA-00308: cannot open archived log '/u01/archive/1_28_805858745.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
SQL> select sequence#,FIRST_CHANGE#,next_change# from v$archived_log where sequence#>=28;


 SEQUENCE# FIRST_CHANGE# NEXT_CHANGE#
---------- ------------- ------------
        28        521876       521884
        29        521884       521887
        30        521887       522050
        31        522050       522089
        32        522089       542092
        33        542092       544956
        34        544956       545457
        35        545457       548545


8 rows selected.


[oracle@lunar clonedb]$ cd /test
[oracle@lunar test]$ cd bbed




[oracle@lunar bbed]$ ./modify_seq.sh 521884 /test/bbed/filelist.txt 29 
1+0 records in
1+0 records out
1048576 bytes (1.0 MB) copied, 0.00223157 seconds, 470 MB/s
9cf6
0700
0000
1d
[oracle@lunar bbed]$ 
SQL> recover datafile 5;
ORA-00279: change 521884 generated at 08/16/2012 03:21:17 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_29_805858745.dbf
ORA-00280: change 521884 for thread 1 is in sequence #29




Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 521887 generated at 08/16/2012 03:21:37 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_30_805858745.dbf
ORA-00280: change 521887 for thread 1 is in sequence #30




ORA-00279: change 522050 generated at 08/16/2012 03:29:28 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_31_805858745.dbf
ORA-00280: change 522050 for thread 1 is in sequence #31




ORA-00279: change 522089 generated at 08/16/2012 03:31:07 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_32_805858745.dbf
ORA-00280: change 522089 for thread 1 is in sequence #32




ORA-00279: change 542092 generated at 02/04/2013 18:17:24 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_33_805858745.dbf
ORA-00280: change 542092 for thread 1 is in sequence #33




ORA-00279: change 544956 generated at 02/04/2013 18:57:01 needed for thread 1
ORA-00289: suggestion : /u01/archive/1_34_805858745.dbf
ORA-00280: change 544956 for thread 1 is in sequence #34




Log applied.
Media recovery complete.
SQL> 
SQL> alter database datafile 5 online;


Database altered.


SQL> alter database open;


Database altered.


SQL> select count(*) from roger.t1;


  COUNT(*)
----------
         0


SQL>