Re: Restoring 64 bit database to 32 bit Server

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: ian@xxxxxxxxxxxxxxxxx
  • Date: Tue, 12 Sep 2006 13:12:41 -0700

On 9/8/06, MacGregor, Ian A. <ian@xxxxxxxxxxxxxxxxx> 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:

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


$ 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


$ 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

Other related posts: