asked on

Moving databases to the same server

My environment has customers with identical Oracle databases, each on a customer managed server.

I want to offer to rehost the databases on my equipment at a central location, putting multiple databases on a single server.

What's the most effective way to move database X from 3 (or more) different servers to all live peacefully on the same server as databases X1, X2, X3, etc?

Kent

ASKER CERTIFIED SOLUTION

MikeOM_DBA

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Praveen Kumar Chandrashekatr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Mark Geerlings

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Kent Olsen

ASKER

Guess I better wrap this up.

1) Separate oracle homes per client

All of the instances are 10g. It's the latest certification form the vendor and can't be changed. A single ORACLE_HOME is fine.

2) Separate listeners per client

I may well do this. There are also other mechanisms in place for ensuring that a client location can get to a specific instance. (I'm assuming that you meant instance, not client.)

3) Separate disk(s) per client

All of the server storage is on 1 really big SAN (100TB). Separate disks isn't an option. All of my servers are virtual servers on the same VM.

4) Obviously different Oracle Sid's

:)

RMAN copy over the internet isn't my first choice. Some of the remote network connections aren't very reliable and I've never toyed with what happens when an RMAN connection is interrupted.

Downtime isn't an issue. I've been taking file system level backups, moving them to the destination server, changing the SID, and rebuilding the control files.

Oracle 12 isn't an option. Vendor rules.