[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

convert datafile windows 32 bits on linux 64 bits

Posted on 2011-10-19
10
Medium Priority
?
245 Views
Last Modified: 2012-06-21
Hello

I have to convert datafile windows 32 bits on linux 64 bits on destination host.
How can I do?
Thanks
bibi
0
Comment
Question by:bibi92
  • 5
  • 5
10 Comments
 
LVL 78

Accepted Solution

by:
slightwv (䄆 Netminder) earned 2000 total points
ID: 36992750
You should always add versions.  From your last question I assume 10gR1?

Check out transportable tablespaces:
http://download.oracle.com/docs/cd/B14117_01/server.101/b10739/tspaces.htm#i1007169

I'm not sure about the endian difference between Linux and Windows but the doc link above has info on figuring out if this is possible.

0
 

Author Comment

by:bibi92
ID: 36992827
Thanks, I have no space on windows server.
Can I stop the db on windows and copy the datafile on linux and then :
# Conversion on a Linux destination host from a Solaris source file.
CONVERT DATAFILE=
    '/tmp/transport_win/my_ts_file01.dbf',
    '/tmp/transport_win/my_ts_file02.dbf'
  FROM PLATFORM 'Windows (32-bit)'
  DB_FILE_NAME_CONVERT
    '/tmp/transport_win','/u01/oradata/MYDB';

Thanks
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36992878
Never tried this but the doc link I provided seems to imply you can.

From the docs in step 4:
If you have transported the tablespace set to a platform with different endianness from the source platform, and you have not performed a source-side conversion to the endianness of the target platform, you should perform a target-side conversion now.
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 

Author Comment

by:bibi92
ID: 36993798
the endianness are the same. So can I copy only the datafiles?

Thanks

bibi
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36993814
I've never done it.  Not sure.  I have to go by what the docs say.

Do you not have a test system where you can try it and see?
0
 

Author Comment

by:bibi92
ID: 36993855
Yes, but the db size is 600go
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36993879
OK then, do you have a development system?

Just a small database you can experiment with? This is the only way to know for sure it will work.
0
 

Author Comment

by:bibi92
ID: 36993905
no sorry
0
 
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36993927
You will have to 'test' it sooner or later.  Nothing posted on a site like this should be taken as 100% accurate 100% of the time.  What works for one shop, might not work for another.

The docs seem to say it is possible.  Not sure what else to tell you.

Maybe another Expert will be along that has actually done this in an environment that matches yours.  Even then, if they say, sure you can do it.   Then what?  It still might fail for you.

You must have the ability to test things before you try them in production.
0
 

Author Closing Comment

by:bibi92
ID: 37058849
Thanks bibi
0

Featured Post

NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question