操作步骤: conn / as sysdba startup mount; alter database datafile 'c:\...xxx.dbf' offline drop; alter database open; alter tablespace xxx rename datafile 'c:\...xxx.dbf' to 'd:\...xxx.dbf'; alter database datafile 'd:\...xxx.dbf' online;OK!
出现两个错误: ORA-01157: cannot identify/lock data file 24 - see DBWR trace file; ORA-01110: data file 24 : '/oracle/u02/oradata/test04/.dbf'
最后解决方法: SVRMGR> connect internal SVRMGR> startup mount SVRMGR> alter database create datafile 'c:\test.ora'; SVRMGR> set autorecovery on SVRMGR> recover datafile 'c:\test.ora'; SVRMGR> alter database open;http://www.infosecurity.org.cn/article/dbsec/mix/23300.html
14:37:23 SQL> create tablespace tsp_u01 datafile 'C:\oracle\oradata\tsp_u01.dbf' size 10M
14:38:52 2 autoextend on next 5M maxsize unlimited;表空间已创建。已用时间: 00: 00: 01.31
14:40:16 SQL> select tablespace_name,status from dba_tablespaces;TABLESPACE_NAME STATUS
------------------------------ ---------
SYSTEM ONLINE
RBS ONLINE
USERS ONLINE
TEMP ONLINE
TOOLS ONLINE
INDX ONLINE
SFMIS ONLINE
ZBMIS ONLINE
HBMIS ONLINE
HBXNMIS ONLINE
OEM_REPOSITORY ONLINETABLESPACE_NAME STATUS
------------------------------ ---------
TSP_U01 ONLINE已选择12行。已用时间: 00: 00: 00.63
14:40:38 SQL> alter tablespace tsp_u01 offline;表空间已更改。已用时间: 00: 00: 00.38
14:41:05 SQL> select tablespace_name,status from dba_tablespaces where tablespace_name='TSP_U01';TABLESPACE_NAME STATUS
------------------------------ ---------
TSP_U01 OFFLINE已用时间: 00: 00: 00.16
14:41:26 SQL> alter tablespace tsp_u01 rename datafile 'C:\oracle\oradata\tsp_u01.dbf'
14:43:00 2 to 'C:\oracle\oradata\oral\tsp_u01.dbf';表空间已更改。已用时间: 00: 00: 00.63
14:43:32 SQL> alter tablespace tsp_u01 online;表空间已更改。已用时间: 00: 00: 00.81
14:43:45 SQL> select tablespace_name,status from dba_tablespaces where tablespace_name='TSP_U01';TABLESPACE_NAME STATUS
------------------------------ ---------
TSP_U01 ONLINE已用时间: 00: 00: 00.15
14:45:35 SQL> drop tablespace tsp_u01 including contents cascade constraints;表空间已丢弃。已用时间: 00: 00: 00.28
14:45:43 SQL>
2.startup mount;
3.alter database rename datafile 'xxxx' to 'yyyy';
4.alter database open;
conn / as sysdba
startup mount;
alter database datafile 'c:\...xxx.dbf' offline drop;
alter database open;
alter tablespace xxx rename datafile 'c:\...xxx.dbf' to 'd:\...xxx.dbf';
alter database datafile 'd:\...xxx.dbf' online;OK!
再用 ln -s /hdc1 /oracle/u02/oradata/test04
这样把现在的磁盘/hdc1指到原先目录下:/oracle/u02/oradata/test04
目录还是相同的.
ORA-01157: cannot identify/lock data file 24 - see DBWR trace file;
ORA-01110: data file 24 : '/oracle/u02/oradata/test04/.dbf'
SVRMGR> connect internal
SVRMGR> startup mount
SVRMGR> alter database create datafile 'c:\test.ora';
SVRMGR> set autorecovery on
SVRMGR> recover datafile 'c:\test.ora';
SVRMGR> alter database open;http://www.infosecurity.org.cn/article/dbsec/mix/23300.html