transportable tablespace RHEL to Solaris [message #663725] |
Thu, 15 June 2017 05:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
reym21
Messages: 241 Registered: February 2010 Location: Philippines
|
Senior Member |
![vyer.atarom@gmail.com](/forum/theme/orafaq/images/google.png)
|
|
Gurus,
Good day!
Can you please advise me on what to do next.
I'm transporting a non-critical production database from Linux to Solaris.
I completed the prerequisites prior to importing the export dump file
from source server (Linux) to the destination server (Solaris).
My import datapump failed many times due to this 2 recurring errors:
1) ORA-29349- 'tablespace already exist' (data/index tablespaces recreated to the destination server); &
2) ORA-27037- 'unable to obtain file status' (whenever I dropped the affected tablespace).
Please refer to the attached logs.
Thank you & best regards,
[Updated on: Thu, 15 June 2017 05:11] Report message to a moderator
|
|
|
Re: transportable tablespace RHEL to Solaris [message #663727 is a reply to message #663725] |
Thu, 15 June 2017 05:24 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
In your attachment you say
** AFFECTED DATAFILE RECREATED BEFORE DATA PUMP EXECUTION **
and
** AFFECTED INDEX DATAFILE DROPPED PRIOR TO DATA PUMP EXECUTION **
What are you actually doing? How do you recreate or drop this datafile? Why have you not simply dropped the tablespaces before attempting the transport?
|
|
|
|
|
Re: transportable tablespace RHEL to Solaris [message #663772 is a reply to message #663767] |
Sat, 17 June 2017 03:26 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
reym21 wrote on Sat, 17 June 2017 03:15@John Watson
Sir,
I'm still encountering this same error, re: ORA-27037- unable to obtain file status, '/dtaarea2/oracle/datafiles/site/site_data_01.dbf'.
The only tablespaces existing are SYSTEM, SYSAUX, USERS, UNDO & TEMP.
Thank you for your prompt advise.
You want "prompt advice"? In that case, pay a consultant.
|
|
|
Re: transportable tablespace RHEL to Solaris [message #664788 is a reply to message #663772] |
Thu, 03 August 2017 10:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
Bill B
Messages: 1971 Registered: December 2004
|
Senior Member |
|
|
you have corrupted your database by dropping the Datafile. Either recover the datafile by going through recovery using your backup. If you don't have backup then drop and recreate the database. create the tablespaces where you want them on the new server. You can now run IMPDP. Ignore the errors about the tablespace already existing, it doesn't hurt anything. As long as the tablespace name is the same as what it is in the export file it will happily make the objects and import the data. most IMPDP runs have some errors showing. Not a big deal.
[Updated on: Thu, 03 August 2017 10:46] Report message to a moderator
|
|
|