OraFAQ Forum: Backup & Recovery » In my server RMAN can't allocate memory to the virtual instance

Home » RDBMS Server » Backup & Recovery » In my server RMAN can't allocate memory to the virtual instance

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

In my server RMAN can't allocate memory to the virtual instance [message #476258]

Wed, 22 September 2010 06:43

khosravi
Messages: 68
Registered: April 2006

Member

Hi

I want to restore my database in a new server
At first I want to restore "spfile" from controlfile autobackup, there is no spfile or pfile of my database in the new server

I do these steps

1 . expoer ORACLE_SID=Sales
2. rman target /
3. rman > set dbid 817528985
4. rman > startup force nomount

after step 4 I get this error :

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 09/22/2010 14:03:21
RMAN-04014: startup failed: ORA-04031: unable to allocate 28704 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","kebm test replies")

I get this error while I have about 80GB free memory on the new server
and my parameters in /etc/sysctl.conf file is :

kernel.sysrq = 0
kernel.core_uses_pid = 1
kernel.shmall = 5242880
kernel.shmmax = 42949672960
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144

I need to say that I can create a new database in that server by dbca that its
sga_max_size is 9632M and pga_aggregate_target is 3206M

Do you know what is wrong ? Do you know why RMAN can't allocate memory to the virtual instance ?

thanks

Report message to a moderator

Re: In my server RMAN can't allocate memory to the virtual instance [message #476260 is a reply to message #476258]

Wed, 22 September 2010 06:49

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Enlarge your shared pool or better use large pool by setting large_pool_size parameter then RMAN will not be disturbed by other processes and vice versa.

Regards
Michel

Report message to a moderator

Re: In my server RMAN can't allocate memory to the virtual instance [message #476279 is a reply to message #476260]

Wed, 22 September 2010 08:47

khosravi
Messages: 68
Registered: April 2006

Member

There is not any spfile or pfile
I wanna start the instance by the dummy parameter file in RMAN to
restore spfile
so I can't change any parameter before restoring spfile

If you refer to http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov004.htm#CFAGFDJC
I wanna do like this method

Report message to a moderator

Re: In my server RMAN can't allocate memory to the virtual instance [message #476281 is a reply to message #476279]

Wed, 22 September 2010 08:51

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

expoer ORACLE_SID=Sales

I think this one is not a good one.
NEVER write what you did; ALWAYS copy and paste your session.

Regards
Michel

[Updated on: Wed, 22 September 2010 08:51]

Report message to a moderator

Re: In my server RMAN can't allocate memory to the virtual instance [message #476298 is a reply to message #476258]

Wed, 22 September 2010 09:43

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

As Michel said, always post what you did instead on explaining. Just copy and paste.
And please post Oracle Versions/OS versions.

If no parameter files are specified ( since you are trying to restore one),
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.
You can create a dummy pfile with sufficient values (as Michel said)
or
set this environment variable to a higher value.

export ORA_RMAN_SGA_TARGET= someHigherValueNNN

and try again.

Report message to a moderator

Re: In my server RMAN can't allocate memory to the virtual instance [message #476300 is a reply to message #476298]

Wed, 22 September 2010 09:46

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

set this environment variable to a higher value.
export ORA_RMAN_SGA_TARGET= someHigherValueNNN

Did not know this one? /forum/fa/2115/0/

Regards
Michel

Report message to a moderator

Re: In my server RMAN can't allocate memory to the virtual instance [message #476742 is a reply to message #476300]

Sat, 25 September 2010 01:10

khosravi
Messages: 68
Registered: April 2006

Member

Thank you

I used ORA_RMAN_SGA_TARGET parameter and the instance was started

we have another servers too but we don't have this problem in those servers

I need to say that
The OS of our those servers that don't have the problem is Linux 2.6.9-42.0.0.0.1.ELsmp
And the OS of the server that has the problem is Linux 2.6.9-78.ELlargesmp
And our Oracle in both is 10.2.0.2.0

I think that this problem is because of OS

Now please say to me that , am I right ?

Do you know what is the origin of the problem ?

Thanks

Report message to a moderator

Re: In my server RMAN can't allocate memory to the virtual instance [message #476743 is a reply to message #476742]

Sat, 25 September 2010 01:15

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

If no parameter files are specified ( since you are trying to restore one),
RMAN will use certain default values. Sometimes, these default values may not be sufficient (depending on your version/os).

Regards
Michel

Report message to a moderator

Previous Topic:	Restore tablespace without mount database.
Next Topic:	rman:06556

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 13:00:05 CST 2024