Home » RDBMS Server » Backup & Recovery » EXPDP backup issue with partitioned tables (Composite Partitions) (Oracle 11.2.0.3 on Solaris - Exadata server)
EXPDP backup issue with partitioned tables (Composite Partitions) [message #612040] Fri, 11 April 2014 06:26 Go to next message
hitesh.bhatt
Messages: 40
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.
Re: EXPDP backup issue with partitioned tables (Composite Partitions) [message #612047 is a reply to message #612040] Fri, 11 April 2014 07:31 Go to previous messageGo to next message
EdStevens
Messages: 294
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?
Re: EXPDP backup issue with partitioned tables (Composite Partitions) [message #612053 is a reply to message #612047] Fri, 11 April 2014 08:18 Go to previous messageGo to next message
hitesh.bhatt
Messages: 40
Registered: February 2014
Location: INDIA
Member
Yes, agreed but can we have any other workaround till that time?
if you faced such issue?
Re: EXPDP backup issue with partitioned tables (Composite Partitions) [message #612054 is a reply to message #612053] Fri, 11 April 2014 08:20 Go to previous message
BlackSwan
Messages: 22839
Registered: January 2009
Senior Member
We can not change how the Oracle software behaves.
You need to follow up with Oracle support.
Previous Topic: backup from disk to tape
Next Topic: Recover control file using RMAN
Goto Forum:
  


Current Time: Wed Oct 01 02:34:28 CDT 2014

Total time taken to generate the page: 0.09586 seconds