Error after restore and recovery - during backups

[Former Member]

Hi All,

After Restor/Recovery of whole database online backup, when i am scheduling Whole database online + redo log backup, i am facing following error, the files /oracle/CDV/102_64/dbs/sap.ora and /oracle/CDV/102_64/dbs/initCDV.ora was not exist before restore and recovery. and Before recovery Whole database online + redo log backup was working very nicly.

=====Error==========================================================================================

BR0252W Function remove() failed for '/oracle/CDV/102_64/dbs/sap.ora' at location BrInitOraCreate-1

BR0253W errno 13: Permission denied

BR0252W Function remove() failed for '/oracle/CDV/102_64/dbs/sap.ora' at location BrInitOraCopy-7

BR0253W errno 13: Permission denied

BR0166I Parameter 'control_files' not found in file /oracle/CDV/102_64/dbs/initCDV.ora - default assumed

BR0017E Offline redo log file '/oracle/CDV/102_64/dbs/arch1_64_611979793.dbf' not found

===================================================================================================

Waiting for your kind response.

Thanks and Regards

K R Singh.

[Former Member]

Dear Karmesh

Please change the subdirectory permissions.

I don't know it is helful.

Best Regards

JangHyun.

[Former Member]

Hi all,

Everything i have checked from prvious backup, file system permission, create spfile from pfile and visa versa but still i am facing same problem.

================================================================

BR0252W Function remove() failed for '/oracle/CDV/102_64/dbs/sap.ora' at location BrInitOraCreate-1

BR0253W errno 13: Permission denied

BR0252W Function fopen() failed for '/oracle/CDV/102_64/dbs/initCDV.ora' at location BrInitOraCopy-2

================================================================

Can anyone tell me what is the meaning of sap.ora file, when it is use and how it is created automatically,

i am facing this problem when i am scheduling backup using db13 or check database etc.

Please do the needful to resolve this issue

Thanks and Regards,

K R singh

[Former Member]

Hello,

Have you checked the authorizations of the BR* tools?

look at note <a href="http://service.sap.com/sap/support/notes/113747">113747</a>

[Former Member]

Hi Cheery,

Pleae check the few lines from arch<SID>.log file

#DISK..... 62 /oracle/CDV/oraarch/CDVarch1_62_611979793.dbf 2007-01-16 20.45.00 31416320 35500290 1

#DISKSAV.. adukenbk sve /devbkp/offarch/CDVarch1_62_611979793.dbf.Z 2007-01-17 02.52.37 3.2812:1 9574751

#DISKDEL.. ........ ... .......... ........

#DELDISK.. ........ ... .......... ........

#

#DISK..... 63 /oracle/CDV/oraarch/CDVarch1_63_611979793.dbf 2007-01-17 01.02.19 44118528 35502886 1

#DISKSAV.. adukenbk sve /devbkp/offarch/CDVarch1_63_611979793.dbf.Z 2007-01-17 02.52.44 2.8810:1 15313463

#DISKDEL.. ........ ... .......... ........

#DELDISK.. ........ ... .......... ........

#

#DISK..... 64 /oracle/CDV/oraarch/CDVarch1_64_611979793.dbf 2007-01-17 02.48.53 34641920 35527299 1

#DISKSAV.. adukenbk sve /devbkp/offarch/CDVarch1_64_611979793.dbf.Z 2007-01-17 02.52.49 1.8863:1 18365283

#DISKDEL.. ........ ... .......... ........

#DELDISK.. ........ ... .......... ........

#

• CDV disk adukenbk sve 2007-01-17 02.48.56 2007-01-17 02.52.50 1 3.0310:1 21 64 0 0 ---kw-c 7.00 (18) @0611979793

#

i went through SAP note# and get same solution which one is given by you, what i am thinking instead of removing some lines from arch<SID>.log if i rename this file then will it work, means SAP/Oracle will create this file itself.

Thanks and Regards

K R Singh

[Former Member]

Hi,

Whether CDVarch1_64_611979793.dbf is physically available on the system?

You can try that,but i doubt.Make sure to backup the respective log files before doing any changes so that you revert back all the changes.

Please update me once you do that.

Regards,

cherry

[Former Member]

Can you UNCAR(unzip) CDVarch1_64_611979793.dbf.Z file and try.

Regards,

Sam

[Former Member]

Here the error is

BR0017E Offline redo log file '/oracle/CDV/102_64/dbs/arch1_64_611979793.dbf' not found , all the rest are Warnings & Info.

can you please check the logs in /oracle/<SID>/sapbackup?

I think if you edit the last entries in arch<SID>.log in /oracle/<SID>/saparch you can get rid of the error.

send me the last entries of arch<SID>.log in /oracle/<SID>/saparch

Regards,

Cherry