• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 377
  • Last Modified:

Switching Platforms

We are switching platforms from Solaris 64 bit to Linux x86 64 bit.  I'm looking at some documentation on transportable tablespaces and using RMAN CONVERT.  I am wondering exactly what does going through all that trouble benefit as opposed to just doing an expdp full followed by an inpdb?
0
xoxomos
Asked:
xoxomos
  • 5
  • 4
1 Solution
 
slightwv (䄆 Netminder) Commented:
Have you reviewed the online docs on these topics?

These methods can save you time if dealing with large amounts of data.  I don't think you will find anything that says when you should use one method over the other.

0
 
xoxomosAuthor Commented:
I'm in the process now.  Someone on a listserve stated they were able to make the platform change using transportable tablespaces.  Looking at the documentation it appears to me that using transportable tablespaces you still need to run expdp anyhow so I'm not seeing any benefit.  The database is about 350 gb.  Exported the .dmp file comes out to about 80 gb.
Of course there is a bug 8984274 where Oracle is incorrectly having a user grant privileges to themselves when using expdp/impdp which is currently preventing my attempt to import.  However if Oracle supplies us with a patch for this bug i'm just wondering if a straight expdp/impdp[ will be sufficient for the platform change or if for some reason i don't know i will be compelled to do the transportable tablespace exercise?
0
 
slightwv (䄆 Netminder) Commented:
I've not done transportable tablespaces but I believe you only need to export/import the meta data not the table data.

I prefer the manual migration when possible.  I precreate the database and all users in the correct tablespaces etc...

Then I only need to import the data.

I'm lucky though because I created and maintained create scripts. I can clone the setup without data in minutes ruinning a few scripts.
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
xoxomosAuthor Commented:
That is probably correct since the actual data will be the tablespaces having gone through the RMAN CONVERT process.  This is what I'm inquiring about.  If i create the database on linux, should I not be able to just then import from a plain .dmp file?  When I tried it did seem to be working, but then ran into that bug where it was trying GRANT INSERT ON tablex TO usera, then generated that ORA-01749 error saying usera cannot grant privileges to itself.
0
 
slightwv (䄆 Netminder) Commented:
Did you do a FULL import?  If so, I'm not a big fan.  I normally import the specific schemas I need after I have pre-created them (using IGNORE=Y).
0
 
xoxomosAuthor Commented:
I've tried it both ways.  After the full failed on the ORA- error, I tried just doing the schema.  The problem is the schema has the same incorrect GRANT INSERT ON tablex TO usery and generated the same error saying usery  can't grant itself privileges.   With no patch the only thing i can see is impdp system/pass
SQLFILE=import.sql ........., then go into the SQLFILE and not only extract sql that will create the tablespaces but also create the users, then extract all the GRANT(s) into some script and run that as system or sys instead of as the users as Oracle is trying to do.  I don't know about that IGNORE.  There may be something i do NOT want to IGNORE happening :-)
0
 
slightwv (䄆 Netminder) Commented:
I'm not an impdp expert.  I've only used it a couple of times.  In the old imp version you needed to set IGNORE=Y if the objects already existed in the database because imp tried to create them.

I'm sure the same sort of thing is around in impdp.  The docs will have the info.
0
 
xoxomosAuthor Commented:
Yes, it exists with impdp also.  Basically it will ignore an error from a  CREATE TABLE where the table exists and proceed to load the existing table.
0
 
xoxomosAuthor Commented:
Actually its not IGNORE=Y with impdp but something like EXISTS_ACTION=skip.
11.2.2 fixed the problem, but now I back on a 10.2.0.4 and I'll probably have to follow your technique for the 10 databases.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now