BRArchive got failed

[Former Member]

Dear All ,

Brarchive backup got failed ,pls check below logs ..

BR0002I BRARCHIVE 7.00 (49)

BR0169I Value 'util_file_online' of parameter/option 'backup_dev_type/-d' ignored for 'brarchive' - 'util_file' assumed

BR0006I Start of offline redo log processing: aefbdmjy.cds 2011-01-21 11.04.18

BR0484I BRARCHIVE log file: /oracle/IRP/saparch/aefbdmjy.cds

BR0280I BRARCHIVE time stamp: 2011-01-21 11.04.19

BR0301E SQL error -20 at location BrInitOraCreate-2, SQL statement:

'CONNECT / AT PROF_CONN IN SYSOPER MODE'

ORA-00020: maximum number of processes (%s) exceeded

BR0303E Determination of Oracle version failed

BR0007I End of offline redo log processing: aefbdmjy.cds 2011-01-21 11.04.19

BR0280I BRARCHIVE time stamp: 2011-01-21 11.04.19

BR0005I BRARCHIVE terminated with errors

Kindly suggets ..

[nirmal_konchada · Accepted solution]

>

> ORA-00020: maximum number of processes (%s) exceeded
> BR0303E Determination of Oracle version failed

Hi,

I think you are using a 3rd party backup device.

Your error clearly says that there no more oracle processes available for your request.

Now you need to increase the no. of processes for oracle in initSID.ora file.

Regards,

Nirmal.K

[Former Member · Accepted solution]

Dear ,

Let me know how can we increase ...

as well any parameter needs to check ...

Kindly advise

[nirmal_konchada · Accepted solution]

>

> Dear ,
> 
> Let me know how can we increase ...
> 
> as well any parameter needs to check ...
> 
> Kindly advise

Hi,

Increase it in initSID.ora file.

Stop DB.

Then create a spfile from pfile.

Start DB.

Regards,

Nirmal.K

[Former Member · Accepted solution]

Hi,

You need to increase number of Oracle Process.

You can use brspace command to change its number.

syntax:

ora<sid>$brspace -f dbparam

After that, you need to restart your oracle database in order to activate your new parameter setting.

ardhian

http://sapbasis.wordpress.com

[Former Member]

Issue got resolved after increased Process and sessions ........