ORA-01122 에러처리...
얼마전에 DB를 ShutDown 시틸려고 했는데
아래와 같은 오류가 발생했다.
svrmgrl>shutdown immediate
ora-01122 : DataBase File 4 failed Verification check
ora-0110 : datafile 4 : '/usr2/oradata/tools01.dbf'
ora-01208 : datafile is an old version - not accessing current version
원인 : DB가 OnLine 상황인데 tools01.dbf를 복사헤서 덮어씀
조치 : Archive Mode로 동작중이므로 Archive Loag 를 이용해서 복구함
svrmgrl>shutdown abort;
svrmgrl>recover datafile 'usr2/oradata/tools01.dbf'
...............
...............
![]() | ![]() ![]() | 12-27 | 1894 | |
![]() | ![]() ![]() | 12-11 | 1382 | |
53 | ![]() ![]() | 03-15 | 1126 | |
52 | ![]() ![]() | 01-31 | 1294 | |
51 | ![]() ![]() | 01-31 | 1084 | |
50 | ![]() ![]() | 01-31 | 986 | |
49 | ![]() ![]() | 01-19 | 1294 | |
48 | ![]() ![]() | 01-11 | 1137 | |
47 | ![]() ![]() | 01-03 | 1634 | |
46 | ![]() ![]() | 12-27 | 1894 | |
45 | ![]() ![]() | 12-19 | 1401 | |
44 | ![]() ![]() | 12-14 | 1378 | |
43 | ![]() ![]() | 12-11 | 1382 | |
42 | ![]() ![]() | 12-09 | 1112 | |
41 | ![]() ![]() | 12-01 | 1302 | |
40 | ![]() ![]() | 12-01 | 1485 | |
39 | ![]() ![]() | 12-01 | 984 |
댓글 없음:
댓글 쓰기