Re: Duplicating DB with RMAN

From: Ronald Rood <devnull_at_ronr.nl>
Date: Fri, 30 Apr 2004 22:53:54 +0200
Message-ID: <0001HW.BCB88982005B7EC3F02845B0@news.individual.net>

On Fri, 30 Apr 2004 17:36:33 +0200, Forte Agent wrote (in message <ohs490h0b6k7flbh2lqdpunbn84qt45lnu_at_4ax.com>):

>>> OS is HP/UX 11.11 and DB is 9.2.0.4.

>> What exactly did you do ? To me it sounds like duplicating on an other
>> server
>> without copying the backupsets to the 2nd server. rman is not going to
>> read
>> the backupsets from an other server; the backup sets need to be on the
>> same
>> location and on the same server as where the new database has to be
>> created.

> Sorry, I should have said this before. The original database (target) > and the new auxiliary database are on the same server.

What I do miss is a backup of the archivelog files. I expect a different error but give it a try.
Here is a piece of one of my scripts that do succesfully run on macosx, solaris and tru64:
rman catalog rman/catalog_at_ab2 target system/manager_at_ab auxiliary / <<eof | run {

     allocate channel x type disk format='/Users/oracle/oraback/%d/%T_%U';
     # backup database include current controlfile for standby;
     # backup database include current controlfile ;
     # sql 'alter system archive log current'; # not needed
     backup archivelog all delete input;
     allocate auxiliary channel y type disk;
     # duplicate target database for standby dorecover;
     duplicate target database to $ORACLE_SID;

}

not much differences with your script but it does have archivelog backup in it and you do need it.

-- 
With kind regards,
Ronald
http://ronr.nl/unix-dba

Received on Fri Apr 30 2004 - 15:53:54 CDT