Duplicating DB with RMAN

From: Forte Agent <1443131_at_usenetplanet.com>
Date: Fri, 30 Apr 2004 04:09:09 -0400
Message-ID: <qb2490h9v4hko2fvri62ro0c4kcvtk0h5k@4ax.com>

I am trying to duplicate a database using RMAN hot backup. I backed up the database:
connect catalog rman/????????@DB_CATALOG; connect target system/????????@DB_ORIGINAL; run
{
  allocate channel 'ch1' type disk format
'/backup/bkset.%s_%t_%p.dbf';

  allocate channel 'ch2' type disk format
'/backup/bkset.%s_%t_%p.dbf';

  backup
    maxsetsize 2g
    database
    include current controlfile;
}

Then I am trying to duplicate it (data file and log file name paths are net to new value by db_file_name_convert and log_file_name_convert init parameters):

export ORACLE_SID=DB_NEW
sqlplus /nolog
connect / as sysdba
Startup nomount
exit

rman
connect catalog rman/????????@DB_CATALOG; connect target system/????????@DB_ORIGINAL; connect auxiliary system/manager;

crosscheck backup;

run
{
  allocate channel 'ch1' type disk format
'/backup/bkset.%s_%t_%p.dbf';

  allocate channel 'ch2' type disk format
'/backup/bkset.%s_%t_%p.dbf';

  allocate channel 'ch3' type disk format
'/backup/bkset.%s_%t_%p.dbf';

  allocate auxiliary channel 'ach1' type disk;
  allocate auxiliary channel 'ach2' type disk;
  allocate auxiliary channel 'ach3' type disk;

  duplicate target database to DB_NEW;
}

Then RMAN generates following error:

RMAN-00571:

---

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS

---

RMAN-00571:

---

RMAN-03002: failure of Duplicate Db command at 04/29/2004 23:29:29
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 487
RMAN-06100: no channel to restore a backup or copy of datafile 486

. . . omitted . . .
RMAN-06100: no channel to restore a backup or copy of datafile 391 RMAN-06100: no channel to restore a backup or copy of datafile 390 MAN-06100: no channel to restore a backup or co RMAN> exit

What am I doing wrong? Thank you in advance. Received on Fri Apr 30 2004 - 03:09:09 CDT