Re: restore Issue

Mahesh Hardikar wrote:

> 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

What makes you think you can use "64-bit files" on a 32-bit OS?
Something like restoring 9i in a 8i env...

-- 
Regards, Frank van Bortel