Skip to Content
avatar image
Former Member

RMAN prep using BRBackup is giving error

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 19, 2010 at 12:47 PM

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

    Kind regards,

    Mark

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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

  • avatar image
    Former Member
    Apr 20, 2010 at 05:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

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

  • avatar image
    Former Member
    Apr 22, 2010 at 11:59 AM

    6 - Query mode (query) .............. \[no\]

    Try with yes.

    Add comment
    10|10000 characters needed characters exceeded