Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Duplicate Database with RMAN
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,
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
![]() |
![]() |