RE: Easy way to copy databases when using RMAN?
- From: "MacGregor, Ian A." <ian@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 6 May 2004 06:52:47 -0700
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@xxxxxxxxxxxxxxxxx
-----Original Message-----
From: Mladen Gogala [mailto:mgogala@xxxxxxxxxxxx]
Sent: Wednesday, May 05, 2004 9:47 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx put 'unsubscribe'
in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
