My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.