I am running the following command:
*.db_file_name_convert='/db1/ifddb1/dbf/','/db1/ifdtest1/dbf/'
*.log_file_name_convert='/redo/ifddb1/redologs/','/redo/ifdtest1/redologs/'
sqlplus ' / as sysdba ' <<EOT
shutdown abort
startup nomount
exit
EOT
rman catalog=rman/******@ifddb1 target=sys/*******ifddb1 << EOT
connect auxiliary sys/*******@ifdtest1
duplicate target database to ifdtest1 from active database nofilenamecheck
pfile=/u01/app/oracle/product/11g/dbs/initifdtest1.ora ;
exit
EOT
During the clone some of my .arc files are deleted and I get the following
error:
$ sqlplus '/as sysdba'
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 11665258641680 generated at 11/28/2010 01:05:38 needed for
thread 1
ORA-00289: suggestion : /archive/ifdtest4/ifdtest4_128788_1_629710136.arc
ORA-00280: change 11665258641680 for thread 1 is in sequence #128788
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
CANCEL
I know I have to start recovery with log 128788. So I recover the next "N" number of logs and apply them until "media recovery" is completed.
My question is there a way to tell the RANGE of .arc files I need so I can pull ALL those .arc files back at once instead of keep trying the command
"recover database using backup controlfile until cancel;" multiple times
'I also need this to work on a RAC setup too. Any detailed examples would be greatly appreciated.