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: '/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
