469,148 Members | 1,517 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,148 developers. It's quick & easy.

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
Jul 19 '05 #1
2 5208
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

Jul 19 '05 #2
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
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by FoxRunner | last post: by
9 posts views Thread by GL | last post: by
11 posts views Thread by Chris | last post: by
3 posts views Thread by cerbdog | last post: by
4 posts views Thread by africantract | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.