[oracle@lunar bbed]$ . ~/travel.env
[oracle@lunar ~]$ env|grep ORAORACLE_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>