Re: Standby Database from HP-UX to SUN

From: BN <bnsarma_at_gmail.com>
Date: Tue, 25 Apr 2006 09:21:59 -0500
Message-ID: <61292a9d0604250721g144de137g903777859086415d@mail.gmail.com>

Greetings,

Since my UNIX SA already copied all the files, I wanted to see what happens ...

Here is the flow :

strup nomount pfile=standby.ora;

No problem

alter database mount standby database;

noproblem

recover standby database;

Oracle complained about log corruption...

ORA-00283: recovery session canceled due to errors
ORA-00399: corrupt change description in redo log
ORA-00353: log corruption near block 5176 change 7923581296103 time

04/16/2006

Here is Oracle's Reply:

1)You can not just move files at os level from HP to sun 2) It reads the controlfile but cant read the blocks because the format is not compatable across the platforms. It attmpts to read teh header blcoks for the datafiles and signals
corruption.

End of Story.

Regards & Thanks
BN

On 4/24/06, Ghassan Salem <salem.ghassan_at_gmail.com> wrote:
>
> Dennis,
> it is implemented in 10gR2, it works through RMAN.
>
> rgds
>
>
> On 4/24/06, Dennis Williams < oracledba.williams_at_gmail.com> wrote:
> >
> > BN,
> >
> > Perhaps you were recalling the announcement that Transportable
> > Tablespaces would be able to be converted across platforms?
> > http://www.oracle.com/technology/pub/articles/10gdba/week16_10gdba.html
> > My understanding is this feature is "yet to be implemented".
> >
> > Dennis Williams
> >
> >
> > On 4/22/06, David Sharples <davidsharples_at_gmail.com > wrote:
> > >
> > > n yo cant do standby between different os's
> > >
> > >
> > > On 21/04/06, BN <bnsarma_at_gmail.com> wrote:
> > > >
> > > > Greetings
> > > >
> > > >
> > > > Oralce Version 9.2.0.5
> > > >
> > > > ITs Friday evening. Want to confirm that a , my understanding is
> > > >
> > > > Cold (Any Backup except exp) Backup Taken on HP-UX 64 bit cannot be
> > > > restored on a SUN Box to setup a Standby Database
> > > >
> > >
> >
> >
>
>

--
Regards & Thanks
BN

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

Received on Tue Apr 25 2006 - 09:21:59 CDT