Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?

SOLVED
Go to solution
Harry Schipper
Occasional Advisor

Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?

hi,
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
12 REPLIES
Steven E. Protter
Exalted Contributor

Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?

A straight database clone presents a problem. To get the data to 64 bit word size a conversion was done.

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Harry Schipper
Occasional Advisor

Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?

SEP,
thanks for your reply, I was trying to have it the fast way. Import/Export will be my last resort.

Regards, Leon
Brian Crabtree
Honored Contributor
Solution

Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?

You should be able to restore the datafiles to the 32 bit system, and run the recovery. When it is done, you will need to convert the data to 32bit wordsize (look on metalink) and run the utlirp.sql script under ?/rdbms/admin to rebuild the objects. Preferably, you should also run the catalog, catproc, and catexp (catrep and the rest as needed).

Thanks,

Brian
Stan_17
Valued Contributor

Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?

Hi Leon,

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
Indira Aramandla
Honored Contributor

Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?

Hi,

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.
Never give up, Keep Trying
Harry Schipper
Occasional Advisor

Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?

Hi Brian/Stan/Indira,
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.ora file with the proper rollback- segs. I'm going to give it another try, by 1st restoring only the system datafiles, if that doesn't work I'll restore the complete datafiles again.

I'll keep you guys informed about my progress!

Regards, Leon
Harry Schipper
Occasional Advisor

Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?

Hi,
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 in file header does not match given name of
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
Volker Borowski
Honored Contributor

Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?

Harry, bad news !

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
Harry Schipper
Occasional Advisor

Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?

Hi Volker,

I have an offline backup retrieved.
Is it not possible to bring the database back to it's original state and then redo the whole process of rebuilding the controlfiles.
As I understand now, some of the datafiles have the database file name and some have . Strange thing is when I move the
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
Volker Borowski
Honored Contributor

Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?

Hi Harry, (Leon ?),

please attach spooled output -> much easier to understand !

Are you sure the backup was taken after
a successfull "shutdown normal" or "shutdown immediate" ?
If it was after a shutdown abort, you might need to "recover database" before you open resetlogs the database, because the resetlogs open will destroy the online logs which might be needed for instance recovery.

Volker
Harry Schipper
Occasional Advisor

Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?

Hi Volker,

See contents of script: create_cf_file.sql and error messages in attachment.

Backup was made after normal shutdown.

I've checked the datafiles on the system and currently 113 files have been 'adjusted' have recent date/time stamp and 55 were 'original'. We will restore ALL files again tomorrow and give it another try.

I'll keep you informed! Regards, Leon
Harry Schipper
Occasional Advisor

Re: Recover an Oracle 8.1.7.2 - 64 bits DB on a 32-bits environment?

hi all,

after a new restore I succeeded to rebuild the controlfiles and mannaged to switch over from 64 bit structure to 32 bit structure by executing the following scripts:
-catalog.sql
-utlip.sql
-utlrp.sql

So finally everything was properly working!

Thanks for your response! Leon Lafleur