--添加测试表空间 SQL>
create
tablespace xff datafile '/u01/oradata/xifenfei.dbf'
size
10m autoextend on
maxsize 100m; Tablespace
created. --查看数据文件位置 SQL>
select
name
from
v$datafile; NAME -------------------------------------------------------------------------------- +DATA/tasm/system01.dbf +DATA/tasm/undotbs01.dbf +DATA/tasm/sysaux01.dbf +DATA/tasm/users01.dbf +DATA/tasm/example01.dbf /u01/oradata/xifenfei.dbf 6
rows
selected. --创建测试表 SQL>
create
table
hr.a tablespace xff 2
as 3
select
* from
dba_tables; Table
created. SQL>
select
count (*)
from
hr.a; COUNT (*) ---------- 1580 --转移数据文件位置 [oracle@localhost
oradata]$ rman target / Recovery
Manager: Release 10.2.0.3.0 - Production on
Mon Jun 27 04:30:22 2011 Copyright
(c) 1982, 2005, Oracle. All
rights reserved. connected
to
target database :
TASM (DBID=3032096031) RMAN>
sql 'alter
tablespace xff offline' ; using
target database
control file instead
of
recovery catalog sql
statement: alter
tablespace xff offline RMAN>
backup as
copy tablespace xff format '+DATA' ; Starting
backup at
27-JUN-11 allocated
channel: ORA_DISK_1 channel
ORA_DISK_1: sid=132 devtype=DISK channel
ORA_DISK_1: starting datafile copy input
datafile fno=00006 name =/u01/oradata/xifenfei.dbf output
filename=+DATA/tasm/datafile/xff.269.754893121 tag=TAG20110627T043200 recid=2 stamp=754893123 channel
ORA_DISK_1: datafile copy complete, elapsed time :
00:00:03 Finished
backup at
27-JUN-11 RMAN>
switch tablespace xff to
copy; datafile
6 switched to
datafile copy "+DATA/tasm/datafile/xff.269.754893121" RMAN>
sql 'alter
tablespace xff online' ; sql
statement: alter
tablespace xff online --查看转移后的数据文件位置 SQL>
select
name
from
v$datafile; NAME -------------------------------------------------------------------------------- +DATA/tasm/system01.dbf +DATA/tasm/undotbs01.dbf +DATA/tasm/sysaux01.dbf +DATA/tasm/users01.dbf +DATA/tasm/example01.dbf +DATA/tasm/datafile/xff.269.754893121 6
rows
selected. --测试其中数据是否存在 SQL>
select
count (*)
from
hr.a; COUNT (*) ---------- 1580 --创建asm中文件别名 ASMCMD>
mkalias +DATA/tasm/datafile/xff.269.754893121 +DATA/tasm/xff01.dbf --文件重命名 SQL>
alter
tablespace xff offline; Tablespace
altered. SQL>
alter
database
rename file '+DATA/tasm/datafile/xff.269.754893121'
to
'+DATA/tasm/xff01.dbf' ; Database
altered. SQL>
alter
tablespace xff online; Tablespace
altered. SQL>
select
name
from
v$datafile; NAME -------------------------------------------------------------------------------- +DATA/tasm/system01.dbf +DATA/tasm/undotbs01.dbf +DATA/tasm/sysaux01.dbf +DATA/tasm/users01.dbf +DATA/tasm/example01.dbf +DATA/tasm/xff01.dbf 6
rows
selected. --手工删除原来数据 [oracle@localhost
oradata]$ rm xifenfei.dbf |
asm数据文件迁移(os–>asm)
最新推荐文章于 2024-12-06 10:59:37 发布