ORA-00376, ORA-01110

SQL> select * from emp where empno = 7839;
select * from emp where empno = 7839
              *
ERROR at line 1:
ORA-00376: file 4 cannot be read at this time
ORA-01110: data file 4: '/u01/oradata/ORCL/users01.dbf'

 

Data file을 읽을 수 없다는 에러가 난다.

 

-- Data file 또는 Tablespace status 상태를 체크한다.

SQL> select status, name from v$datafile;

 

STATUS  NAME
------- ------------------------------
SYSTEM  /u01/oradata/ORCL/system01.dbf
ONLINE  /u01/oradata/ORCL/sysaux01.dbf
ONLINE  /u01/oradata/ORCL/undotbs01.dbf

OFFLINE /u01/oradata/ORCL/users01.dbf
ONLINE  /u01/oradata/ORCL/example01.dbf

 

 

 

SQL> select tablespace_name, status from dba_tablespaces;

TABLESPACE_NAME              STATUS
------------------------------     ---------
SYSTEM                             ONLINE
SYSAUX                             ONLINE
UNDOTBS1                         ONLINE
TEMP                                ONLINE
USERS                                OFFLINE
EXAMPLE                           ONLINE

 

 

-- USERS 테이블스페이스를 online으로 바꿔준다.

SQL> alter tablespace USERS online;

Tablespace altered.

SQL> select tablespace_name, status from dba_tablespaces;

 

 

TABLESPACE_NAME          STATUS
---------------------------------------
SYSTEM                         ONLINE
SYSAUX                         ONLINE
UNDOTBS1                     ONLINE
TEMP                            ONLINE
USERS                           ONLINE
EXAMPLE                       ONLINE