Moving a Datafile from one Diskgroup to another
SQL> select tablespace_name, file_name, file_id file# from dba_data_files where tablespace_name = 'MYTSP';
TABLESPACE_NAME FILE_NAME FILE#
-------------------- - -------------------------------------------- ---- -----
MYTSP +DATA/mydb/datafile/myfile.379.716245261 22
SQL> SELECT name FROM v$asm_diskgroup;
NAME
-----------------------------
REC
DATA
SQL> alter database datafile '+DATA/mydb/datafile/myfile.379.716245261' offline;
Database altered.
rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Tue May 13 10:01:27 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: MYDB (DBID=403243456)
RMAN> copy datafile '+DATA/mydb/datafile/myfile.379.716245261' to '+REC';
Starting backup at 13-MAY-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=165 instance=MYDB devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00022 name=+DATA/mydb/datafile/myfile.379.716245261
output filename=+REC/mydb/datafile/myfile.2005.716245261 tag=TAG20080513T120010 recid=364 stamp=716223223
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 13-MAY-08
RMAN> exit;
sqlplus / as sysdba
SQL> ALTER DATABASE RENAME FILE '+DATA/mydb/datafile/myfile.379.716245261' TO '+REC/mydb/datafile/myfile.2005.716245261';
Database altered.
SQL> exit
or
rman target /
RMAN> switch datafile '+REC/mydb/datafile/myfile.2005.716245261' to copy;
Recovery Manager: Release 10.2.0.4.0 - Production on Tue May13 10:08:27 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: MYDB (DBID=403243456)
using target database control file instead of recovery catalog
datafile 22 switched to datafile copy "+REC/mydb/datafile/myfile.2005.716245261'"
RMAN> recover datafile '+REC/mydb/datafile/myfile.2005.716245261';
Starting recover at 13-MAY-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=161 instance=MYDB devtype=DISK
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 13-MAY-10
RMAN> exit
SQL> alter database datafile '+REC/mydb/datafile/myfile.2005.716245261' online;
Database altered.
SQL> select tablespace_name, file_name, file_id file# from dba_data_files where tablespace_name = 'MYTSP';
TABLESPACE_NAME FILE_NAME FILE#
-------------------- - - ---------------------------------------- ------- ----------- -----
MYTSP +REC/mydb/datafile/myfile.2005.716245261 22
TABLESPACE_NAME FILE_NAME FILE#
-------------------- - -------------------------------------------- ---- -----
MYTSP +DATA/mydb/datafile/myfile.379.716245261 22
SQL> SELECT name FROM v$asm_diskgroup;
NAME
-----------------------------
REC
DATA
SQL> alter database datafile '+DATA/mydb/datafile/myfile.379.716245261' offline;
Database altered.
rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Tue May 13 10:01:27 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: MYDB (DBID=403243456)
RMAN> copy datafile '+DATA/mydb/datafile/myfile.379.716245261' to '+REC';
Starting backup at 13-MAY-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=165 instance=MYDB devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00022 name=+DATA/mydb/datafile/myfile.379.716245261
output filename=+REC/mydb/datafile/myfile.2005.716245261 tag=TAG20080513T120010 recid=364 stamp=716223223
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 13-MAY-08
RMAN> exit;
sqlplus / as sysdba
SQL> ALTER DATABASE RENAME FILE '+DATA/mydb/datafile/myfile.379.716245261' TO '+REC/mydb/datafile/myfile.2005.716245261';
Database altered.
SQL> exit
or
rman target /
RMAN> switch datafile '+REC/mydb/datafile/myfile.2005.716245261' to copy;
Recovery Manager: Release 10.2.0.4.0 - Production on Tue May13 10:08:27 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: MYDB (DBID=403243456)
using target database control file instead of recovery catalog
datafile 22 switched to datafile copy "+REC/mydb/datafile/myfile.2005.716245261'"
RMAN> recover datafile '+REC/mydb/datafile/myfile.2005.716245261';
Starting recover at 13-MAY-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=161 instance=MYDB devtype=DISK
starting media recovery
media recovery complete, elapsed time: 00:00:00
Finished recover at 13-MAY-10
RMAN> exit
SQL> alter database datafile '+REC/mydb/datafile/myfile.2005.716245261' online;
Database altered.
SQL> select tablespace_name, file_name, file_id file# from dba_data_files where tablespace_name = 'MYTSP';
TABLESPACE_NAME FILE_NAME FILE#
-------------------- - - ---------------------------------------- ------- ----------- -----
MYTSP +REC/mydb/datafile/myfile.2005.716245261 22