恢復表空間到不同的ASM磁碟組

CREATE DISKGROUP DSKGRP2 EXTERNAL REDUNDANCY DISK
'/oracle/oradata/asmdisk03',
'/oracle/oradata/asmdisk07';

create tablespace testasm datafile '+DSKGRP2' size 100M autoextend off extent management local uniform size 1M segment space management auto;

RMAN> BACKUP FORMAT '/oracle/rman/bk_%s_%p_%t' tablespace testasm;

Starting backup at 22-APR-09
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00013 name=+DSKGRP2/orcl/datafile/testasm.256.684860201
channel ORA_DISK_1: starting piece 1 at 22-APR-09
channel ORA_DISK_1: finished piece 1 at 22-APR-09
piece handle=/oracle/rman/bk_57_1_684860441 tag=TAG20090422T150041 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
Finished backup at 22-APR-09

Starting Control File and SPFILE Autobackup at 22-APR-09
piece handle=/oracle/rman/ORCL/autobackup/2009_04_22/o1_mf_s_684860445_4yxj50kj_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 22-APR-09

SQL> alter database datafile '+DSKGRP2/orcl/datafile/testasm.256.684860201' offline;

ASMCMD> cd DSKGRP2/
ASMCMD> cd ORCL
ASMCMD> cd DATAFILE
ASMCMD> rm -rf TESTASM.256.684860201

RMAN> run {
set newname for datafile '+DSKGRP2/orcl/datafile/testasm.256.684860201' to '+DSKGRP1/orcl/datafile/testasm.256.684860201';
restore tablespace testasm;
switch datafile all;
recover tablespace testasm;
}

executing command: SET NEWNAME

Starting restore at 22-APR-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=144 instance=orcl1 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00013 to +DSKGRP1/orcl/datafile/testasm.256.684860201
channel ORA_DISK_1: reading from backup piece /oracle/rman/bk_57_1_684860441
channel ORA_DISK_1: restored backup piece 1
piece handle=/oracle/rman/bk_57_1_684860441 tag=TAG20090422T150041
channel ORA_DISK_1: restore complete, elapsed time: 00:00:26
Finished restore at 22-APR-09

RMAN> recover tablespace testasm;[@more@]