networker:SAP backup problems

Question

hi,all: I had a problem On SAP module.Backup database and rachive both Not normal.It is normal before. Userd ORACLE rman backup is Normal completion.Who can help me. thanks! The following is the log. ============================= /usr/bin/nsrsapsv: Jul 27 16:58:39Running backup process as user oradevspawning brarchive process as user oradev ...BR0002I BRARCHIVE 7.00 (18)BR0006I Start of offline redo log processing: aedtnefw.cds 2010-07-27 16.58.40BR0477I Oracle pfile /oracle/DEV/102_64/dbs/initDEV.ora created from spfile /oracle/DEV/102_64/dbs/spfileDEV.ora BR0280I BRARCHIVE time stamp: 2010-07-27 16.58.40BR0008I Offline redo log processing for database instance: DEVBR0009I BRARCHIVE action ID: aedtnefwBR0010I BRARCHIVE function ID: cdsBR0048I Archive function: copy_delete_saveBR0011I 8 offline redo log files found for processing, total size 347.392 MBBR0112I Files will not be compressedBR0130I Backup device type: rman_utilBR0134I Unattended mode with 'force' active - no operator confirmation allowed BR0280I BRARCHIVE time stamp: 2010-07-27 16.58.40BR0541I Starting offline redo log backup using RMAN... BR0280I BRARCHIVE time stamp: 2010-07-27 16.58.44BR0202I Saving /oracle/DEV/oraarch/DEVarch1_15855_631477950.dbf BR0280I BRARCHIVE time stamp: 2010-07-27 16.58.44BR0202I Saving /oracle/DEV/oraarch/DEVarch1_15856_631477950.dbf BR0280I BRARCHIVE time stamp: 2010-07-27 16.58.44BR0202I Saving /oracle/DEV/oraarch/DEVarch1_15857_631477950.dbf BR0280I BRARCHIVE time stamp: 2010-07-27 16.58.44BR0202I Saving /oracle/DEV/oraarch/DEVarch1_15858_631477950.dbfBR0278E Command output of 'SHELL=/bin/sh /oracle/DEV/102_64/bin/rman nocatalog': Recovery Manager: Release 10.2.0.2.0 - Production on Tue Jul 27 16:58:40 2010 Copyright (c) 1982, 2005, Oracle.  All rights reserved. RMAN> RMAN> connect target *connected to target database: DEV (DBID=3709816766)using target database control file instead of recovery catalog RMAN> **end-of-file** RMAN> host command complete RMAN> 2> 3> 4> 5> Reverse DNS lookup failed for address 10.10.10.11allocated channel: sbt_1channel sbt_1: sid=39 devtype=SBT_TAPEchannel sbt_1: NMO v4.5.0.0 Starting backup at 27-JUL-10channel sbt_1: starting archive log backupsetchannel sbt_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=15855 recid=15028 stamp=724950016input archive log thread=1 sequence=15856 recid=15029 stamp=724958029input archive log thread=1 sequence=15857 recid=15030 stamp=724997688input archive log thread=1 sequence=15858 recid=15031 stamp=725022034channel sbt_1: starting piece 1 at 27-JUL-10RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03009: failure of backup command on sbt_1 channel at 07/27/2010 17:01:09RMAN-10038: database session for channel sbt_1 terminated unexpectedly RMAN> List of Backup Sets=================== BS Key  Size       Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------14845   174.75M    SBT_TAPE    00:00:26     22-JUL-10              BP Key: 14845   Status: AVAILABLE  Compressed: NO  Tag: AEDSNORO        Handle: DEV_aedsnoro.14979_1   Media: 000023L3   List of Archived Logs in backup set 14845  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time  ---- ------- ---------- --------- ---------- ---------  1    15855   30960370125 21-JUL-10 30960372598 21-JUL-10  1    15856   30960372598 21-JUL-10 30960384392 21-JUL-10  1    15857   30960384392 21-JUL-10 30960416784 22-JUL-10  1    15858   30960416784 22-JUL-10 30960439579 22-JUL-10 BS Key  Size       Device Type Elapsed Time Completion Time------- ---------- ----------- ------------ ---------------14846   173.00M    SBT_TAPE    00:00:13     22-JUL-10              BP Key: 14846   Status: AVAILABLE  Compressed: NO  Tag: AEDSNORO        Handle: DEV_aedsnoro.14980_1   Media: 000023L3   List of Archived Logs in backup set 14846  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time  ---- ------- ---------- --------- ---------- ---------  1    15851   30960303736 21-JUL-10 30960360767 21-JUL-10  1    15852   30960360767 21-JUL-10 30960365436 21-JUL-10  1    15853   30960365436 21-JUL-10 30960367712 21-JUL-10  1    15854   30960367712 21-JUL-10 30960370125 21-JUL-10 RMAN> Recovery Manager complete.BR0280I BRARCHIVE time stamp: 2010-07-27 17.01.10BR0279E Return code from 'SHELL=/bin/sh /oracle/DEV/102_64/bin/rman nocatalog': 1BR0522E 4 of 8 files/save sets processed by RMANBR0536E RMAN call for database instance DEV failed BR0280I BRARCHIVE time stamp: 2010-07-27 17.01.10BR0543E Offline redo log backup using RMAN failed BR0016I 0 offline redo log files processed, total size 0.000 MB BR0007I End of offline redo log processing: aedtnefw.cds 2010-07-27 17.01.10BR0280I BRARCHIVE time stamp: 2010-07-27 17.01.11BR0005I BRARCHIVE terminated with errors ==================

vsampy · Answer

Hello,

I see the following in the information provided (Reverse DNS lookup failed for address 10.10.10.11)
Please add the hostname and IP addresses to both the client and Networker Server's /etc/hosts files.
Is there any information in the backint .raw?

100x · Answer

Thanks. This is a useless DNS. The machine is running normally is also reported this error .

mofo · Answer

First, what has changed in your environment since 21st and 27nd of July, that might have caused this error?

Second, if I understood correctly, "plain" RMAN backup is working, however RMAN started from BR*Tools is failing? If this is the case, please check your *cfg, *utl and *sap scripts for this database, especially check files that had their timestamps changed since July 21st - this might point you to right direction.

Third, as this is rman_util type of backup, there should be no backint logs, since BR*Tools calls RMAN directly. Check all the latest logs on the NetWorker Client in /nsr/applogs and /nsr/logs folders, they might be more verbose about what is failing and where.

vsampy · Answer

Hi,

You could also add some debugging parameters to the rman script:

rman_parms="ENV=(NSR_SERVER=backupservername, NSR_CLIENT=sapClientname, NSR_DEBUG_FI

LE=/nsr/applogs/sap.log, NSR_DEBUG_LEVEL=9)"

The above will provide some more details on the backups failing, moving us on to our next suggestion.

mofo · Answer

Hi, just perhaps to expand for clarity, these parameters should be set in your "regular" Oracle RMAN backups.

If you are using NetWorker Module for SAP with RMAN then brbackup assembles RMAN script dynamically and I haven't found a way to manipulate brbackup into changing parameters of RMAN script. But, that's something where SAP support might be of more help.

jstamp · Answer

Hello,

As per my collegues, this issue may require further clarity and some troubleshooting.

Please try to run rman separately first, using the same user that got the error.

Let us know the result.

Also please ensure that the proper enironment variables are in place.

e.g.

ORACLE_HOME

ORACLE_BASE

ORACLE_SID

LD_LIBRARY PATH

…

Thanks.

100x · Answer

1) need to check the connectivity as well as name resolution .use 'rpcinfo - p hostname' is OK, 'save -s backupserver' is OK.2) What about 10.10.10.11 ?This is a useless DNS.The machine is running normally is also reported this error.Use RMAN backup is Normal,also reported this failed In the beginning.3) what abotu if it just test allocate channel & release channel by themselves? TEST channel is OK,use 'sbttest libobk' is OK.use ORACLE RMAN is ok.4) What about File System backup ? ok.5) Any changes recently or this a new installation? Installed EMC DPA.users say the password of SAP Was changed,But this account is not a system account ,and not oracle account.I do not know the role of the SAP user6) enable debug level in RMAN script while the failure generated @ RMAN .I Modify the 'init .utl' File ,Made some changes As follows: # Default Value: /nsr/applogs on Unix and # C:\program files\Legato
sr\applogs on Windows. # Valid Values: any valid directory name with proper permission. # Directory name of backint debug log files. # # NSR_DEBUG_DIR = c:\PROGRA~1\legato
sr\applogs NSR_DEBUG_DIR = /nsr/applogs Default Value = 9 But there is no effect.

100x · Answer

BR0051I BRBACKUP 7.00 (18)BR0055I Start of database backup: beduvrln.anr 2010-08-03 17.27.19BR0477I Oracle pfile /oracle/DEV/102_64/dbs/initDEV.ora created from spfile /oracle/DEV/102_64/dbs/spfileDEV.ora BR0101I Parameters Name                           Value oracle_sid                     DEVoracle_home                    /oracle/DEV/102_64oracle_profile                 /oracle/DEV/102_64/dbs/initDEV.orasapdata_home                   /oracle/DEVsap_profile                    /oracle/DEV/102_64/dbs/initDEV.sapbackup_mode                    ALLbackup_type                    onlinebackup_dev_type                rman_utilutil_par_file                  /oracle/DEV/102_64/dbs/initDEV.utlrman_channels                  1rman_filesperset               4rman_proxy                     norman_parms                     ENV=(NSR_SERVER=backupsvr02.nflkk.com.cn)rman_compress                  nosystem_info                    oradev/oradev ESDEV AIX 3 5 00C2E03F4C00oracle_info                    DEV 10.2.0.2.0 8192 15991 30962025851 ESDEV UTF8 UTF8sap_info                       700 SAPSR3make_info                      rs6000_64 OCI_102 Oct 26 2006command_line                   brbackup -u / BR0116I ARCHIVE LOG LIST before backup for database instance DEV Parameter                      Value Database log mode              Archive ModeAutomatic archival             EnabledArchive destination            LOCATION=/oracle/DEV/oraarch/DEVarchArchive format                 %t_%s_%r.dbfOldest online log sequence     15988Next log sequence to archive   15991Current log sequence           15991            SCN: 30962025851Database block size            8192             Thread: 1Current system change number   30962028408      ResetId: 631477950 BR0118I Tablespaces and data files Tablespace     TS-Status  F-Status  File                                                       Size   Id.     Device  Link    Type       MaxSize     IncrSize  BlkSize PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata1/sr3_1/sr3.data1                 2097160192    4     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata1/sr3_2/sr3.data2                 2097160192    5     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata1/sr3_3/sr3.data3                 2097160192    6     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata1/sr3_4/sr3.data4                 2097160192    7     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata1/sr3_5/sr3.data5                 2097160192    8     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata2/sr3_10/sr3.data10               2097160192   13     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata2/sr3_6/sr3.data6                 2097160192    9     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata2/sr3_7/sr3.data7                 2097160192   10     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata2/sr3_8/sr3.data8                 2097160192   11     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata2/sr3_9/sr3.data9                 2097160192   12     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata3/sr3_11/sr3.data11               2097160192   14     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata3/sr3_12/sr3.data12               2097160192   15     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata3/sr3_13/sr3.data13               2097160192   16     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata3/sr3_14/sr3.data14               2097160192   17     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata3/sr3_15/sr3.data15               2097160192   18     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata4/sr3_16/sr3.data16               2097160192   19     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata4/sr3_17/sr3.data17               2097160192   20     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata4/sr3_18/sr3.data18               2097160192   21     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata4/sr3_19/sr3.data19               2097160192   22     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata4/sr3_20/sr3.data20               2097160192   23     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata5/sr3_21/sr3.data21               2097160192   42     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata5/sr3_22/sr3.data22               2097160192   43     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata5/sr3_23/sr3.data23               2097160192   44     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata5/sr3_24/sr3.data24               2097160192   45     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata5/sr3_25/sr3.data25               2097160192   46     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata5/sr3_26/sr3.data26               4294975488   53     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata6/sr3_27/sr3.data27               2097160192   55     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata6/sr3_28/sr3.data28               2097160192   56     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata6/sr3_29/sr3.data29               2097160192   57     2424836  NOLINK  FILE             0            0     8192PSAPSR3        ONLINE*    ONLINE    /oracle/DEV/sapdata6/sr3_30/sr3.data30               2097160192   58     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata1/sr3700_1/sr3700.data1           2474647552   24     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata1/sr3700_2/sr3700.data2           2453676032   25     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata1/sr3700_3/sr3700.data3           2663391232   26     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata1/sr3700_4/sr3700.data4           2915049472   27     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata2/sr3700_5/sr3700.data5           2831163392   28     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata2/sr3700_6/sr3700.data6           2810191872   29     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata2/sr3700_7/sr3700.data7           2936020992   30     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata2/sr3700_8/sr3700.data8           2747277312   31     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata3/sr3700_10/sr3700.data10         2642419712   33     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata3/sr3700_11/sr3700.data11         2537562112   34     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata3/sr3700_12/sr3700.data12         2495619072   35     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata3/sr3700_9/sr3700.data9           2684362752   32     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata4/sr3700_13/sr3700.data13         2516590592   36     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata4/sr3700_14/sr3700.data14         2453676032   37     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata4/sr3700_15/sr3700.data15         2432704512   38     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata4/sr3700_16/sr3700.data16         2453676032   39     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata4/sr3700_17/sr3700.data17         2453676032   41     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata5/sr3700_18/sr3700.data18         2516590592   47     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata5/sr3700_19/sr3700.data19         2516590592   48     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata5/sr3700_20/sr3700.data20         2516590592   49     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata5/sr3700_21/sr3700.data21         2516590592   50     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata5/sr3700_22/sr3700.data22         2516590592   51     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata5/sr3700_23/sr3700.data23         2516590592   52     2424836  NOLINK  FILE             0            0     8192PSAPSR3700     ONLINE*    ONLINE    /oracle/DEV/sapdata5/sr3700_24/sr3700.data24         4294975488   54     2424836  NOLINK  FILE             0            0     8192PSAPSR3USR     ONLINE*    ONLINE    /oracle/DEV/sapdata1/sr3usr_1/sr3usr.data1             20979712   40     2424836  NOLINK  FILE             0            0     8192PSAPTEMP       ONLINE#    ONLINE+   /oracle/DEV/sapdata2/temp_1/temp.data1               4257226752   -1     2424836  NOLINK  FILE   10485760000     20971520     8192PSAPUNDO       ONLINE-    ONLINE    /oracle/DEV/sapdata3/undo_1/pundo1.data1             4294975488    2     2424836  NOLINK  FILE             0            0     8192SYSAUX         ONLINE*    ONLINE    /oracle/DEV/sapdata1/sysaux_1/sysaux.data1           2147491840    3     2424836  NOLINK  FILE             0            0     8192SYSTEM         ONLINE*    SYSTEM    /oracle/DEV/sapdata1/system_1/system.data1           2147491840    1     2424836  NOLINK  FILE             0            0     8192 BR0119I Redo log files File                                                Size  Group     Device  Status    Link    Type /oracle/DEV/origlogA/log_g11m1.dbf              52429312    1      2424836  INUSE     NOLINK  FILE/oracle/DEV/mirrlogA/log_g11m2.dbf              52429312    1      2424836  INUSE     NOLINK  FILE/oracle/DEV/origlogB/log_g12m1.dbf              52429312    2      2424836  INUSE     NOLINK  FILE/oracle/DEV/mirrlogB/log_g12m2.dbf              52429312    2      2424836  INUSE     NOLINK  FILE/oracle/DEV/origlogA/log_g13m1.dbf              52429312    3      2424836  INUSE     NOLINK  FILE/oracle/DEV/mirrlogA/log_g13m2.dbf              52429312    3      2424836  INUSE     NOLINK  FILE/oracle/DEV/origlogB/log_g14m1.dbf              52429312    4      2424836  INUSE     NOLINK  FILE/oracle/DEV/mirrlogB/log_g14m2.dbf              52429312    4      2424836  INUSE     NOLINK  FILE BR0120I Control files File                                                Size   Id.      Device  Link    Type /oracle/DEV/origlogA/cntrl/cntlrDEV.dbf         11812864    0      2424836  NOLINK  FILE/oracle/DEV/origlogB/cntrl/cntrlDEV.dbf         11812864    0      2424836  NOLINK  FILE/oracle/DEV/sapdata1/cntrl/cntrlDEV.dbf         11812864    0      2424836  NOLINK  FILE BR0280I BRBACKUP time stamp: 2010-08-03 17.27.22BR0057I Backup of database: DEVBR0058I BRBACKUP action ID: beduvrlnBR0059I BRBACKUP function ID: anrBR0110I Backup mode: ALLBR0077I Database file for backup: /oracle/DEV/sapbackup/cntrlDEV.dbfBR0061I 59 files found for backup, total size 131255.719 MBBR0143I Backup type: onlineBR0112I Files will not be compressedBR0130I Backup device type: rman_utilBR0280I BRBACKUP time stamp: 2010-08-03 17.27.22BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:BR0280I BRBACKUP time stamp: 2010-08-03 17.27.23BR0257I Your reply: 'c'BR0259I Program execution will be continued... BR0280I BRBACKUP time stamp: 2010-08-03 17.27.23BR0501I Starting normal database backup using RMAN... BR0280I BRBACKUP time stamp: 2010-08-03 17.27.28BR0202I Saving /oracle/DEV/sapdata5/sr3700_24/sr3700.data24 BR0280I BRBACKUP time stamp: 2010-08-03 17.27.28BR0202I Saving /oracle/DEV/sapdata1/sr3_1/sr3.data1 BR0280I BRBACKUP time stamp: 2010-08-03 17.27.28BR0202I Saving /oracle/DEV/sapdata3/sr3_15/sr3.data15 BR0280I BRBACKUP time stamp: 2010-08-03 17.27.28BR0202I Saving /oracle/DEV/sapdata6/sr3_30/sr3.data30BR0278E Command output of 'SHELL=/bin/sh /oracle/DEV/102_64/bin/rman nocatalog': Recovery Manager: Release 10.2.0.2.0 - Production on Tue Aug 3 17:27:23 2010 Copyright (c) 1982, 2005, Oracle.  All rights reserved. RMAN> RMAN> connect target *connected to target database: DEV (DBID=3709816766)using target database control file instead of recovery catalog RMAN> **end-of-file** RMAN> host command complete RMAN> 2> 3> 4> 5> 6> 7> Reverse DNS lookup failed for address 10.10.10.11allocated channel: sbt_1channel sbt_1: sid=46 devtype=SBT_TAPEchannel sbt_1: NMO v4.5.0.0 Starting backup at 03-AUG-10channel sbt_1: starting full datafile backupsetchannel sbt_1: specifying datafile(s) in backupsetinput datafile fno=00054 name=/oracle/DEV/sapdata5/sr3700_24/sr3700.data24input datafile fno=00004 name=/oracle/DEV/sapdata1/sr3_1/sr3.data1input datafile fno=00018 name=/oracle/DEV/sapdata3/sr3_15/sr3.data15input datafile fno=00058 name=/oracle/DEV/sapdata6/sr3_30/sr3.data30channel sbt_1: starting piece 1 at 03-AUG-10RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-03009: failure of backup command on sbt_1 channel at 08/03/2010 17:30:23RMAN-10038: database session for channel sbt_1 terminated unexpectedly RMAN> RMAN> Recovery Manager complete.BR0280I BRBACKUP time stamp: 2010-08-03 17.30.25BR0279E Return code from 'SHELL=/bin/sh /oracle/DEV/102_64/bin/rman nocatalog': 1BR0522E 4 of 58 files/save sets processed by RMANBR0536E RMAN call for database instance DEV failed BR0280I BRBACKUP time stamp: 2010-08-03 17.30.25BR0503E Normal database backup using RMAN failed BR0056I End of database backup: beduvrln.anr 2010-08-03 17.30.25BR0280I BRBACKUP time stamp: 2010-08-03 17.30.27BR0054I BRBACKUP terminated with errors

mofo · Answer

Hi,

edit the /oracle/DEV/102_64/dbs/initDEV.sap file, find the "rman_parms" variable and edit it the way vsampy already suggested:

rman_parms="ENV=(NSR_SERVER=backupservername, NSR_CLIENT=sapClientname, NSR_DEBUG_FILE=/nsr/applogs/sap.log, NSR_DEBUG_LEVEL=9)"

After the backup paste here lets say last 100 lines of /nsr/applogs/sap.log file, if we're lucky the error will be visible... and if not, we'll have to check the whole file. Considering some of the passwords have changed, you might want to re-check that system password and oracle password that you might know, and that are encrypted in *cfg file are still working - try logging yourself in to system manually with system password and connect to oracle using oracle password you know.

NetWorker

Was this post helpful?