Home » RDBMS Server » Server Administration » transportable tablespace RHEL to Solaris (Oracle 10g R2/ Linux 6.2, Solaris 10)
transportable tablespace RHEL to Solaris [message #663725] Thu, 15 June 2017 05:08 Go to next message
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,

[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 messageGo to next message
John Watson
Messages: 8922
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 #663767 is a reply to message #663727] Fri, 16 June 2017 21:15 Go to previous messageGo to next message
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.

Re: transportable tablespace RHEL to Solaris [message #663769 is a reply to message #663767] Sat, 17 June 2017 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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
Re: transportable tablespace RHEL to Solaris [message #663772 is a reply to message #663767] Sat, 17 June 2017 03:26 Go to previous messageGo to next message
John Watson
Messages: 8922
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
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:
  


Current Time: Fri Mar 29 07:48:35 CDT 2024