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 2 5363
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 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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: FoxRunner |
last post by:
Hi folks,
I got a script which restores a database. It works fine
if it is running in my Query Analyzer.
It fails when I put this script in an automated schedule using the
SQL agent.
This...
|
by: GL |
last post by:
I am running DB2 8.1.1 on AIX 5.1
Having a problem with a redirected restore.
Once into the restore continue phase, I immediately get the following
“SQL2059W A device full warning was...
|
by: Anurag |
last post by:
Hello,
I wish to find out the restore method for database that have been
incrementally backed up and in the scenario where just the delta has
been backed up.
For example sake, let us assume the...
|
by: Chris |
last post by:
I have searched this group for answers and tried the responses.
I am trying to Use an full online backup from our production server and
apply it to our test server. The Tablespaces in the...
|
by: prerak_v_shah |
last post by:
Hi All,
These days I was working on IBM DB2 database for windows with my .Net Application.
Now, it was required to backup database created on one machine to the other machine. I was also able...
|
by: cerbdog |
last post by:
Hello, all. Was hoping someone might be able to help us out with an
issue:
We're trying to perform a restore from a backup of one AIX 5.1 server,
we'll call it "AIX", to another AIX 5.1 server;...
|
by: africantract |
last post by:
Hi There, We have an issue on our db2 restores. We do database dumps
every night, and restore them to development servers every morning.
This works fine with no errors. However if we backup those...
|
by: mccuenpat |
last post by:
Currently trying to perform a redirected restore of DB2 database using Netbackup in AIX environment. The restore command completes successfully but the set tablespace commands fail due to no...
|
by: Kofa |
last post by:
Dear All,
I'd like to know whether it is possible to restore backups created on
a production machine, running DB2 9.1 on Windows, using DMS table
space containers, onto a developer's machine,...
|
by: BD |
last post by:
Hi there.
Using 8.2 on Windows.
I have a situation where I have a db backup, which I want to deploy to
a group of developer workstations.
The target directory for the database files will be...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |