oracle 删除数据文件

来源：互联网发布：win7系统网络驱动下载编辑：程序博客网时间：2024/05/18 00:11
[oracle@node01 ~]$ [oracle@node01 ~]$ ps -ef | grep dbw |grep -v greporacle   16851     1  0 05:52 ?        00:00:00 ora_dbw0_serv[oracle@node01 ~]$ [oracle@node01 ~]$ [oracle@node01 ~]$ ps -ef | grep dbw |grep -v greporacle   16851     1  0 05:52 ?        00:00:00 ora_dbw0_serv[oracle@node01 ~]$ [oracle@node01 ~]$ ls -ltr /proc/16851/fdtotal 0lrwx------ 1 oracle dba 64 Aug 12 05:54 9 -> /oracle/product/11.2.0/db_1/dbs/hc_serv.datlr-x------ 1 oracle dba 64 Aug 12 05:54 8 -> /dev/zerolr-x------ 1 oracle dba 64 Aug 12 05:54 7 -> /proc/16851/fdlr-x------ 1 oracle dba 64 Aug 12 05:54 6 -> /oracle/product/11.2.0/db_1/rdbms/mesg/oraus.msblr-x------ 1 oracle dba 64 Aug 12 05:54 5 -> /dev/nulllr-x------ 1 oracle dba 64 Aug 12 05:54 4 -> /dev/nulllr-x------ 1 oracle dba 64 Aug 12 05:54 3 -> /dev/nulllrwx------ 1 oracle dba 64 Aug 12 05:54 262 -> /oradata/serv/temp01.dbflrwx------ 1 oracle dba 64 Aug 12 05:54 261 -> /oradata/serv/users01.dbflrwx------ 1 oracle dba 64 Aug 12 05:54 260 -> /oradata/serv/undotbs01.dbflrwx------ 1 oracle dba 64 Aug 12 05:54 259 -> /oradata/serv/sysaux01.dbflrwx------ 1 oracle dba 64 Aug 12 05:54 258 -> /oradata/serv/system01.dbflrwx------ 1 oracle dba 64 Aug 12 05:54 257 -> /oradata/serv/control02.ctllrwx------ 1 oracle dba 64 Aug 12 05:54 256 -> /oradata/serv/control01.ctll-wx------ 1 oracle dba 64 Aug 12 05:54 2 -> /dev/nulllr-x------ 1 oracle dba 64 Aug 12 05:54 11 -> /oracle/product/11.2.0/db_1/rdbms/mesg/oraus.msblrwx------ 1 oracle dba 64 Aug 12 05:54 10 -> /oracle/product/11.2.0/db_1/dbs/lkSERVl-wx------ 1 oracle dba 64 Aug 12 05:54 1 -> /dev/nulllr-x------ 1 oracle dba 64 Aug 12 05:54 0 -> /dev/null[oracle@node01 ~]$ SQL> create user test identified by test default tablespace users;用户已创建。SQL> grant dba to test;授权成功[oracle@node01 ~]$ rm -rf /oradata/serv/users01.dbf [oracle@node01 ~]$ ls -ltr /proc/16851/fdtotal 0lrwx------ 1 oracle dba 64 Aug 12 05:54 9 -> /oracle/product/11.2.0/db_1/dbs/hc_serv.datlr-x------ 1 oracle dba 64 Aug 12 05:54 8 -> /dev/zerolr-x------ 1 oracle dba 64 Aug 12 05:54 7 -> /proc/16851/fdlr-x------ 1 oracle dba 64 Aug 12 05:54 6 -> /oracle/product/11.2.0/db_1/rdbms/mesg/oraus.msblr-x------ 1 oracle dba 64 Aug 12 05:54 5 -> /dev/nulllr-x------ 1 oracle dba 64 Aug 12 05:54 4 -> /dev/nulllr-x------ 1 oracle dba 64 Aug 12 05:54 3 -> /dev/nulllrwx------ 1 oracle dba 64 Aug 12 05:54 262 -> /oradata/serv/temp01.dbflrwx------ 1 oracle dba 64 Aug 12 05:54 261 -> /oradata/serv/users01.dbf (deleted)lrwx------ 1 oracle dba 64 Aug 12 05:54 260 -> /oradata/serv/undotbs01.dbflrwx------ 1 oracle dba 64 Aug 12 05:54 259 -> /oradata/serv/sysaux01.dbflrwx------ 1 oracle dba 64 Aug 12 05:54 258 -> /oradata/serv/system01.dbflrwx------ 1 oracle dba 64 Aug 12 05:54 257 -> /oradata/serv/control02.ctllrwx------ 1 oracle dba 64 Aug 12 05:54 256 -> /oradata/serv/control01.ctll-wx------ 1 oracle dba 64 Aug 12 05:54 2 -> /dev/nulllr-x------ 1 oracle dba 64 Aug 12 05:54 11 -> /oracle/product/11.2.0/db_1/rdbms/mesg/oraus.msblrwx------ 1 oracle dba 64 Aug 12 05:54 10 -> /oracle/product/11.2.0/db_1/dbs/lkSERVl-wx------ 1 oracle dba 64 Aug 12 05:54 1 -> /dev/nulllr-x------ 1 oracle dba 64 Aug 12 05:54 0 -> /dev/null[oracle@node01 ~]$ SQL> create table t400(id int,name char(10)) tablespace users;create table t400(id int,name char(10)) tablespace users*第 1 行出现错误:ORA-01116: 打开数据库文件 4 时出错 ORA-01110:数据文件 4: '/oradata/serv/users01.dbf'ORA-27041: 无法打开文件Linux-x86_64 Error: 2: No such file or directoryAdditional information: 3[oracle@node01 ~]$ ls -ltr /proc/16851/fdtotal 0lrwx------ 1 oracle dba 64 Aug 12 05:54 9 -> /oracle/product/11.2.0/db_1/dbs/hc_serv.datlr-x------ 1 oracle dba 64 Aug 12 05:54 8 -> /dev/zerolr-x------ 1 oracle dba 64 Aug 12 05:54 7 -> /proc/16851/fdlr-x------ 1 oracle dba 64 Aug 12 05:54 6 -> /oracle/product/11.2.0/db_1/rdbms/mesg/oraus.msblr-x------ 1 oracle dba 64 Aug 12 05:54 5 -> /dev/nulllr-x------ 1 oracle dba 64 Aug 12 05:54 4 -> /dev/nulllr-x------ 1 oracle dba 64 Aug 12 05:54 3 -> /dev/nulllrwx------ 1 oracle dba 64 Aug 12 05:54 262 -> /oradata/serv/temp01.dbflrwx------ 1 oracle dba 64 Aug 12 05:54 261 -> /oradata/serv/users01.dbf (deleted)lrwx------ 1 oracle dba 64 Aug 12 05:54 260 -> /oradata/serv/undotbs01.dbflrwx------ 1 oracle dba 64 Aug 12 05:54 259 -> /oradata/serv/sysaux01.dbflrwx------ 1 oracle dba 64 Aug 12 05:54 258 -> /oradata/serv/system01.dbflrwx------ 1 oracle dba 64 Aug 12 05:54 257 -> /oradata/serv/control02.ctllrwx------ 1 oracle dba 64 Aug 12 05:54 256 -> /oradata/serv/control01.ctll-wx------ 1 oracle dba 64 Aug 12 05:54 2 -> /dev/nulllr-x------ 1 oracle dba 64 Aug 12 05:54 11 -> /oracle/product/11.2.0/db_1/rdbms/mesg/oraus.msblrwx------ 1 oracle dba 64 Aug 12 05:54 10 -> /oracle/product/11.2.0/db_1/dbs/lkSERVl-wx------ 1 oracle dba 64 Aug 12 05:54 1 -> /dev/nulllr-x------ 1 oracle dba 64 Aug 12 05:54 0 -> /dev/null[oracle@node01 ~]$ cp /proc/16851/fd/261 /oradata/serv/users01.dbf现在可以:SQL> create table t400(id int,name char(10)) tablespace users;create table t400(id int,name char(10)) tablespace users*第 1 行出现错误:ORA-01116: 打开数据库文件 4 时出错 ORA-01110:数据文件 4: '/oradata/serv/users01.dbf'ORA-27041: 无法打开文件Linux-x86_64 Error: 2: No such file or directoryAdditional information: 3SQL>  create table t400(id int,name char(10)) tablespace users;表已创建。
阅读全文
0 0