Oracle基础知识:ORA-01187&ORA-01110
Oracle基础知识:ORA-01187&ORA-01110
问题:
ORA-01187: cannot read from file because it failed verification tests
ORA-01110: data file 201: '/u01/oradata/md/temp01.dbf'
问题重现:
[sql]
- sys@DENVER> alter database backup controlfile to trace as '/tmp/t1.sql';
- alter database backup controlfile to trace as '/tmp/t1.sql'
- *
- ERROR at line 1:
- ORA-01187: cannot read from file because it failed verification tests
- ORA-01110: data file 201: '/u01/oradata/md/temp01.dbf'
[sql]
- sys@DENVER> select file_name, status from dba_temp_files;
- select file_name, status from dba_temp_files
- *
- ERROR at line 1:
- ORA-01187: cannot read from file because it failed verification tests
- ORA-01110: data file 201: '/u01/oradata/md/temp01.dbf'
- sys@DENVER> select file#, ts#, name, status from v$tempfile;
- FILE# TS# NAME STATUS
- ---------- ---------- ---------------------------------------- -------
- 1 3 /u01/oradata/md/temp01.dbf ONLINE
1. 册除临时表
2. 再重建数据文件
[sql]
- ys@DENVER> alter database tempfile '/u01/oradata/md/temp01.dbf' drop;
- Database altered.
- sys@DENVER> select file#, ts#, name, status from v$tempfile;
- no rows selected
- sys@DENVER> alter tablespace temp add tempfile '/u01/oradata/md/temp01.dbf' size 512m reuse;
- Tablespace altered.
- sys@DENVER> select file_name, status from dba_temp_files;
- FILE_NAME STATUS
- ---------------------------------------- -------
- /u01/oradata/md/temp01.dbf ONLINE
评论暂时关闭