OraFAQ Forum: Backup & Recovery » ASM issue during RMAN backkup

Home » RDBMS Server » Backup & Recovery » ASM issue during RMAN backkup (Solaris 10, Oracle 10.2.0.4)

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

ASM issue during RMAN backkup [message #451826]

Sat, 17 April 2010 02:49

lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi

Member

Hi Experts,
I need your guidance in one of the issue we are facing.
Basically we are managing the databases on ASM running on Oracle 10.2.0.4.
During the restoration process, we faced error:

ORA-15055: unable to connect to ASM instance
ORA-00020: maximum number of processes () exceeded
ORA-15055: unable to connect to ASM instance
ORA-00020: maximum number of processes () exceede
channel aux3: starting datafile backupset restore

We are trying to restore the database by allocating 12 channels during rman restoration. And this error usually coming during restoration process.
The value of the SESSIONS parameter is 49 and PROCESSES 40.
The ASM instance is in nomount state, so can not debug more.

We already faced on one of the development box. Which is resolved by increasing the value of SESSIONS and PROCESSES parameter on ASM instance.
Just want to know is there any other solution apart increasing these parameters and bouncing the databases.

Regards
Lalit

Report message to a moderator

Re: ASM issue during RMAN backkup [message #451828 is a reply to message #451826]

Sat, 17 April 2010 03:06

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The other solution than restarting the ASm instance is to shutdown some of the instances that use ASM.

Regards
Michel

Report message to a moderator

Re: ASM issue during RMAN backkup [message #451829 is a reply to message #451826]

Sat, 17 April 2010 03:17

lalitm_2003
Messages: 86
Registered: May 2005
Location: delhi

Member

Thanks Michel for the quick reply.
But we can not shutdown any of the database for long time(time require to restore/refresh the database is nearly 1 hr). We already gave a thought on this Sad

I guess the only option now is to bounce the ASM and other dbs.

Regards
Lalit

Report message to a moderator

Re: ASM issue during RMAN backkup [message #451831 is a reply to message #451829]

Sat, 17 April 2010 04:04

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Yes, I think so.

Regards
Michel

[Updated on: Sat, 17 April 2010 04:04]

Report message to a moderator

Re: ASM issue during RMAN backkup [message #453045 is a reply to message #451831]

Mon, 26 April 2010 16:46

mherlindo
Messages: 16
Registered: April 2010
Location: México

Junior Member

You should increase the processes parameter in the ASM parameter file.

Report message to a moderator

Re: ASM issue during RMAN backkup [message #453054 is a reply to message #453045]

Mon, 26 April 2010 23:11

Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

I think if OP said "Which is resolved by increasing the value of SESSIONS and PROCESSES parameter on ASM instance" he knows he can increase the parameter, don't you think?

Regards
Michel

Report message to a moderator

Previous Topic:	Server crashed. Is there any hope?????
Next Topic:	ORA-01589: must use RESETLOGS or NORESETLOGS option for database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 16:32:20 CDT 2024