OraFAQ Forum: Server Administration » transportable tablespace RHEL to Solaris

Home » RDBMS Server » Server Administration » transportable tablespace RHEL to Solaris (Oracle 10g R2/ Linux 6.2, Solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

transportable tablespace RHEL to Solaris [message #663725]

Thu, 15 June 2017 05:08

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

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,

Attachment: impdp_logs-trans-tbsp.txt
(Size: 9.13KB, Downloaded 2386 times)

[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

John Watson
Messages: 8976
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?

Report message to a moderator

Re: transportable tablespace RHEL to Solaris [message #663767 is a reply to message #663727]

Fri, 16 June 2017 21:15

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

@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.

Report message to a moderator

Re: transportable tablespace RHEL to Solaris [message #663769 is a reply to message #663767]

Sat, 17 June 2017 01:11

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Code: [Select all] [Show/ hide]

ORA-27037: unable to obtain file status
 *Cause:  stat system call returned an error, additional information
          indicates which function encountered the error
 *Action: check errno

Report message to a moderator

Re: transportable tablespace RHEL to Solaris [message #663772 is a reply to message #663767]

Sat, 17 June 2017 03:26

John Watson
Messages: 8976
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.

Report message to a moderator

Re: transportable tablespace RHEL to Solaris [message #664788 is a reply to message #663772]

Thu, 03 August 2017 10:46

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

Previous Topic:	Is there any way to find out if a database is a copy of another database?
Next Topic:	upgrading 11g to 12c on new windows server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 10:29:32 CDT 2025