cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Note 23345 for Oracle Consistency Check

Former Member
0 Kudos

Dear All,

I would like to run a Consistency check using backup type = online option via DB VERIFY but unfortunately each time I run the backup online using the below commands I am getting permission error.I have run the commands below using ORA<SIDADM>

brbackup -u / -m all -w only_rmv -e <parallel degree> -c

brbackup -u / -m all only_dbv -c -t online -e 3

brbackup -u / -m all -w only_dbv -e 3 -c

brbackup -u / -c force -w only_dbv -t online -p init<sidadm>.sap -m ALL -e 3

brbackup -u / -c force -w only_dbv -p init<sidadm>.sap -m ALL

I hope someone could provide what is the best command to use in order to execute the Consistency check in Online mode as I am planning to schedule it on weekly basis with the Online option..

Thank you.

Regards,

John

Accepted Solutions (0)

Answers (1)

Answers (1)

markus_doehr2
Active Contributor
0 Kudos

Make sure the br*tools have the sticky bit set on Unix (exeucte ./saproot.sh <SID>).

Markus

Former Member
0 Kudos

I have done that but still its not functioning.

What do I do next.

Regards,

John

former_member182505
Contributor
0 Kudos

Hi

Check your brtool version

if it is old then update it and try,

thanks

sadiq

Former Member
0 Kudos

BRTOOLS been updated couple of days back, any other ideas ?

Former Member
0 Kudos

BRTOOLS been updated couple of days back, any other ideas ?

Regards,

John

sivakumar_kilari3
Active Contributor
0 Kudos

Can you paste the logs here.

Siva

Former Member
0 Kudos

Hi All,

The logs are as below:-

oraias> brbackup -u / -c force -w only_dbv -t online -p initXXX.sap -m ALL -e 3

BR0051I BRBACKUP 7.20 (3)

BR0055I Start of database backup: befkxxxx.dbv 2011-03-14 04.13.04

BR0484I BRBACKUP log file: /oracle/XXX/sapbackup/befkxxxx.dbv

BR0477I Oracle pfile /oracle/XXX/112_64/dbs/initXXX.ora created from spfile /oracle/XXX/112_64/dbs/spfileXXX.ora

BR0280I BRBACKUP time stamp: 2011-03-14 04.13.09

BR0057I Backup of database: XXX

BR0058I BRBACKUP action ID: befkxxxx

BR0059I BRBACKUP function ID: dbv

BR0110I Backup mode: ALL

BR0077I Database files for backup:

BR0061I 24 files found for backup, total size 64018.188 MB

BR0143I Backup type: online

BR0140I Number of parallel copy processes: 3

BR0149I Only database verification using DBVERIFY - no backup

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

BR0395I Verifying /oracle/XXX/sapdata4/xxx_14/xxx.data14 using DBVERIFY...

BR0395I Verifying /oracle/XXX/sapdata2/xxx_2/xxx.data2 using DBVERIFY...

BR0395I Verifying /oracle/XXX/sapdata2/xxx_6/xxx.data6 using DBVERIFY...

BR0278E Command output of '/oracle/XXX/112_64/bin/dbv file=/oracle/XXX/sapdata2/xxx_6/xxx.data6 blocksize=8192':

DBVERIFY: Release 11.2.0.1.0 - Production on Mon Mar 14 04:13:10 2011

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

DBV-00100: Specified FILE (/oracle/XXX/sapdata2/xxx_6/xxx.data6) not accessible

BR0280I BRBACKUP time stamp: 2011-03-14 04.13.10

BR0279E Return code from '/oracle/XXX/112_64/bin/dbv file=/oracle/XXX/sapdata2/xxx_6/xxx.data6 blocksize=8192': 1

BR0397E Verification of /oracle/XXX/sapdata2/xxx_6/xxx.data6 using DBVERIFY failed due to previous errors

BR0363E Verification of backup of /oracle/XXX/sapdata2/xxx_11/xxx.data11 failed due to previous errors

BR0363E Verification of backup of /oracle/XXX/sapdata2/xxx_5/xxx.data5 failed due to previous errors

BR0363E Verification of backup of /oracle/XXX/sapdata2/xxx_7/xxx.data7 failed due to previous errors

BR0363E Verification of backup of /oracle/XXX/sapdata2/xxx_8/xxx.data8 failed due to previous errors

BR0363E Verification of backup of /oracle/XXX/sapdata1/undo_1/undo.data1 failed due to previous errors

BR0363E Verification of backup of /oracle/XXX/sapdata1/system_1/sysaux01.dbf failed due to previous errors

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

BR0278E Command output of '/oracle/XXX/112_64/bin/dbv file=/oracle/XXX/sapdata2/xxx_2/xxx.data2 blocksize=8192':

[stuff deleted]

BR0056I End of database backup: befkxxxx.dbv 2011-03-14 04.13.10

BR0280I BRBACKUP time stamp: 2011-03-14 04.13.11

BR0054I BRBACKUP terminated with errors

Edited by: Eric Brunelle on Mar 14, 2011 9:42 AM

sivakumar_kilari3
Active Contributor
0 Kudos

Read these threads.

[;

[;

Regards

Siva

former_member204746
Active Contributor
0 Kudos

Hi,

add user sidadm part of Unix group "dba".

then, try again.