RE: Easy way to copy databases when using RMAN?

Are you sure about the DBID being changed? I took a database which was registered with RMAN and did a hot backup the old fashion way. I then restored the hot backup files to another computer and also the required redo logs, ran a create control file command on the "new" machine based upon "backup control file to trace" on the old one which placed the "new" database in recovery mode and also renamed it. I applied to redo logs to the "clone" until it was at the time I wanted. I then opened it with reset logs.

When I tried to register the new database with Rman, I found it had the same DBID as the old.

Ian MacGregor
Stanfod Linear Accelerator Center
ian_at_slac.stanford.edu

-----Original Message-----
From: Mladen Gogala [mailto:mgogala_at_adelphia.net] Sent: Wednesday, May 05, 2004 9:47 PM
To: oracle-l_at_freelists.org
Subject: Re: Easy way to copy databases when using RMAN?

Actually, why do you need rman? If you use the the cloning tool known as "cp" or "scp", if the clone needs to be on another node, you can get the desired result with a FS-based database. The DBID problem is solved by opening the database with the "RESETLOGS" option. Once you issue "alter database open resetlogs" command, your old DBID is gone and, technically speaking, you have a new database.

On 05/06/2004 12:37:28 AM, Wolfson Larry - lwolfs wrote:
> Hi, guys!
> I I've got a number of servers to create multiple 9i databases.
>
> Is it possible to just create one system tablespace and just
> copy it multiple times?

--
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------