Re: Very new to Oracle

Steve

You can't move a database from one OS to another this way because the OS's are binary incompatible and thus can't read the datafiles. Export / import is the easiest approach to move from one OS to another.

HTH. Pete

Steve Pax wrote:

> You can do it with any kind of backup - otherwise backups are worthless -
> but a cold backup is easiest.
> It amounts to an exercise in recovery.
> If the old machine were destroyed, you would have to do exactly the same
> thing to recover.
>
> I did it once on NT, but I can only give you high level instructions.
> 1 - I made a cold backup.
> 2 - I made a database on the new machine - I probably had to make the
> control file have the same name, and I probably used the same initialization
> file. One thing that does on NT is create the necessary system services - I
> don't know what would be equivalent on UNIX.
> 3 - I simulated a disaster by deleting all the files for the new database.
> 4 - I recovered using the backup.
> 5 - During recovery I changed the names and locations of all the tablespaces
> using (i think) the alter database command. That required mounting the
> database and making the changes before opening it. It was 8.0.4 and i got
> all the necessary information
> from the oracle * DBA handbook and the online docs.
>
> I would have to read the manual some to do it again, but fortunately it is a
> forgiving process because you can start over after
> a mistake.
>
> I've been wondering if you can move a database from one operating system to
> another this way.
>
> Hope that helps,
> Steve
>
> <pfhncp0_at_my-deja.com> wrote in message news:848lv3$nrk$1_at_nnrp1.deja.com...
> > I'm fairly new to oracle and I need to learn how to move a database
> > from one unix machine (HP-UX) to another unix machine (HP-UX). Where do
> > I start on looking for information on how to do this? Is it an easy
> > task or a difficult one? Thanks in advance.
> >
> > Neil
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.

Received on Tue Dec 28 1999 - 17:18:46 CST