Skip to Content
author's profile photo Former Member
Former Member

CRM DB verified error

Dear Experts

We are getting below error in DB verified in CRM production system. Please help me to solve the issue.

Detail log: behquxon . dbv

BR0051I BRBACKUP 7.00 (40)

BR0169I Value 'online_cons' of parameter/option 'backup_type/-t' ignored for 'only_dbv' - 'online' assumed

BR0055I Start of database backup: behquxon.dbv 2012-01-14 08.59.57

BR0484I BRBACKUP log file: /oracle/KPC/sapbackup/behquxon.dbv

BR0252W Function remove() failed for '/oracle/KPC/112_64/dbs/sapKPC.ora' at location BrInitOraCopy-7

BR0253W errno 13: Permission denied

BR1304W Checking SAP license failed at location BrLicCheck-108

BR0602W No valid SAP license found - please contact SAP

BR0166I Parameter 'control_files' not found in file /oracle/KPC/112_64/dbs/initKPC.ora - default assumed

BR0274W File '/oracle/KPC/112_64/dbs/cntrlKPC.dbf' not found

BR0101I Parameters

Name Value

oracle_sid KPC

oracle_home /oracle/KPC/112_64

oracle_profile /oracle/KPC/112_64/dbs/initKPC.ora

sapdata_home /oracle/KPC

sap_profile /oracle/KPC/112_64/dbs/initKPC.sap

backup_mode ALL

backup_type online

compress no

exec_parallel 0

system_info kpwadm/kpwadm KCRMDBP SunOS 5.10 Generic_142900-13 sun4v

oracle_info KPC 11.2.0.2.0 8192 7795 215692208 KCRMDBP UTF8 UTF8

sap_info 701 SAPSR3 KPC TEMPLICENSE R3_ORA INITIAL

make_info sun_64 OCI_102 Feb 21 2009

command_line brbackup -u / -jid VERIF20120114085956 -c force -w only_dbv -p initKPC.sap -m ALL

BR0116I ARCHIVE LOG LIST before backup for database instance KPC

Parameter Value

Database log mode Archive Mode

Automatic archival Enabled

Archive destination LOCATION=/oracle/KPC/oraarch/KPCarch

Archive format %t_%s_%r.dbf

Oldest online log sequence 7780

Next log sequence to archive 7795

Current log sequence 7795 SCN: 215692208

Database block size 8192 Thread: 1

Current system change number 215699764 ResetId: 713878994

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize BlkSize

File Size Id. Device Link Type

/oracle/KPC/112_64/dbs/cntrlKPC.dbf 8192 0 0 NOLINK FILE

BR0616I Tablespaces in table TSORA for SAP owner SAPSR3:

PSAPSR3, PSAPSR3701, PSAPSR3USR

BR0280I BRBACKUP time stamp: 2012-01-14 08.59.59

BR0057I Backup of database: KPC

BR0058I BRBACKUP action ID: behquxon

BR0059I BRBACKUP function ID: dbv

BR0110I Backup mode: ALL

BR0077I Database files for backup:

BR0061I 30 files found for backup, total size 120474.234 MB

BR0143I Backup type: online

BR0140I Number of parallel copy processes: 4

BR0149I Only database verification using DBVERIFY - no backup

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0395I Verifying /oracle/KPC/sapdata3/sr3_10/sr3.data10 using DBVERIFY...

BR0395I Verifying /oracle/KPC/sapdata1/sr3701_8/sr3701.data8 using DBVERIFY...

BR0395I Verifying /oracle/KPC/sapdata2/undo_1/undo.data1 using DBVERIFY...

BR0395I Verifying /oracle/KPC/sapdata4/sr3701_3/sr3701.data3 using DBVERIFY...

BR0278E Command output of '/oracle/KPC/112_64/bin/dbv file=/oracle/KPC/sapdata3/sr3_10/sr3.data10 blocksize=8192':

DBVERIFY: Release 11.2.0.2.0 - Production on Sat Jan 14 09:00:00 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

DBV-00100: Specified FILE (/oracle/KPC/sapdata3/sr3_10/sr3.data10) not accessible

BR0280I BRBACKUP time stamp: 2012-01-14 09.00.00

BR0279E Return code from '/oracle/KPC/112_64/bin/dbv file=/oracle/KPC/sapdata3/sr3_10/sr3.data10 blocksize=8192': 1

BR0397E Verification of /oracle/KPC/sapdata3/sr3_10/sr3.data10 using DBVERIFY failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata3/sr3_11/sr3.data11 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata3/sr3_7/sr3.data7 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata3/sr3_8/sr3.data8 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata3/sr3701_6/sr3701.data6 failed due to previous errors

BR0278E Command output of '/oracle/KPC/112_64/bin/dbv file=/oracle/KPC/sapdata4/sr3701_3/sr3701.data3 blocksize=8192':

DBVERIFY: Release 11.2.0.2.0 - Production on Sat Jan 14 09:00:00 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

DBV-00100: Specified FILE (/oracle/KPC/sapdata4/sr3701_3/sr3701.data3) not accessible

BR0280I BRBACKUP time stamp: 2012-01-14 09.00.00

BR0279E Return code from '/oracle/KPC/112_64/bin/dbv file=/oracle/KPC/sapdata4/sr3701_3/sr3701.data3 blocksize=8192': 1

BR0397E Verification of /oracle/KPC/sapdata4/sr3701_3/sr3701.data3 using DBVERIFY failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata1/sr3_2/sr3.data2 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata3/sr3_9/sr3.data9 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata4/sr3701_2/sr3701.data2 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata4/sr3db_1/sr3db.data1 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata4/sr3db_2/sr3db.data2 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata4/sr3db_3/sr3db.data3 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata4/sr3db_4/sr3db.data4 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata4/sr3db_5/sr3db.data5 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata1/system_1/system.data1 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata1/system_2/system.data2 failed due to previous errors

BR0278E Command output of '/oracle/KPC/112_64/bin/dbv file=/oracle/KPC/sapdata1/sr3701_8/sr3701.data8 blocksize=8192':

DBVERIFY: Release 11.2.0.2.0 - Production on Sat Jan 14 09:00:00 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

DBV-00100: Specified FILE (/oracle/KPC/sapdata1/sr3701_8/sr3701.data8) not accessible

BR0280I BRBACKUP time stamp: 2012-01-14 09.00.00

BR0279E Return code from '/oracle/KPC/112_64/bin/dbv file=/oracle/KPC/sapdata1/sr3701_8/sr3701.data8 blocksize=8192': 1

BR0397E Verification of /oracle/KPC/sapdata1/sr3701_8/sr3701.data8 using DBVERIFY failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata1/sr3_1/sr3.data1 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata1/sr3_3/sr3.data3 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata1/sr3701_4/sr3701.data4 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata1/sr3701_9/sr3701.data9 failed due to previous errors

BR0278E Command output of '/oracle/KPC/112_64/bin/dbv file=/oracle/KPC/sapdata2/undo_1/undo.data1 blocksize=8192':

DBVERIFY: Release 11.2.0.2.0 - Production on Sat Jan 14 09:00:00 2012

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

DBV-00100: Specified FILE (/oracle/KPC/sapdata2/undo_1/undo.data1) not accessible

BR0280I BRBACKUP time stamp: 2012-01-14 09.00.00

BR0279E Return code from '/oracle/KPC/112_64/bin/dbv file=/oracle/KPC/sapdata2/undo_1/undo.data1 blocksize=8192': 1

BR0397E Verification of /oracle/KPC/sapdata2/undo_1/undo.data1 using DBVERIFY failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata2/sr3_4/sr3.data4 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata2/sr3_5/sr3.data5 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata2/sr3_6/sr3.data6 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata2/sr3701_5/sr3701.data5 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata4/sr3701_1/sr3701.data1 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata4/sr3701_7/sr3701.data7 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata2/sr3usr_1/sr3usr.data1 failed due to previous errors

BR0363E Verification of backup of /oracle/KPC/sapdata2/sysaux_1/sysaux.data1 failed due to previous errors

BR0223E Last copy process failed

BR0056I End of database backup: behquxon.dbv 2012-01-14 09.00.00

BR0280I BRBACKUP time stamp: 2012-01-14 09.00.01

BR0054I BRBACKUP terminated with errors

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Jan 14, 2012 at 06:24 AM

    Hi Darshan,

    BR0252W Function remove() failed for '/oracle/KPC/112_64/dbs/sapKPC.ora' at location BrInitOraCopy-7 BR0253W errno 13: Permission denied BR1304W Checking SAP license failed at location BrLicCheck-108 BR0602W No valid SAP license found - please contact SAP BR0166I Parameter 'control_files' not found in

    Could you update brtools to 7.20 version and check again.

    Regards,

    Deepak Kori

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 14, 2012 at 09:25 AM

    Hello,

    The key error is

    DBV-00100: Specified FILE (<name>) not accessible

    At first sight I think that the BRBACKUP is running under the "kpcadm" user and that the Set user ID flag has not been set to always make it run as orakpc. Can you do the following:

    su - kpcadm
    cdexe
    ls -l br*

    The owner of brbackup (and also brarchive and brconnect) must be "orakpc", not "kpcadm". Also the security mask (leftmost group of letters) must begin with "rws...", not "rwx...". If this is not the case then do the following:

    (still as kpcadm)
    su - root
    /sapmnt/KPC/exe/saproot.sh KPC
    exit

    Check again: the ownership and security should now be correct.

    Hope this helps,

    Mark

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.