Home > Oracle > ORA-04031: when restoring spfile using rman

ORA-04031: when restoring spfile using rman

When trying to restore the spfile from rman  you might encounter the following error

rman target /
Recovery Manager: Release - Production on Fri Jul 12 11:09:28 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database (not started)<
RMAN> startup force nomount
starting Oracle instance without parameter file for retrieval of spfile
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 07/12/2013 11:09:40
RMAN-04014: startup failed: ORA-04031: unable to allocate 70464 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","KTI-UNDO")
RMAN> exit

RMAN will use certain default values. Sometimes, these default values may not be sufficient (depending on your version/os).

This is a well known behavior.
set this environment variable to a higher value.
export ORA_RMAN_SGA_TARGET= xxxxxxx

Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: