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.
정상적으로 온라인 되었다.
|
