restore Issue

[Mahesh Hardikar]

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

[Frank]

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

[sybrandb]

ha*******@yahoo.com (Mahesh Hardikar) wrote in message news:<4a**************************@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