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
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