Home » RDBMS Server » Backup & Recovery » unable to take backup urgent (wimdows-2003 server)
unable to take backup urgent [message #408123] Sun, 14 June 2009 08:31 Go to next message
Messages: 36
Registered: March 2007
Location: BHILAI
Hello Gurus,

When i am taking backup of my db it is giving error no ora-4032.
can any one suggest me why this error is coming. And how to resolve this error.

Sunil Madnani
Re: unable to take backup urgent [message #408127 is a reply to message #408123] Sun, 14 June 2009 08:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Instead of describing the error,
please post the exact error number and complete error message.
Post the version of Oracle and what kind of "backup" you are trying to do along with the actual commands you used.
Is a very generic message.
Re: unable to take backup urgent [message #408128 is a reply to message #408123] Sun, 14 June 2009 08:43 Go to previous message
Michel Cadot
Messages: 67852
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-04032: pga_aggregate_target must be set before switching to auto mode
 *Cause:  attempt to set workarea_size_policy to AUTO while
            pga_aggregate_target is not specified
 *Action: before setting workarea_size_policy, set pga_aggregate_target
          to a value representing the total private memory available to
          the instance. This total is generally the total physical memory
          available in the system minus what is needed for the SGA minus
          what is needed for the operating system (e.g. 500MB)

Previous Topic: Delete archive logs
Next Topic: rman catalogt: how to register and check registration of a DB?
Goto Forum:

Current Time: Tue May 18 12:39:20 CDT 2021