on 03-11-2011 11:33 AM
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
Make sure the br*tools have the sticky bit set on Unix (exeucte ./saproot.sh <SID>).
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.