cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

RMAN prep using BRBackup is giving error

former_member211629
Explorer

on ‎04-19-2010 12:56 PM

0 Kudos

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

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
‎04-22-2010 12:59 PM
0 Kudos 
6 - Query mode (query) .............. \[no\]

Try with yes.

Show replies
Show replies
kishore_soma
Active Participant
‎04-20-2010 6:30 AM
0 Kudos

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

Show replies
Show replies
former_member211629
Explorer
‎04-20-2010 10:57 AM
0 Kudos

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.

Former Member
‎04-20-2010 11:53 AM
0 Kudos

Dear Soman,

Check R3trans -d with user by which you are starting brbackup.

If got error send it.

BR,

Darshan..

former_member211629
Explorer
‎04-21-2010 9:30 AM
0 Kudos

Dear Darshan,

I am executing brtools from ORA<SID> user. SID is PIB.

R3Trans -d is giving following output

This is R3trans version 6.14 (release 700 - 10.02.10 - 13:32:00).

unicode enabled version

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'PIB'"

Regards,

Soumen

Former Member
‎04-21-2010 12:08 PM
0 Kudos

Dear Soumen,

2EETW169 no connect possible: "DBMS = ORACLE --- dbs_o

ra_tnsname = 'PIB'"

Send me total error Log from trans.log file.

BR,

Darshan

former_member211629
Explorer
‎04-22-2010 4:56 AM
0 Kudos

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.

Former Member
‎04-22-2010 5:26 AM
0 Kudos

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

former_member211629
Explorer
‎04-22-2010 8:16 AM
0 Kudos

Permissions here is fine and according to the note

Former Member
‎04-22-2010 9:11 AM
0 Kudos

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..

Former Member
‎04-19-2010 1:47 PM
0 Kudos

Does the .lock.brb file exists when brbackup is not active? If so, delete it and restart the backup..

Kind regards,

Mark

Show replies
Show replies
former_member211629
Explorer
‎04-20-2010 9:36 AM
0 Kudos

Dear Mark,

lock.brb file does not exits when brbackup is not executed.

kishore_soma
Active Participant
‎04-20-2010 10:44 AM
0 Kudos

Hi,.

lock.brb file is automatically deleted once brbackup is compleetd successfully or unsuccessfully.

So pls check the note which i have told. Its not related to lock.brb issue.

Regards,

Kishore

Ask a Question