Cloning gurus.

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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Kline.Michael
Sent: Thursday, September 23, 2004 4:16 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxx> michael.kline@xxxxxxxxxxxx 
************************************************ 
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

Other related posts: