RE: Clone Oracle 8i Database

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Fri, 15 Feb 2008 21:37:09 -0500
Message-ID: <BAY107-W3115452530B8828A14D5A0A1270@phx.gbl>

What about if same windows server where one oracle9i database is located being re iamged from windows 2000 to windows2003 os? Will those database files worked if copied over again on Windows 2003 by following the same procedure given by you?

Subject: RE: Clone Oracle 8i Database
Date: Thu, 14 Feb 2008 10:27:36 -0500
From: Thomas.Mercadante_at_labor.state.ny.us To: gheibia_at_gmail.com; oracle-l_at_freelists.org

Amir,  

As long as the physical files are still intact, you can simply copy them from one machine to the other.  

Create the same directory structure on the new machine.
Copy the files over.
Get the same release of Oracle installed on the new machine.
Copy the init.ora & password files
over.
Run oradim to create the service on the new machine.  

You should be able to bring the database up after that.

Tom

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Amir Gheibi
Sent: Thursday, February 14, 2008 3:12 AM To:
oracle-l_at_freelists.org
Subject: Clone Oracle 8i
Database

Hi,

I need to copy an Oracle database from one machine to another.
I am using Oracle 8i on windows. It's a very simple database. It's not even using archive mode or anything like that. The problem here is the
source windows is pretty much damaged and non of the oracle services are working.
Is there any way to save the database? Is there any practical paper on the Internet that I can take advantage of?

Thanks in
advance,
Amir

---

Shed those extra pounds with MSN and The Biggest Loser! http://biggestloser.msn.com/

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

Received on Fri Feb 15 2008 - 20:37:09 CST