| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Consolidating Servers
RE: Consolidating ServersDavid,
Can you create the clone from a production backup as a standby database? Then when it's time to switch over, just apply the last few archive logs from production, turn the clone on, and test. This way you can do most of the cloning at your convenience. We did this when we were moving database storage from the east coast to the west.
Henry
-----Original Message-----
From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf Of
David Wagoner
Sent: Wednesday, August 06, 2003 3:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Consolidating Servers
This is exactly what I am working on right now! We have to consolidate down from about 5 servers to 2 (Prod. and Test/Dev.). My approach is to just move (clone) the DBs first. That's a job in itself, considering that the production DBs need to be moved during weekend hours. Leave original DB on original server just in case something fails. Take a cold backup, move files to new server, rebuild control file from trace to create clone. Point apps at clone and test. If all is well, archive original DB to tape for a month or two to be safe.
By the way, this required me to install 4 versions of Oracle (8.1.7 to 9.2.0.3) in 4 Oracle Homes on the new Production server. Upgrading all to 9iR2 is another project.
Best regards,
David B. Wagoner
Database Administrator
Arsenal Digital Solutions
-----Original Message-----
From: Eberhard, Jeff [mailto:Jeff.Eberhard_at_Rolls-RoyceGS.com]
Sent: Wednesday, August 06, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Subject: Consolidating Servers
Just got out of a meeting with my manager. He had just finished meeting
with our Oracle rep and has finally figured out that we don't have enough
licenses (I've always asked him what we have and he's never shared it with
me,
always just "I've gotten it taken care of"). We have 80 and with our
current/potential configuration we are going to need 300.
Anyways, to save money he decides that we need to take our databases and
consolidate them to two or three servers (from 7). Most of the database
are
fairly
small (100-300Meg) so shouldn't be too bad. Actually it should be pretty
fun
(if I didn't already have 5 full-time jobs to do).
Anyone had to do the same thing? What are some concerns? Should I shoot
for
the moon and upgrade them all to 9i at the same time or have several
versions
(7.3, 8.0, 8.1.7) on the same server? Any comments would be greatly
appreciated.
Thanks,
Jeff
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Eberhard, Jeff
INET: Jeff.Eberhard_at_Rolls-RoyceGS.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: hporas_at_etal.uri.edu Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Aug 06 2003 - 15:04:23 CDT
 |
 |