Re: restore Issue

hardikarm_at_yahoo.com (Mahesh Hardikar) wrote in message news:<4a1c57c2.0310022058.22bee496_at_posting.google.com>...
> Hello ,
>
> I am testing cold backup restore.
>
> Source Details :
>
> OS : Red Hat AS 2.1 64Bit
> Database : Oracle9i Enterprise Edition Release 9.2.0.2.0 64 Bit -
> Production
>
> Destination :
>
> OS : Red Hat AS 2.1 32 Bit
> Database : Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
>
> Now in this scene , is it possible to restore datafiles from source to
> destination ? here source is 64 Bit Oracle & Destn is 32 Bit.
>
> Client is asking me if in this scene , it will be possible to have
> Destination hardware to be used for configuring Standby Database.
>
> For test , I restored datafiles from source to destn. Recreated
> controlfile & tried opening. Database got opened. But when I try to
> alter tablespace TEMP to add file, it gives error :
>
> ORA-00604 : error occured at recursive SQL Level 1
> ORA-06553 : PLS-801 internal error [56319]
>
> I get same error if I try to create a test tablespace although
> resizing a datafile goes thru.
>
> Any pointers on this are highly appreciated ...
>
> Thanks & Regards,
> Mahesh Hardikar

Unix 32-bit and Unix 64-bit is NOT filesystem compatible. This has to do with little and big endian filesystems.

Sorry

Sybrand Bakker
Senior Oracle DBA Received on Fri Oct 03 2003 - 12:49:58 CEST