Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Duplicating DB with RMAN

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US