This content has been marked as final. Show 6 replies
Munish wrote:V8.1.7 was obsoleted & unsupported BEFORE Windows 2003 was RELEASED!
We have 8.1.7 standard edition database running on windows 2003 R2. (box1)
We are going to move to another windows box running same OS 2003 R2. (box2)SHUTDOWN IMMEDIATE
I already created a database on box 2. Everthing is same (eg. all the drive letters except size).
Now, I know I can do export/import to import the data into the box2 database, but the data to be imported is like 50+ Gigs. I think that would take me 2 + days with all the indexes (over 150).
Is there a better and faster way to do so? Can someone guide me/direct me/point to a guide that can help me.
then do OS file copies from old system to new system & then simply do
Munish wrote:You need to copy all the files that are OPEN while Oracle RDBMS is online & available;
Thanks, but when you say copy OS files.
What exactly am I copying?.
I forgot to mention one thing. The name of the box2 is different than box1. Will that matter once I copy over all OS files?
All tablespaces I guess, even control files? what else?
including REDO files.
We have 8.1.7 standard edition database running on windows 2003 R2. (box1)As previously posted, the fastest way in your case is "copying" (cloning) the Database from "box1" to "box2".
We are going to move to another windows box running same OS 2003 R2. (box2)
You'll find below a tip about this kind of operation on Windows Server:
On the other hand, you should think about Upgrading to Oracle *11.2* as Oracle *8.1.7* is not supported at all:
You'll find here some materials for a successfull Upgrade:
Hope this help.