OraFAQ Forum: Backup & Recovery » EXPDP backup issue with partitioned tables (Composite Partitions)

Home » RDBMS Server » Backup & Recovery » EXPDP backup issue with partitioned tables (Composite Partitions) (Oracle 11.2.0.3 on Solaris - Exadata server)

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

EXPDP backup issue with partitioned tables (Composite Partitions) [message #612040]

Fri, 11 April 2014 06:26

hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA

Member

Hi,

I am facing one issue with EXPDP while trying to backup a schema.
Schema having many tables which are partitioned (Composite Partitions). Number of partitions also very high.

When we are trying to backup the schema, the EXPDP process is getting hung and after running for 6-8 hours its stuck in the same state.

Tried following scenarios:

Scnerio 1: EXPDP Excluding Table -- Completed Successfully.
Scnerio 2: EXPDP Excluding Partitioned Table -- Completed Successfully
Scnerio 3: EXPDP with just one Partitioned Table -- facing the same issue.

As per Oracle its a bug and suggested to apply patch.
We applied the patch but still facing the same issue.

Could anyone please share valuable thoughts on this?

Many thanks in advance.

Report message to a moderator

Re: EXPDP backup issue with partitioned tables (Composite Partitions) [message #612047 is a reply to message #612040]

Fri, 11 April 2014 07:31

EdStevens
Messages: 1375
Registered: September 2013

Senior Member

If Oracle already identified a bug and supplied a patch, you need to follow up with Oracle support.

Your question is essentially the same as

The air conditioner on my car keeps shutting itself off. The dealer identified a defective regulator switch and installed a new one. The problem isn't fixed. What should I do?

Report message to a moderator