- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2003 01:35 AM
тАО10-29-2003 01:35 AM
is it possible to recover the 64-bits datafiles on an 32-bits environment?? If yes, what are the steps to do?? I'm stuck in my process. So far I've done the following:
-installed the 8.1.7.2 32-bits environment -SAP
-recovered the 64-bits datafiles
-rebuild the control-files
-at opening the database, received message of inconsistency of datafile 1, system.data1
Thanks for response! Leon Lafleur
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2003 01:38 AM
тАО10-29-2003 01:38 AM
Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?
An export/import would work.
There are procedures for coverting 64 bit word size to 32 bit word size on
http://otn.oracle.com
http://metalink.oracle.com
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2003 02:00 AM
тАО10-29-2003 02:00 AM
Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?
thanks for your reply, I was trying to have it the fast way. Import/Export will be my last resort.
Regards, Leon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2003 07:36 AM
тАО10-29-2003 07:36 AM
SolutionThanks,
Brian
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2003 08:48 AM
тАО10-29-2003 08:48 AM
Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?
This error has nothing to do with 64 bit datafiles. there is no difference between 64/32 bit, when it comes to datafiles, redologs, archivelogs, and undos.
That being said, you should be able to recover 64bit database on 32 bit environment.
The error you get on opening the database is that, some datafiles are not consistent in terms of SCN.
Question, have you applied recent archivelogs during recovery, including the current redolog. if not do that first and open the database with resetlogs. If you think you have lost access to redologs, then you got to do a incomplete recovery.
Anyways, assuming you do this and to covert the word size after recovering..
-- startup restrict
-- run utlirp.sql
-- shutdown immediate
-- startup.
This should change the pl/sql structures to 32 bit compatible.
-
hth,
Stan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2003 08:03 PM
тАО10-29-2003 08:03 PM
Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?
Yes it is possible to recover the database on an 32-bit environment.
Make sure you are pointing to the coreect ORACLE_HOME.
Backup control file to trace, so that your script will include all the datafiles and redo logs.
Shutdown the database in 64-bit environment.
Restore / cp the datafiles to 32-bit environent.
Recreate control file to reflect new locations of datafiles and logfiles
Open the database
Then you will have to run the script to change the worrd size.
Change the word size from 32 to 64 bit or 64 to 32 bit by running
$ORACLE_HOME/rdbms/admin/utlirp.sql
Refer to the the atachment to see the details for changing word size from 32bit to 64bit. or 64-bit to 32-bit. This provides the needed details and steps to change the word-size.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2003 08:15 PM
тАО10-29-2003 08:15 PM
Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?
thanks for you answers!They are very clear
and similar to convert the wordsize 1st! The fact I can NOT startup the Database, looks like the datafiles are really inconsistent.
Probably because I forgot to adjust the init
I'll keep you guys informed about my progress!
Regards, Leon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-29-2003 10:53 PM
тАО10-29-2003 10:53 PM
Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?
Ok, trying I've restored the system datafiles again, deleted the old cntrl files and try to restart the procedure for rebuilding the cntrl files.
Now I'm getting another error message:
-database filename
datafile nr: ....
Where the 1st time nr was 1 for the 1st system datafile, after moving the lines with the system datafiles to the 1st position, it now says nr=81 and this corresponds to line 4 ??
Bye, Leon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2003 12:57 AM
тАО10-30-2003 12:57 AM
Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?
Since you already recreated the controlfiles on the target, you need to restore everything, because some of your datafiles already contain the new SID.
Create controlfile needs all datafiles with header SID when using "SID=" and all datafiles equal for same SID diffrent from target SID when using "SET SID=".
How did you copy the files ? Online or Offline ?
Volker
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-30-2003 01:12 AM
тАО10-30-2003 01:12 AM
Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?
I have an offline backup retrieved.
Is it not possible to bring the database
As I understand now, some of the datafiles have the database file name
datafiles to another line position (as specified in the script after datafile), the error message is always showing another datafile?? e.g. I retrieved the system datafiles again from tape, in the script these datafiles were defined the 5th, 6th ..datafile, but it gave an error message on this data file 1. After moving the system datafiles to position 1,2,3 it gave an error message for the datafile positioned on line 4??.
Any suggestion? regards, Leon