Oracle Database Discussions

Hi

I was doing a full db online backup for cloning purposes. during this process I had to add two additional files (118,119).

In the "duplicate" I have setup time to recover db to before files were added. Also I checked what backups would be taking place in the duplication process:

restore database preview until time "to_date('Mar 03 2010 12:13:00','Mon DD YYYY hh24:mi:ss')";

It showed me that only backpieces taken in the last backup will be used. No additional archivelogs created after the files were added.

Now, I try to duplicate that db:


run {
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(NB_ORA_POLICY=****l,NB_ORA_CLIENT=****)';
CONFIGURE DEVICE TYPE sbt_tape PARALLELISM 6;
set until time "to_date('Mar 03 2010 12:13:00','Mon DD YYYY hh24:mi:ss')";
duplicate target database to gmdwhpt2;
}


First thing which is worrying is the memory scrip tries to rename files which I want to exclude:

set newname for datafile 118 to
*"+dgrp_raid5_01_0000";*
set newname for datafile 119 to
*"+dgrp_raid5_01_0000";*

Next error is thrown:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/12/2010 05:21:37
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 119 found to restore
RMAN-06023: no backup or copy of datafile 118 found to restore



I believe this is due the fact that both files reside in control file. Is there any way to overcome this and duplicate my db?

Edited by: Radek on Mar 12, 2010 5:17 AM

Edited by: Radek on Mar 12, 2010 5:17 AM

Edited by: Radek on Mar 12, 2010 5:18 AM