restore Issue

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 Received on Fri Oct 03 2003 - 06:58:57 CEST