How about reading ML : 29430.1 If you were on 10gR2, you would have been more lucky. Jaffar On Mon, Jun 16, 2008 at 9:07 AM, Daniel Fink <daniel.fink@xxxxxxxxxxxxxx> wrote: > Oracle 10gr1 on AIX. > RMAN backups using Recovery catalog and CommVault > > Using a full backup, we are trying to refresh a database on another server > (something done quite frequently without problems). Unfortunately, the > backup we are trying to use has an issue. During the backup, two datafiles > were added to the source database. When we try to restore the backup, the > following error messages are reported and the restore terminates. > > RMAN-00571: =========================================================== > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== > RMAN-00571: =========================================================== > RMAN-03002: failure of Duplicate Db command at 06/14/2008 08:09:22 > RMAN-03015: error occurred in stored script Memory Script > RMAN-06026: some targets not found - aborting restore > RMAN-06023: no backup or copy of datafile 76 found to restore > RMAN-06023: no backup or copy of datafile 75 found to restore > > select FILE_NAME,RELATIVE_FNO from dba_data_files on PROD, the files are > there: > FILE_NAME RELATIVE_FNO > ----------------------------------------------------------- > --------------------------- > /db2/oradata/prod/d57.dbf 75 > /db2/oradata/prod/d58.dbf 76 > > The DB_FILE_CONVERT on REG is OK: > db_file_name_convert=("/db2/oradata/prod","/db5/oradata/REG") > log_file_name_convert=( > "/db3/oradata/prod","/db5/oradata/REG", > "/db2/oradata/prod","/db5/oradata/REG" > > Time in script MAY 17 2008 02:31:41 same as end time in CommVault. Verified > the STD291 & 292 are the correct media tape no.s > > From the Alert Log: > > Fri May 16 23:00:06 2008 > alter tablespace d add datafile '/db2/oradata/prod/d57.dbf' size 512M > autoextend on next 100M ma > xsize 10G > Fri May 16 23:00:08 2008 > Starting control autobackup > Control autobackup written to DISK device > handle '/db1/apps/oracle/admin/prod/udump/c-668007365-20080516-04' > Completed: alter tablespace d add datafile '/db2/oradata/qm > Fri May 16 23:00:43 2008 > alter tablespace d add datafile '/db2/oradata/prod/d58.dbf' size 512M > autoextend on next 100M ma > xsize 10G > > I've done a quick look at the doc, books and google and I am not finding a > way to exclude specific files from this type of recovery and/or issue a > command before starting the recovery to add the datafiles. > > Any help is greatly appreciated. > > Regards, > Daniel Fink > > -- > Daniel Fink > > Oracle Performance, Diagnosis, Data Recovery and Training > > OptimalDBA http://www.optimaldba.com > Oracle Blog http://optimaldba.blogspot.com > > Lost Data? http://www.ora600.nl/introduction.htm > > -- Best Regards, Syed Jaffar Hussain Oracle ACE 8i,9i & 10g OCP DBA RAC Certified Expert Official Oracle RAC SIG Representative for Saudi Arabian region ( http://www.oracleracsig.org/) http://jaffardba.blogspot.com/ http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:126 ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently."