Home » RDBMS Server » Backup & Recovery » Parttioned table back (11.2.0.1.0, SunOS)
Parttioned table back [message #537541] Thu, 29 December 2011 04:01 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

I am not able to take backup of table which is partitioned.Whenever i start the backup
it was hanging with wait event "asynch descriptor resize", so I tried to create another table
using original table ( like create table BASE_TABLE AS SELECT * FROM BASE_TABLE),
but it is also hanging with same wait event.

Can anybody suggest me how to resolve this issue ?

[Updated on: Thu, 29 December 2011 04:02]

Report message to a moderator

Re: Parttioned table back [message #537566 is a reply to message #537541] Thu, 29 December 2011 06:07 Go to previous messageGo to next message
himabija
Messages: 33
Registered: December 2011
Location: San Francisco
Member
Please provide the copied contents of your command and error message.
Re: Parttioned table back [message #537580 is a reply to message #537541] Thu, 29 December 2011 08:26 Go to previous messageGo to next message
John Watson
Messages: 7618
Registered: January 2010
Location: Global Village
Senior Member
Sounds like bug 9829397, you need to apply the 11.2.0.3 patchset.
Re: Parttioned table back [message #537660 is a reply to message #537580] Fri, 30 December 2011 02:17 Go to previous messageGo to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
This issue is resolved.

I use the below command which got hang in the middle but later it ran successfully after adding
parameter direct=y at the end of the export command.

exp system/pwd statistics=none indexes=N buffer=104857600 rows=Y 
feedback=1000000 constraints=N grants=N tables=JACK.BASE_TABLE


[Updated on: Fri, 30 December 2011 03:34] by Moderator

Report message to a moderator

Re: Backup Partitioned table [message #537728 is a reply to message #537660] Fri, 30 December 2011 10:59 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Actually what John suggested was correct because wait events kept on changing later.

Thank you John for your suggestions.

[Updated on: Fri, 30 December 2011 11:04]

Report message to a moderator

Previous Topic: Perform incomplete user managed backup and recovery
Next Topic: corrupt blocks issue
Goto Forum:
  


Current Time: Thu Oct 18 17:00:35 CDT 2018