|
回帖奖励 +25
本帖最后由 xifenfei 于 2011-10-19 09:14 编辑
数据库可以重启,但是那个数据文件会一直在数据库中,并且是处于离线状态
SQL> alter tablespace odu add datafile '/opt/oracle/oradata/test/odu03.chf' size 10m autoextend on next 128k maxsize 100m;
Tablespace altered.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/opt/oracle/oradata/test/system01.dbf
/opt/oracle/oradata/test/undotbs01.dbf
/opt/oracle/oradata/test/sysaux01.dbf
/opt/oracle/oradata/test/users01.dbf
/opt/oracle/oradata/test/user32g.dbf
/opt/oracle/oradata/test/xifenfei01.dbf
/opt/oracle/oradata/test/user02.dbf
/opt/oracle/oradata/test/odu02.dbf
/opt/oracle/oradata/test/odu01.dbf
/opt/oracle/oradata/test/odu03.chf
10 rows selected.
SQL> create table chf.t_chf tablespace odu as select * from user_objects;
create table chf.t_chf tablespace odu as select * from user_objects
*
ERROR at line 1:
ORA-01116: error in opening database file 10
ORA-01110: data file 10: '/opt/oracle/oradata/test/odu03.chf'
ORA-27041: unable to open file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
[oracle@ECP-UC-DB1 test]$ ll
total 13508924
drwxr-xr-x 2 oracle oinstall 12288 Oct 18 22:01 archivelog
-rw-r----- 1 oracle oinstall 7553024 Oct 19 08:59 control01.ctl
-rw-r----- 1 oracle oinstall 7553024 Oct 19 08:59 control02.ctl
-rw-r----- 1 oracle oinstall 7553024 Oct 19 08:59 control03.ctl
-rw-r----- 1 oracle oinstall 104865792 Oct 18 22:06 odu01.dbf
-rw-r----- 1 oracle oinstall 11282685952 Oct 18 22:06 odu02.dbf
-rw-r----- 1 oracle oinstall 10493952 Oct 19 08:55 odu03.chf
-rw-r----- 1 oracle oinstall 52429312 Oct 18 22:01 redo01.log
-rw-r----- 1 oracle oinstall 52429312 Oct 19 08:59 redo02.log
-rw-r----- 1 oracle oinstall 52429312 Oct 17 22:08 redo03.log
-rw-r----- 1 oracle oinstall 3584 Oct 9 22:36 spfile.ora
-rw-r----- 1 oracle oinstall 377495552 Oct 19 08:19 sysaux01.dbf
-rw-r----- 1 oracle oinstall 524296192 Oct 19 08:59 system01.dbf
-rw-r----- 1 oracle oinstall 20979712 Oct 18 22:02 temp01.dbf
-rw-r----- 1 oracle oinstall 1289756672 Oct 19 08:59 undotbs01.dbf
-rw-r----- 1 oracle oinstall 10493952 Oct 18 22:06 user02.dbf
-rw-r----- 1 oracle oinstall 10493952 Oct 18 22:06 user32g.dbf
-rw-r----- 1 oracle oinstall 5251072 Oct 18 22:06 users01.dbf
-rw-r----- 1 oracle oinstall 20979712 Oct 18 22:06 xifenfei01.dbf
[oracle@ECP-UC-DB1 test]$ ll *.chf
-rw-r----- 1 oracle oinstall 10493952 Oct 19 08:55 odu03.chf
[oracle@ECP-UC-DB1 test]$ rm ./*.chf
SQL> alter database datafile '/opt/oracle/oradata/test/odu03.chf' offline drop;
Database altered.
SQL> create table chf.t_chf tablespace odu as select * from user_objects;
Table created.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 209715200 bytes
Fixed Size 2082784 bytes
Variable Size 130025504 bytes
Database Buffers 71303168 bytes
Redo Buffers 6303744 bytes
Database mounted.
Database opened.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/opt/oracle/oradata/test/system01.dbf
/opt/oracle/oradata/test/undotbs01.dbf
/opt/oracle/oradata/test/sysaux01.dbf
/opt/oracle/oradata/test/users01.dbf
/opt/oracle/oradata/test/user32g.dbf
/opt/oracle/oradata/test/xifenfei01.dbf
/opt/oracle/oradata/test/user02.dbf
/opt/oracle/oradata/test/odu02.dbf
/opt/oracle/oradata/test/odu01.dbf
/opt/oracle/oradata/test/odu03.chf
10 rows selected.
|
|