如何迁移Tools表空间？

显示全部楼层 · 2005-10-30 17:05:33

如何迁移Tools表空间？
想把tools表空间由文件系统上迁移到一个raw设备上如何做安全？

千问 · 2005-10-30 17:05:33

SQL>select file_name,TABLESPACE_NAMEfrom dba_data_files where tablespace_name='TT';
FILE_NAME
TABLESPACE_NAME
/dev/rdsk/c0t1d0s5TT
SQL> select username,default_tablespace from dba_users where username='TT';
USERNAME
DEFAULT_TABLESPACE
------------------------------ ------------------------------
TT
TT
SQL> select FILE_NAME,BLOCKS from dba_data_files where TABLESPACE_NAME='TT';
FILE_NAME
BLOCKS
/dev/rdsk/c0t1d0s5
1280
/oracle/oradata/ora/
dd if=/dev/rdsk/c0t1d0s5 of=/oracle/oradata/ora/tt.dbfbs=8192 iseek=0count=1300
SQL> alter database rename file '/dev/rdsk/c0t1d0s5' to '/oracle/oradata/ora/tt.dbf';
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/oracle/oradata/ora/system01.dbf
/oracle/oradata/ora/undotbs01.dbf
/oracle/oradata/ora/sysaux01.dbf
/oracle/oradata/ora/users01.dbf
/dev/rdsk/c0t1d0s5
/oracle/oradata/ora/expdb.dbf
6 rows selected.
SQL> alter database rename file '/dev/rdsk/c0t1d0s5' to '/oracle/oradata/ora/tt.dbf';
Database altered.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/oracle/oradata/ora/system01.dbf
/oracle/oradata/ora/undotbs01.dbf
/oracle/oradata/ora/sysaux01.dbf
/oracle/oradata/ora/users01.dbf
/oracle/oradata/ora/tt.dbf
/oracle/oradata/ora/expdb.dbf
6 rows selected.
SQL> alter database open;
Database altered.
反之亦然
ddif=/oracle/oradata/ora/tt.dbf of=/dev/rdsk/c0t1d0s5 bs=8192 iseek=0count=1300
SQL> alter database rename file'/oracle/oradata/ora/tt.dbf' to '/dev/rdsk/c0t1d0s5' ;
SQL> alter database open;
Database altered.

千问 · 2005-10-30 17:05:33

因为raw device 的前面的几个字节是需要存储别的东西的,所以要dd的block应该比它的大一些的
,理论上说是大1--2 个block 的,不同的操作系统这个数值是不同的,太小会造成文件的不一致的,所以取的稍微大一些的

千问 · 2005-10-30 17:05:33

可以用rman做备份和恢复,重定向恢复到RAW上

千问 · 2005-10-30 17:05:33

楼上的，太复杂了吧！用得着用rman吗？！
可以使用exp/imp来实现。