Restaurar um datafile para outro local

RMAN> RUN {


2> SET NEWNAME FOR DATAFILE '/u02/oracle/banco/logix/dados07.dbf' TO '/u03/oracle/banco/logix/dados07.dbf';

SET NEWNAME FOR DATAFILE '/u02/oracle/banco/logix/tbsindxl01.dbf' TO '/u03/oracle/banco/logix/tbsindxl01.dbf';

restore DATAFILE 32;

restore DATAFILE 35;

SWITCH DATAFILE ALL;

}

3> 4> 5> 6> 7>

executing command: SET NEWNAME

using target database controlfile instead of recovery catalog



executing command: SET NEWNAME



Starting restore at 04-FEB-10



allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=14 devtype=DISK

channel ORA_DISK_1: starting datafile backupset restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00032 to /u03/oracle/banco/logix/dados07.dbf

channel ORA_DISK_1: restored backup piece 1

piece handle=/u03/backup/bkp_LOGIX_15973_1_20100203.bkp tag=FULLBACKUP params=NULL

channel ORA_DISK_1: restore complete

Finished restore at 04-FEB-10



Starting restore at 04-FEB-10



using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

restoring datafile 00035 to /u03/oracle/banco/logix/tbsindxl01.dbf

channel ORA_DISK_1: restored backup piece 1

piece handle=/u03/backup/bkp_LOGIX_15976_1_20100203.bkp tag=FULLBACKUP params=NULL

channel ORA_DISK_1: restore complete

Finished restore at 04-FEB-10



datafile 32 switched to datafile copy

input datafilecopy recid=4668 stamp=710093659 filename=/u03/oracle/banco/logix/dados07.dbf

datafile 35 switched to datafile copy

input datafilecopy recid=4669 stamp=710093659 filename=/u03/oracle/banco/logix/tbsindxl01.dbf



RMAN>