Version: 11gRel 2
Platform : AIX
We have been provided the RMAN cold backup of a DB and has been asked to recreate in a new server. After installing the binaries in the new server , this is what i am going to do
Step1. Create a pfile (i am creating it manually , because i don't know which backup piece has spfile and we don't have control file autobkp. I know the DB name)
Step2. Mount the DB using this pfile using RMAN
I have a question on step3 and Step4
Step3.
RMAN> RESTORE CONTROLFILE from 'rman_backup_piecename' to '/rsadat2/prod/config/my_newcontrolfile_name';
The above command for Step3 is a variant of a command i read at
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov004.htm#CFABADJC
Will this work?
Step4.
We want to restore datafiles to a different location other than the source . From oracle Doc, I found the below command to do that
SET NEWNAME FOR DATAFILE '/olddisk/users01.dbf' TO '/new_path/file.dbf';
All datafiles will go to one location in the Target DB
/rsadat1/prod/oradata/dbname/
But there were more than 400 files in the source DB which were located on 4 different Filesystems. So, in a TEXT editor, I can't don't a FIND and REPLACE for all the 400 lines, in one go .
Is there a single command by which I could let RMAN know of the new location to restore to?