RE: Easy way to copy databases when using RMAN?

From: Wolfson Larry - lwolfs <lawrence.wolfson_at_acxiom.com>
Date: Thu, 6 May 2004 01:03:39 -0500
Message-ID: <A366E86AF2FBD611AB920002B31E58B0096DC810@conmsx07.corp.acxiom.net>

Thanks for info Ken.

Any idea on my original RMAN clones?

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ken Naim Sent: Thursday, May 06, 2004 12:41 AM
To: 'oracle-l_at_freelists.org'
Subject: RE: Easy way to copy databases when using RMAN?

The Oracle 8i install on Solaris does hard code some of the os path's into some of the binaries (particularly java related ones) and the database will work fine assuming everything is soft linked properly until you need to apply a patch or upgrade the system. T universal installer had issues even though the orainventory was identical to the other server. I had to install the software and only then I could apply patches. I haven't tried this with 9i but IMHO I'd avoid it. I hear 10g will allow cloning of an installation onto the grid.

Ken Naim

-----Original Message-----

From: Wolfson Larry - lwolfs [mailto:lawrence.wolfson_at_acxiom.com] Sent: Thursday, May 06, 2004 1:21 AM
To: 'oracle-l_at_freelists.org'
Subject: Re: Easy way to copy databases when using RMAN?

I don't need RMAN, client is insisting on it.

I thought the "RESETLOGS" just reset the redo counter.

I'd swear we did that with another database and RMAN got all confused about what DBID the archives belonged to.

And now that you mentioned it Mladen, can I take my 9i install, tar it up and copy it to another server? Apply some soft links and do a relink all instead of multiple installs?

This particular client has all SUN servers.

	Thanks
	Larry

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mladen Gogala Sent: Wednesday, May 05, 2004 11:47 PM
To: oracle-l_at_freelists.org
Subject: [SPAM] 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

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited.
If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You.

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


-----------------------------------------------------------------

----------------------------------------------------------------

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

Received on Thu May 06 2004 - 01:02:33 CDT