ORA-01190: control file or data file 6 is from before the last RESETLOGS

SCN 이 달라서 데이터파일이 온라인으로 안되는 경우

SYS> @df TS_NAME    FILE_NAME                                             MB STATUS ---------- -------------------------------------------------- ----- -------- SYSTEM     /data/temp/system01.dbf                             2010 SYSTEM SYSAUX     /data/temp/sysaux01.dbf                              520 ONLINE UNDOTBS1   /data/temp/undotbs01.dbf                              90 ONLINE USERS       /data/temp/users01.dbf                                 5 ONLINE EXAMPLE    /data/temp/example01.dbf                             346 ONLINE TS_WEBHARD /data/temp/ts_web01.dbf                              100 ONLINE TS_WEB_IDX /data/temp/ts_web_idx01.dbf                           10 OFFLINE 7 rows selected.   SYS> alter database datafile '/data/temp/ts_web_idx01.dbf' online; alter database datafile '/data/temp/ts_web_idx01.dbf' online * ERROR at line 1: ORA-01190: control file or data file 7 is from before the last RESETLOGS ORA-01110: data file 7: '/data/temp/ts_web_idx01.dbf' SQL> recover datafile '/data/temp/ts_web_idx01.dbf'    ORA-00279: change 1242623 generated at 07/04/2013 05:17:03 needed for thread 1 ORA-00289: suggestion : /data/arc1/3_1_819794020.arc ORA-00280: change 1242623 for thread 1 is in sequence #3 Specify log: {<RET>=suggested | filename | AUTO | CANCEL} AUTO   어쩌구저쩌구 많이 나옴   Log applied. Media recovery complete.   SYS> alter database datafile '/data/temp/ts_web_idx01.dbf' online; Database altered. 정상적으로 온라인 되었다.