Cloning gurus.

From: Spears, Brian <BSpears_at_Limitedbrands.com>
Date: Thu, 23 Sep 2004 16:34:56 -0400
Message-ID: <7B51890723365F4591B1B2319985D01218310B@EXCHSERV2.Limited.brands.com>

Hi,

I have been cloning DB for a long time but am under a crunch to rip out some developemnt stuff that has 9i OMF (oracle managed files).

Can anybody tell if they are any issues with cloning a 9i OMF database from a standard hotbackup?
I had some dba's bring up the objection that the DB name is linked to the datafile names.

Brian
-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kline.Michael
Sent: Thursday, September 23, 2004 4:16 PM To: oracle-l_at_freelists.org
Subject: Migrating 8i to 9i

If one migrates in place, and it's what one may call a "plain production database", no "fancy" stuff, etc. from 8.1.7.4 to 9.2.x (as it may be another month or two), are any options lost?

These are 1-2 TB and we may be moving to another server and a SAN/fiber back plane environment.

This may be a point where we could temporarily get new disks or simply move the disks from the one server to the other and then convert to 9i.

I could do a lot more "neat stuff" if I could do export/import but at the size, I don't know if we would have the time. For instance, instead of 12-18 "disks" I may have 2-4 600GB "disks" as it were, etc.

They are supposed to have a huge Hitachi SAN that auto balances the load and if it sees the load is on one tray and it's too heavy will eventually migrate some of the data to another tray without the knowledge of the Unix box. I don't get that heavy into the "guts" of them so not exactly sure how this happens.

But other than that, if I don't export/import, do I "lose" any features. Tablespaces are almost all LOCAL and UNIFORM extents, usually 10 or 100 meg.

Michael Kline
Database Administration
SunTrust Technology Center
1030 Wilmer Avenue
Richmond, Virginia 23227
Outside 804.261.9446
STNet 643.9446

Cell 804.744.1545
<mailto:michael.kline_at_suntrust.com> michael.kline_at_suntrust.com

The information transmitted is intended solely for the individual or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you have received this email in error please contact the sender and delete the material from any computer.

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 23 2004 - 15:37:38 CDT