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

[Harry Schipper]

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

[Steven E. Protter]

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

[Harry Schipper]

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 · Accepted solution]

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]

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]

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.

[Harry Schipper]

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]

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]

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]

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