本文只是为了个人备忘。

参考eagyle的：http://www.eygle.com/archives/2005/12/oracle_howto_move_datafile_raw.html

我首先挂了一块硬盘。然后执行：fdisk /dev/sdd

生成了一块逻辑盘/dev/sdd1，得到扩展盘/dev/sdd5。

然后在 /etc/rc.local里设定： chown oracle:dba /dev/sdd5。

我想，采用这种方式，意味着跳过udev。

 

启动数据库，在裸设备下建立表空间：

****************************************

SQL>create tablespace gao datafile ‘/dev/sdd5’ size 10M;

SQL>Create table gaotab tablespace gao as select * from dba_objects;

SQL>select count(*) from gaotab;

SQL>Select tablespace_name from dba_tablespaces;

TABLESPACE_NAME

----------------------------------------------

SYSTEM

UNDOTBS1

SYSAUx

TEMP

USERS

GAO

 

SQL>alter tablespace gao offline;

Tablespace altered.

SQL>

****************************************

 

然后，进行转换：

****************************************

su – oracle

$rman target /

…

RMAN> copy datafile ‘/dev/sdd5’ to ‘/oracle/tbs/gaotbs.dbf’;

Starting backup at 13-APR-14

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=146 devtype=DISK

channel ORA_DISK_1: starting datafile copy

input datafile fno=00005 name=/dev/sdd5

output filename=/oracle/tbs/gaotbs.dbf tag=TAG20140413T204555 recid=1 stamp=844807557

channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03

Finished backup at 13-APR-14

RMAN>exit

****************************************

 

再回到数据库中，改表空间对应的文件名：

SQL>alter database rename file ‘/dev/sdd5’ to ‘/oracle/tbs/gaotbs.dfb’;

Database altered.

SQL>alter tablespace gao online;

Tablespace altered.

SQL>select file_name from dba_data_files where tablespace_name=’GAO’;

FILE_NAME

-------------------------------------------------

/oracle/tbs/gaotbs.dfb

SQL>

本文转自健哥的数据花园博客园博客，原文链接：http://www.cnblogs.com/gaojian/p/3663249.html，如需转载请自行联系原作者