Re: Restoring 64 bit database to 32 bit Server

On 9/8/06, MacGregor, Ian A. <ian_at_slac.stanford.edu> wrote:
>
> Are you positive the 32-bit server has permission to see the files backed
> up on your 64-bit server? If does do you need to tell it to look in the
> 64-bit machine "area"? I'm unfamiliar with NETBACKUP but with Tivoli Data
> Protection for Oracle in the TDPO option file for the 32-bit machine one
> would need to to replace
>
>

Not a permissions problem.

RMAN DUPLICATE can restore the files to a 32 bit server, but the RECOVER fails with the archive logs:

ORA-00354: corrupt redo log block header

ORA-00353: log corruption near block 124471 change 1554268051 time 08/25/2006 07:03:32

ORA-00334: archived log:
'/u01/oradata/ts01/archive/ts01_0001_0000001453.arc'

The same log files worked when restored to a 64 bit server.

ML Note 62290.1 claims that data,undo and redo do not differ between 32 bit and 64 bit platforms.

Interestingly though, the MD5 checksums differ when the file is restored to a 32 bit platform.
Even more interesting, cksum and sum do not differ:

64 BIT $ md5sum /u01/oradata/ts01/archive/ts010001_0000001453.arc

d02c4252bba65fa8f026944a0e440451
/u01/oradata/ts01/archive/ts010001_0000001453.arc

$ sum /u01/oradata/ts01/archive/ts010001_0000001453.arc

09390 102400

$ cksum /u01/oradata/ts01/archive/ts010001_0000001453.arc

426663138 104857088 /u01/oradata/ts01/archive/ts010001_0000001453.arc

32 BIT $ md5sum /u01/oradata/ts01/archive/ts01_0001_0000001453.arc

a363e3f709739bdbec5cc8976f437012
/u01/oradata/ts01/archive/ts01_0001_0000001453.arc

$ sum /u01/oradata/ts01/archive/ts01_0001_0000001453.arc

09390 102400

$ cksum /u01/oradata/ts01/archive/ts01_0001_0000001453.arc

426663138 104857088 /u01/oradata/ts01/archive/ts01_0001_0000001453.arc

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

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