Re: Duplicate Database with RMAN

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Fri, 30 Mar 2007 13:38:13 -0400
Message-ID: <bj5p039n7dfdgtnaa0bf48u56397b21k8k@4ax.com>

On 23 Mar 2007 14:17:12 -0700, "Jeff B" <jbisch1_at_yahoo.com> wrote:

>On Mar 16, 11:33 am, "Keith" <kkna..._at_gmail.com> wrote:
>> On Mar 16, 8:33 am, "EdStevens" <quetico_..._at_yahoo.com> wrote:
>>
>> > On Mar 15, 6:18 pm, "Jeff B" <jbis..._at_yahoo.com> wrote:
>>
>> > > This is probably too much to ask, but what have I got to lose. :) Can
>> > > someone possibly provide an RMAN script/process for duplicating a
>> > > database with RMAN? My source database would need to be a backup of a
>> > > production database one one server, and then I would like to move it
>> > > to a destination instance (testdb) on another server. The databases
>> > > do not have the same name, but they have the same structure.
>>
>> > > Thanks in advance,
>> > > Jeff
>>
>> > I don't have the references at hand, but there are also some docs on
>> > MetaLink that specifically address this exact question. Just search
>> > on 'duplicate database'.
>>
>> Same file system structure? How is the backup performed? To disk?
>> Storage manager?
>
>The file structure is the same. The OS (Windows 2003) for each server
>is the same. The original backup was performed using RMAN and saved
>to tape. The database is 9.2.0.7.

Hasn't worked on windows (should be the same), but on linux

0) make sure your directory structure is the same
1) new sid (different from host, not sure if necessary, but easier)
2) pwdfile on new host
3) make pfile copy to the new db
4) change dbname in pfile
5) start db nomount (no db creation is necessary)
6) rman, 

 connect catalog,
 target (original db),
 auxiliary (/)
run{
set until time "TO_DATE('30-mar-2007 08:00:00','dd-mon-yyyy hh24:mi:ss')";
allocate auxiliary channel aux1 type disk; duplicate target database to NEWSID nofilenamecheck; }

This works with IDENTICAL file system layouts, and DIFFERENT hosts

Have fun.
.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Fri Mar 30 2007 - 12:38:13 CDT