ORA-04031 trying to flashback standby database (Doc ID 863985.1)

Last updated on JULY 27, 2009

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7
This problem can occur on any platform.

Symptoms

Alert log may show following errors when trying to flashback database.

Failed to allocate 3981120 bytes from shared pool for flashback generation buffer

ORA-04031: unable to allocate 3981152 bytes of shared memory ("shared pool","unknown object","sga
heap(1,0)","flashback generation buffer")

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms