Home » RDBMS Server » Backup & Recovery » In my server RMAN can't allocate memory to the virtual instance
In my server RMAN can't allocate memory to the virtual instance [message #476258] Wed, 22 September 2010 06:43 Go to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58905
Registered: March 2007
Location: Nanterre, France, http://...
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
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 Go to previous messageGo to next message
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
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58905
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10618
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58905
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
set this environment variable to a higher value.
export ORA_RMAN_SGA_TARGET= someHigherValueNNN

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

Regards
Michel
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 Go to previous messageGo to next message
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
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 Go to previous message
Michel Cadot
Messages: 58905
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Restore tablespace without mount database.
Next Topic: rman:06556
Goto Forum:
  


Current Time: Wed Aug 27 10:04:14 CDT 2014

Total time taken to generate the page: 0.10469 seconds