copy a Database from Solaris to HP-UX

I have to copy a Database from Solaris to HP-UX. The versions of Oracle and
the Database names will be the same. I have one major hitch and question.
The hitch - export/import is not an option. I can get a cold backup
for laying the Database down on the HP-UX box, but from then on, I will need
to roll forward using logs until the decision is made to cut over
between the two boxes. My question:
Will there be any OS compatibilty issues for the control, data and log
files? Meaning, will Oracle on HP-UX be able to read and write to
control, data and log files created by Oracle on the Soalris box?

Thanks in advance.

"Joe" wrote in message
news:63bb2d27.0311051615.21c9a8e1-at-posting.google.c om...
> I have to copy a Database from Solaris to HP-UX. The versions of Oracle and
> the Database names will be the same. I have one major hitch and question.
> The hitch - export/import is not an option. I can get a cold backup
> for laying the Database down on the HP-UX box, but from then on, I will need
> to roll forward using logs until the decision is made to cut over
> between the two boxes. My question:
> Will there be any OS compatibilty issues for the control, data and log
> files? Meaning, will Oracle on HP-UX be able to read and write to
> control, data and log files created by Oracle on the Soalris box?
>
> Thanks in advance.

Look: you might get lucky. These are two Unixes, after all. But it's not
supported, and I wouldn't bet on it. The only supported way of moving from
one O/S to the other is via export and import. Anything else is down to
testing, crossed fingers, and hefty dollops of prayer to the Almighty.

Regards
HJR

"Joe" wrote in message
news:63bb2d27.0311051615.21c9a8e1-at-posting.google.c om...
> I have to copy a Database from Solaris to HP-UX. The versions of Oracle and
> the Database names will be the same. I have one major hitch and question.
> The hitch - export/import is not an option. I can get a cold backup
> for laying the Database down on the HP-UX box, but from then on, I will need
> to roll forward using logs until the decision is made to cut over
> between the two boxes. My question:
> Will there be any OS compatibilty issues for the control, data and log
> files? Meaning, will Oracle on HP-UX be able to read and write to
> control, data and log files created by Oracle on the Soalris box?
>
> Thanks in advance.

Look: you might get lucky. These are two Unixes, after all. But it's not
supported, and I wouldn't bet on it. The only supported way of moving from
one O/S to the other is via export and import. Anything else is down to
testing, crossed fingers, and hefty dollops of prayer to the Almighty.

Regards
HJR

I would never attempt to use Oracle files created on Solaris on any other
OS.

Why is export/import not an option?

Export/Import is the main way to get done what you are trying to do.

--
"Joe" wrote in message
news:63bb2d27.0311051615.21c9a8e1-at-posting.google.c om...
> I have to copy a Database from Solaris to HP-UX. The versions of Oracle and
> the Database names will be the same. I have one major hitch and question.
> The hitch - export/import is not an option. I can get a cold backup
> for laying the Database down on the HP-UX box, but from then on, I will need
> to roll forward using logs until the decision is made to cut over
> between the two boxes. My question:
> Will there be any OS compatibilty issues for the control, data and log
> files? Meaning, will Oracle on HP-UX be able to read and write to
> control, data and log files created by Oracle on the Soalris box?
>
> Thanks in advance.

I would never attempt to use Oracle files created on Solaris on any other
OS.

Why is export/import not an option?

Export/Import is the main way to get done what you are trying to do.

--
"Joe" wrote in message
news:63bb2d27.0311051615.21c9a8e1-at-posting.google.c om...
> I have to copy a Database from Solaris to HP-UX. The versions of Oracle and
> the Database names will be the same. I have one major hitch and question.
> The hitch - export/import is not an option. I can get a cold backup
> for laying the Database down on the HP-UX box, but from then on, I will need
> to roll forward using logs until the decision is made to cut over
> between the two boxes. My question:
> Will there be any OS compatibilty issues for the control, data and log
> files? Meaning, will Oracle on HP-UX be able to read and write to
> control, data and log files created by Oracle on the Soalris box?
>
> Thanks in advance.

On Thu, 06 Nov 2003 11:39:42 +1100, Howard J. Rogers wrote:

>
> Look: you might get lucky. These are two Unixes, after all. But it's not
> supported, and I wouldn't bet on it. The only supported way of moving from
> one O/S to the other is via export and import. Anything else is down to
> testing, crossed fingers, and hefty dollops of prayer to the Almighty.
>
> Regards
> HJR

Forget it !

I've been there and tried it. The binary compatability between operating
systems just isn't there. You can clone the database easily in the normal
cold backup manner, but when you cone to start it, it won't. Trust me, I'm
not a doctor!

Export/import or create a new database and pull the data over a dblink or
even, use SQL*Plus' COPY command (with a decent commitrate and arraysize)
and you can do it without a link.


--
Delete the obvious bit from my email address to reply by email.

On Thu, 06 Nov 2003 11:39:42 +1100, Howard J. Rogers wrote:

>
> Look: you might get lucky. These are two Unixes, after all. But it's not
> supported, and I wouldn't bet on it. The only supported way of moving from
> one O/S to the other is via export and import. Anything else is down to
> testing, crossed fingers, and hefty dollops of prayer to the Almighty.
>
> Regards
> HJR

Forget it !

I've been there and tried it. The binary compatability between operating
systems just isn't there. You can clone the database easily in the normal
cold backup manner, but when you cone to start it, it won't. Trust me, I'm
not a doctor!

Export/import or create a new database and pull the data over a dblink or
even, use SQL*Plus' COPY command (with a decent commitrate and arraysize)
and you can do it without a link.


--
Delete the obvious bit from my email address to reply by email.

"Burt Peltier" wrote in message
news:nwiqb.45070$un.1684-at-bignews6.bellsouth.net...
> I would never attempt to use Oracle files created on Solaris on any other
> OS.
>
> Why is export/import not an option?
>
> Export/Import is the main way to get done what you are trying to do.
>

Hi Burt,

The main reason of course why export/import is not option is because of
availability issues. For some strange reason, the business wants you to move
to the new platform without any impact to your customers. A bit tricky with
just export/import as your only tool....

Options to get around this include:

- Oracle Replication
- Oracle Streams
- 3rd party products such as Quest's Shareplex

They all require an export/import but they all handle the "tricky" bit of
copying across the changes made during/after the export/import operation
with "minimal" downtime.

Cheers

Richard

"Burt Peltier" wrote in message
news:nwiqb.45070$un.1684-at-bignews6.bellsouth.net...
> I would never attempt to use Oracle files created on Solaris on any other
> OS.
>
> Why is export/import not an option?
>
> Export/Import is the main way to get done what you are trying to do.
>

Hi Burt,

The main reason of course why export/import is not option is because of
availability issues. For some strange reason, the business wants you to move
to the new platform without any impact to your customers. A bit tricky with
just export/import as your only tool....

Options to get around this include:

- Oracle Replication
- Oracle Streams
- 3rd party products such as Quest's Shareplex

They all require an export/import but they all handle the "tricky" bit of
copying across the changes made during/after the export/import operation
with "minimal" downtime.

Cheers

Richard

"Burt Peltier" wrote in message news:...
> I would never attempt to use Oracle files created on Solaris on any other
> OS.
>
> Why is export/import not an option?
>
> Export/Import is the main way to get done what you are trying to do.
>
> --
> "Joe" wrote in message
> news:63bb2d27.0311051615.21c9a8e1-at-posting.google.c om...
> > I have to copy a Database from Solaris to HP-UX. The versions of Oracle and
> > the Database names will be the same. I have one major hitch and question.
> > The hitch - export/import is not an option. I can get a cold backup
> > for laying the Database down on the HP-UX box, but from then on, I will need
> > to roll forward using logs until the decision is made to cut over
> > between the two boxes. My question:
> > Will there be any OS compatibilty issues for the control, data and log
> > files? Meaning, will Oracle on HP-UX be able to read and write to
> > control, data and log files created by Oracle on the Soalris box?
> >
> > Thanks in advance.

Because the they want minimal downtime and the initial load involves
either shipping a tape across the country or FTPing 50gb. In either
case, there will be a number of hours where no changes could be made
to the source system. Is there a way where after the export/import is
done that any changes could be rolled to the new box?