ORA-00376, ORA-01110

현상 : ORA-00376: file 29 cannot be read at this time
         ORA-01110: data file 29: '/db/GICORP_4/axix01.dbf'
 

원인 : datafile의 size가 os에서 허용하는 filesize를 초과해서 발생.
 

조치 : unix의 ulimit filesize를 확인해 보시기 바랍니다.
       그리고 datafile size 보다 크도록 수정해 주어야 합니다.
       1.unix ulimit filesize를 증가 시킨다
         C shell인 경우
            % limit filesize <number>
         Bourne 이나 Korn shell 인 경우
            $ ulimit -f <number>
       2.archivelog mode인지 확인합니다
         SVRMGR> select * from v$database;

         NAME      CREATED              LOG_MODE     CHECKPOINT ARCHIVE_CH
         --------- -------------------- ------------ ---------- ----------
         GICORP    05/17/00 13:44:56    ARCHIVELOG     36290290   36284249
         1 row selected.
       3.media recovery가 필요한 datafiles를 찾습니다
         SVRMGR> select * from v$recover_file;

         FILE#      onLINE  ERROR              CHANGE#    TIME
         ---------- ------- ------------------ ---------- --------------------
                  9 OFFLINE                      36287415 12/20/00 23:30:55
                 23 OFFLINE                      36289350 12/21/00 08:40:54
                 28 OFFLINE                      36287415 12/20/00 23:30:55
                 29 OFFLINE                      36287415 12/20/00 23:30:55
                 37 OFFLINE                      36287415 12/20/00 23:30:55
         5 rows selected.
       4.각각의 datafile에 대해서 다음을 실행해 줍니다
         SVRMGR> recover datafile '/db/GICORP_4/axix01.dbf';

         Media recovery complete.

         SVRMGR> alter database datafile '/db/GICORP_4/axix01.dbf' onLINE;
         Statement processed.

       5.database를 restart합니다

         SVRMGR>  shutdown
         Database closed.
         Database dismounted.
         ORACLE instance shut down.
         SVRMGR> startup
         ORACLE instance started.
         Total System Global Area                         54578916 bytes
         Fixed Size                                          69348 bytes
         Variable Size                                    20783104 bytes
         Database Buffers                                 33554432 bytes
         Redo Buffers                                       172032 bytes
         Database mounted.
         Database opened.
         SVRMGR>