on 04-19-2010 12:56 PM
Hi all,
I am facing error when I am trying to use RMAN backup using brtools. I am using veritas netbackup using a tape library. I can do the Oracle traditional backup for online as well as offline. but when I am trying to do RMAN prep I am encountering the following problem, can any body help?
Menu:
BRBACKUP options for RMAN preparation
1 - BRBACKUP profile (profile) ...... [initPIB.sap]
2 - Database user/password (user) ... [/]
3 - BRBACKUP run type (type) ........ [online]
4 ~ Files for preparation (mode) .... [all]
5 - Confirmation mode (confirm) ..... [yes]
6 - Query mode (query) .............. [no]
7 - Parallel execution (execute) .... [0]
8 - Additional output (output) ...... [no]
9 - Message language (language) ..... [E]
10 - BRBACKUP command line (command) . [-p initPIB.sap -d rman_prep -t online -m all -e 0 -l E]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2010-04-19 17.11.50
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRBACKUP will be started with options '-p initPIB.sap -d rman_prep -t online -m all -e 0 -l E'
BR0280I BRTOOLS time stamp: 2010-04-19 17.11.50
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2010-04-19 17.11.51
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
Output:
###############################################################################
BR0051I BRBACKUP 7.00 (42)
BR0055I Start of database backup: bedavblv.rmp 2010-04-19 17.11.51
BR0484I BRBACKUP log file: /oracle/PIB/sapbackup/bedavblv.rmp
BR0477I Oracle pfile /oracle/PIB/102_64/dbs/initPIB.ora created from spfile /oracle/PIB/102_64/dbs/spfilePIB.ora
BR0280I BRBACKUP time stamp: 2010-04-19 17.11.52
BR0057I Backup of database: PIB
BR0058I BRBACKUP action ID: bedavblv
BR0059I BRBACKUP function ID: rmp
BR0110I Backup mode: ALL
BR0077I Database file for backup: /oracle/PIB/origlogA/cntrl/cntlrPIB.dbf
BR0061I 25 files found for backup, total size 89630.766 MB
BR0143I Backup type: online
BR0130I Backup device type: rman_prep
BR0523I Preparation for using RMAN only - no backup
BR0140I Number of parallel copy processes: 2
BR0280I BRBACKUP time stamp: 2010-04-19 17.11.52
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:
c
BR0280I BRBACKUP time stamp: 2010-04-19 17.11.53
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0280I BRBACKUP time stamp: 2010-04-19 17.11.54
BR1390I RMAN prepared for backup
BR0525I Preparing backup of /oracle/PIB/sapdata1/undo_1/undo.data1 using RMAN...
BR0525I Preparing backup of /oracle/PIB/sapdata3/sr3700_4/sr3700.data4 using RMAN...
BR0278E Command output of 'BRSBTLIB':
#LOCK /oracle/PIB/sapbackup/.lock.brb
#CMD /usr/sap/PIB/SYS/exe/run/brtools -f rmanprep - 9563021312 0
BR0280I BRBACKUP time stamp: 2010-04-19 17.16.22
BR0279E Return code from 'SHELL=/bin/sh /oracle/PIB/102_64/bin/rman nocatalog': 0
BR0536E RMAN call for database instance PIB failed
BR0280I BRBACKUP time stamp: 2010-04-19 17.16.22
BR0524E Preparation of database backup using RMAN failed
BR0526E Preparation of backup of /oracle/PIB/sapdata1/undo_1/undo.data1 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata2/sr3_1/sr3.data1 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata2/sr3_2/sr3.data2 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata2/sr3_3/sr3.data3 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata2/sr3_4/sr3.data4 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata2/sr3_5/sr3.data5 using RMAN failed due to previous errors
BR0278E Command output of 'BRSBTLIB':
#LOCK /oracle/PIB/sapbackup/.lock.brb
#CMD /usr/sap/PIB/SYS/exe/run/brtools -f rmanprep - 4466941952 0
BR0280I BRBACKUP time stamp: 2010-04-19 17.17.42
BR0279E Return code from 'SHELL=/bin/sh /oracle/PIB/102_64/bin/rman nocatalog': 0
BR0536E RMAN call for database instance PIB failed
BR0280I BRBACKUP time stamp: 2010-04-19 17.17.42
BR0524E Preparation of database backup using RMAN failed
BR0526E Preparation of backup of /oracle/PIB/sapdata3/sr3700_4/sr3700.data4 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata2/sr3_6/sr3.data6 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata2/sr3_7/sr3.data7 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata2/sr3_8/sr3.data8 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata3/sr3700_1/sr3700.data1 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata3/sr3700_2/sr3700.data2 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata3/sr3700_3/sr3700.data3 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata3/sr3700_5/sr3700.data5 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata3/sr3700_6/sr3700.data6 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata3/sr3700_7/sr3700.data7 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata3/sr3700_8/sr3700.data8 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata4/sr3db_1/sr3db.data1 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata4/sr3db_2/sr3db.data2 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata4/sr3db_3/sr3db.data3 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata4/sr3usr_1/sr3usr.data1 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata1/temp_1/temp.data1 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata1/sysaux_1/sysaux.data1 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/sapdata1/system_1/system.data1 using RMAN failed due to previous errors
BR0526E Preparation of backup of /oracle/PIB/origlogA/cntrl/cntlrPIB.dbf using RMAN failed due to previous errors
BR0223E Last copy process failed
BR0056I End of database backup: bedavblv.rmp 2010-04-19 17.17.43
BR0280I BRBACKUP time stamp: 2010-04-19 17.17.45
BR0054I BRBACKUP terminated with errors
6 - Query mode (query) .............. \[no\]
Try with yes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear soumen,
Please go through the ote 919588 - Offline backup with RMAN fails. or try to update your brtools with latest patch and then try running the same.
Regards,
Kishore
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Kishore,
I have checked note 919588. In my case, the database yet not a very large database, size within 100GB and about 30 data files. so I don't know whether still my case similar as indicated in note. Because in the note it says,
"In the case of large databases containing several hundred files, the command requires correspondingly large sorting areas...."
And secondly, forgive my ignorance where do I set this parameter BR_SAS? in init<SID>.ora/spfile<SID>.ora or init<SID>.sap? or somewhere else?
Regards,
Soumen.
Dear Darshan,
I feel this is going to a wrong direction, R3Trans is showing me problem as this was run from ORA<SID> .
If the same command is executed from SID<ADM> it does not give any problem.
I was trying to execute RMAN using BRTools and I am executing the BRTools from ORA<SID>. As for traditional hot backup also I am using BRTools from ORA<SID>.
I am not sure whether this is the cause? And this should not be because, traditional backup goes fine.
Regards,
Soumen.
Hi,
What are the permissions of BRTools (brbackup, brarchive, brspace, brrestore, brtools)
Check as per the below note:
[113747 - Permissions for DBA tools BRTools and SAPDBA|https://service.sap.com/sap/support/notes/113747]
It is necessary to have correct permissions set on BRTools for taking backup using other tools (such as RMAN).
Regards.
Rajesh Narkhede
Dear Soumen,
I feel this is going to a wrong direction, R3Trans is showing me problem as this was run from ORA<SID> .
If the same command is executed from SID<ADM> it does not give any problem.
Try BRtools with <SID>adm user definitely it will be successfull. & Problem of R3trans with ORASID is because of OPS$ Mechanism.
If getting permission problem run from Kernel
sqlplus /nolog @sapdba_role.sql <SID> or SR3 i.e whatever your SCHEMA SAPSID or SAPSR3 & check logs should not be contain any error.
Note 400241for ops$ & some more notes are attached with it are helpfull for the same.
361641 - Creating OPS$ users on UNIX
BR,
Darshan..
Does the .lock.brb file exists when brbackup is not active? If so, delete it and restart the backup..
Kind regards,
Mark
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.