Error creating control backup file

[former_member279907]

Hi, Everybody!

During the online backup, I got the following error:

BR0051I BRBACKUP 7.20 (20)

BR0055I Start of database backup: bepflgbo.and 2014-11-19 06.00.56

BR0484I BRBACKUP log file: /oracle/<SID>/sapbackup/bepflgbo.and

BR0477I Oracle pfile /oracle/<SID>/112_64/dbs/init<SID>.ora created from spfile /oracle/<SID>/112_64/dbs/spfile<SID>.or a

BR0280I BRBACKUP time stamp: 2014-11-19 06.01.17

BR0301E SQL error -1580 at location BrCtlCopy-1, SQL statement:

'/* BRBACKUP */ ALTER DATABASE BACKUP CONTROLFILE TO '/oracle/<SID>/sapbackup/cntrl<SID>.dbf' '

ORA-01580: error creating control backup file /oracle/<SID>/sapbackup/cntrl<SID>.dbf

ORA-27086: unable to lock file - already in use

Linux-x86_64 Error: 5: Input/output error

Additional information: 9

Additional information: 5

BR0320E Copying of control file to /oracle/<SID>/sapbackup/cntrl<SID>.dbf failed

BR0314E Collection of information on database files failed

BR0056I End of database backup: bepflgbo.and 2014-11-19 06.01.17

BR0280I BRBACKUP time stamp: 2014-11-19 06.01.17

BR0054I BRBACKUP terminated with errors

BR0280I BRBACKUP time stamp: 2014-11-19 06.01.17

BR0291I BRARCHIVE will be started with options '+bepflgbo.and -U -jid ALLOG20130703060000 -c force -p init<SID>.sap -sd'

BR0280I BRBACKUP time stamp: 2014-11-19 06.07.27

BR0292I Execution of BRARCHIVE finished with return code 0

All that I found on this issue did not help me. Has anyone faced a similar error?

[former_member279907 · Accepted solution]

Hi, everyone!

Thank you for your answers.But the problem was solved by updating to the latest service NSF firmware.

BR,

Anton Romanyuk.

[former_member185239]

Hi Anton,

open the file /etc/filesystem and make the parameter option=nolock

On the databse server :

--Run the below command to unlock the NFS

clear_locks -s <nfs server hostname>

--Run the comamnd on NFS server

clear_locks <db_host_name>

Aslo do paste the output , it will be better to take the help of unix team

With Regards

Ashutosh Chaturvedi

[former_member182657]

Hi Anton,

After restarting still you're getting the same error Error

ORA-27086: unable to lock file - already in use

Please confirm and share the output result from command

service nfslock status .Try to start the nfslock in case shows off (service nfslock start) and try to perform the backup again.

Hope this will help you.

Regards,

Gaurav

[former_member279907]

Hi, Gaurav.

# service nfslock status

rpc.statd (pid  31503) is running...

# service nfslock start

Perferm tha backup again.

It did not help. Error is not corrected

[former_member182657]

Hi Anton,

Share the status after execution of OS command /etc/init.d/nfs restart

Regards,

Gaurav

[former_member279907]

Hi, Gaurav

     # /etc/init.d/nfs restart

Shutting down NFS mountd:                                  [FAILED]

Shutting down NFS daemon:                                  [FAILED]

Shutting down NFS quotas:                                  [FAILED]

Starting NFS services:                                     [  OK  ]

Starting NFS quotas:                                       [  OK  ]

Starting NFS daemon:                                       [  OK  ]

Starting NFS mountd:                                       [  OK  ]

     # /etc/init.d/nfs restart

Shutting down NFS mountd:                                  [  OK  ]

Shutting down NFS daemon:                                  [  OK  ]

Shutting down NFS quotas:                                  [  OK  ]

Shutting down NFS services:                                [  OK  ]

Starting NFS services:                                     [  OK  ]

Starting NFS quotas:                                       [  OK  ]

Starting NFS daemon:                                       [  OK  ]

Starting NFS mountd:                                       [  OK  ]

BR,

Anton Romanyuk

[former_member207186]

Hi Anton,

ORA-27086 basically indicates that a file is already locked by another process that is currently in use. Have you checked this?

Regards,
Bíborka

[former_member279907]

Biborka Greta Toth,

I checked it with command:

# lsof | grep cntrlASD.dbf

and got:

oracle     1169    oraasd  256u      REG               8,33    21577728    9175422 /oracle/ASD/origlogA/cntrl/cntrlASD.dbf

oracle     1169    oraasd  257u      REG               8,33    21577728    9175423 /oracle/ASD/origlogB/cntrl/cntrlASD.dbf

oracle     1169    oraasd  258u      REG               8,33    21577728    9175424 /oracle/ASD/sapdata1/cntrl/cntrlASD.dbf

oracle     4787    oraasd  256u      REG               8,33    21577728    9175422 /oracle/ASD/origlogA/cntrl/cntrlASD.dbf

oracle     4787    oraasd  257u      REG               8,33    21577728    9175423 /oracle/ASD/origlogB/cntrl/cntrlASD.dbf

oracle     4787    oraasd  258u      REG               8,33    21577728    9175424 /oracle/ASD/sapdata1/cntrl/cntrlASD.dbf

oracle     6043    oraasd  256u      REG               8,33    21577728    9175422 /oracle/ASD/origlogA/cntrl/cntrlASD.dbf

oracle     6043    oraasd  257u      REG               8,33    21577728    9175423 /oracle/ASD/origlogB/cntrl/cntrlASD.dbf

.......

What I must to do ?

[Former Member]

Hi,

this is an intriguing post. It is interesting that lsof lists several repeated files such as:-

/oracle/ASD/origlogA/cntrl/cntrlASD.dbf

As a matter of interest:-

Your backup is not running? run 'ps -ef | grep back' to confirm this.

There is no .lck.brb in your sapbackup directory? run ls -ltra .lck* to confirm this.

BR Mark

[former_member188883]

Hi Anton,

Do you have /oracle/<SID>/sapbackup on  NFS mount. If yes, the error may be due to NFS hang.

You may restart the NFS service and check the results.

Regards,

Deepak Kori

[former_member279907]

Deepak Kori,

Yes. /oracle/<SID>/sapbackup on  NFS mount. I will restart the NFS and reply you.

BR,

Anton Romanyuk.

[Former Member]

If that doesn't help, then take a complete server restart.

Follow the below link.

ORA-27085 Tips

regards,

pavan

[former_member279907]

Deepak Kori,

Rebooting the NFS did not help.

[former_member182657]

Hi Anton,

Error ORA-27086: unable to lock file - already in use

Not related with the database,this could be related with OS either you are using NFS or file is locked by some other processes.

For that try to reboot the complete system and check again.Also confirm are you using NFS ?

Regards,

Gaurav

[former_member279907]

Hi, Gaurav!

Yes, I am using NFS. Rebooting the system did not help.

BR,

Anton.

[former_member182657]

Hi,

Could you check with permissions on ORACLE_HOME,if possible try to restart the system and check again.

Regards,

Gaurav

[former_member279907]

Gaurav Rana,

I checked permissions on ORACLE_HOME. Everything is all right. Restart the system. Error still occurs.

BR,

Anton Romanyuk.

[srinivasan_vinayagam]

Hi Anton,

Check the backup drive space sapbackup and permission also - permission for ORASID and SIDADM user..

Regards,

V Srinivasan

[former_member279907]

Srinivasan Vinayagam,

Everything is all right with space and permissions.

BR,

Anton Romanyuk.