Unsolved
This post is more than 5 years old
1 Rookie
•
83 Posts
1
6657
August 3rd, 2010 08:00
networker:SAP backup problems
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:39
Running backup process as user oradev
spawning brarchive process as user oradev ...
BR0002I BRARCHIVE 7.00 (18)
BR0006I Start of offline redo log processing: aedtnefw.cds 2010-07-27 16.58.40
BR0477I 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.40
BR0008I Offline redo log processing for database instance: DEV
BR0009I BRARCHIVE action ID: aedtnefw
BR0010I BRARCHIVE function ID: cds
BR0048I Archive function: copy_delete_save
BR0011I 8 offline redo log files found for processing, total size 347.392 MB
BR0112I Files will not be compressed
BR0130I Backup device type: rman_util
BR0134I Unattended mode with 'force' active - no operator confirmation allowed
BR0280I BRARCHIVE time stamp: 2010-07-27 16.58.40
BR0541I Starting offline redo log backup using RMAN...
BR0280I BRARCHIVE time stamp: 2010-07-27 16.58.44
BR0202I Saving /oracle/DEV/oraarch/DEVarch1_15855_631477950.dbf
BR0280I BRARCHIVE time stamp: 2010-07-27 16.58.44
BR0202I Saving /oracle/DEV/oraarch/DEVarch1_15856_631477950.dbf
BR0280I BRARCHIVE time stamp: 2010-07-27 16.58.44
BR0202I Saving /oracle/DEV/oraarch/DEVarch1_15857_631477950.dbf
BR0280I BRARCHIVE time stamp: 2010-07-27 16.58.44
BR0202I Saving /oracle/DEV/oraarch/DEVarch1_15858_631477950.dbf
BR0278E 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.11
allocated channel: sbt_1
channel sbt_1: sid=39 devtype=SBT_TAPE
channel sbt_1: NMO v4.5.0.0
Starting backup at 27-JUL-10
channel sbt_1: starting archive log backupset
channel sbt_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=15855 recid=15028 stamp=724950016
input archive log thread=1 sequence=15856 recid=15029 stamp=724958029
input archive log thread=1 sequence=15857 recid=15030 stamp=724997688
input archive log thread=1 sequence=15858 recid=15031 stamp=725022034
channel sbt_1: starting piece 1 at 27-JUL-10
RMAN-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:09
RMAN-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.10
BR0279E Return code from 'SHELL=/bin/sh /oracle/DEV/102_64/bin/rman nocatalog': 1
BR0522E 4 of 8 files/save sets processed by RMAN
BR0536E RMAN call for database instance DEV failed
BR0280I BRARCHIVE time stamp: 2010-07-27 17.01.10
BR0543E 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.10
BR0280I BRARCHIVE time stamp: 2010-07-27 17.01.11
BR0005I BRARCHIVE terminated with errors
==================
0 events found
vsampy
14 Posts
0
August 3rd, 2010 09:00
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
1 Rookie
•
83 Posts
0
August 3rd, 2010 19:00
Thanks.
mofo
58 Posts
0
August 5th, 2010 05:00
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
14 Posts
0
August 5th, 2010 05:00
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
58 Posts
0
August 5th, 2010 05:00
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
88 Posts
0
August 5th, 2010 09:00
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
1 Rookie
•
83 Posts
0
August 5th, 2010 20:00
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 user
6) 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\nsr\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\nsr\applogs
NSR_DEBUG_DIR = /nsr/applogs
Default Value = 9
But there is no effect.
100x
1 Rookie
•
83 Posts
0
August 5th, 2010 21:00
BR0051I BRBACKUP 7.00 (18)
BR0055I Start of database backup: beduvrln.anr 2010-08-03 17.27.19
BR0477I 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 DEV
oracle_home /oracle/DEV/102_64
oracle_profile /oracle/DEV/102_64/dbs/initDEV.ora
sapdata_home /oracle/DEV
sap_profile /oracle/DEV/102_64/dbs/initDEV.sap
backup_mode ALL
backup_type online
backup_dev_type rman_util
util_par_file /oracle/DEV/102_64/dbs/initDEV.utl
rman_channels 1
rman_filesperset 4
rman_proxy no
rman_parms ENV=(NSR_SERVER=backupsvr02.nflkk.com.cn)
rman_compress no
system_info oradev/oradev ESDEV AIX 3 5 00C2E03F4C00
oracle_info DEV 10.2.0.2.0 8192 15991 30962025851 ESDEV UTF8 UTF8
sap_info 700 SAPSR3
make_info rs6000_64 OCI_102 Oct 26 2006
command_line brbackup -u /
BR0116I ARCHIVE LOG LIST before backup for database instance DEV
Parameter Value
Database log mode Archive Mode
Automatic archival Enabled
Archive destination LOCATION=/oracle/DEV/oraarch/DEVarch
Archive format %t_%s_%r.dbf
Oldest online log sequence 15988
Next log sequence to archive 15991
Current log sequence 15991 SCN: 30962025851
Database block size 8192 Thread: 1
Current 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 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata1/sr3_2/sr3.data2 2097160192 5 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata1/sr3_3/sr3.data3 2097160192 6 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata1/sr3_4/sr3.data4 2097160192 7 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata1/sr3_5/sr3.data5 2097160192 8 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata2/sr3_10/sr3.data10 2097160192 13 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata2/sr3_6/sr3.data6 2097160192 9 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata2/sr3_7/sr3.data7 2097160192 10 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata2/sr3_8/sr3.data8 2097160192 11 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata2/sr3_9/sr3.data9 2097160192 12 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata3/sr3_11/sr3.data11 2097160192 14 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata3/sr3_12/sr3.data12 2097160192 15 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata3/sr3_13/sr3.data13 2097160192 16 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata3/sr3_14/sr3.data14 2097160192 17 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata3/sr3_15/sr3.data15 2097160192 18 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata4/sr3_16/sr3.data16 2097160192 19 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata4/sr3_17/sr3.data17 2097160192 20 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata4/sr3_18/sr3.data18 2097160192 21 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata4/sr3_19/sr3.data19 2097160192 22 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata4/sr3_20/sr3.data20 2097160192 23 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata5/sr3_21/sr3.data21 2097160192 42 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata5/sr3_22/sr3.data22 2097160192 43 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata5/sr3_23/sr3.data23 2097160192 44 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata5/sr3_24/sr3.data24 2097160192 45 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata5/sr3_25/sr3.data25 2097160192 46 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata5/sr3_26/sr3.data26 4294975488 53 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata6/sr3_27/sr3.data27 2097160192 55 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata6/sr3_28/sr3.data28 2097160192 56 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata6/sr3_29/sr3.data29 2097160192 57 2424836 NOLINK FILE 0 0 8192
PSAPSR3 ONLINE* ONLINE /oracle/DEV/sapdata6/sr3_30/sr3.data30 2097160192 58 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata1/sr3700_1/sr3700.data1 2474647552 24 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata1/sr3700_2/sr3700.data2 2453676032 25 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata1/sr3700_3/sr3700.data3 2663391232 26 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata1/sr3700_4/sr3700.data4 2915049472 27 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata2/sr3700_5/sr3700.data5 2831163392 28 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata2/sr3700_6/sr3700.data6 2810191872 29 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata2/sr3700_7/sr3700.data7 2936020992 30 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata2/sr3700_8/sr3700.data8 2747277312 31 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata3/sr3700_10/sr3700.data10 2642419712 33 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata3/sr3700_11/sr3700.data11 2537562112 34 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata3/sr3700_12/sr3700.data12 2495619072 35 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata3/sr3700_9/sr3700.data9 2684362752 32 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata4/sr3700_13/sr3700.data13 2516590592 36 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata4/sr3700_14/sr3700.data14 2453676032 37 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata4/sr3700_15/sr3700.data15 2432704512 38 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata4/sr3700_16/sr3700.data16 2453676032 39 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata4/sr3700_17/sr3700.data17 2453676032 41 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata5/sr3700_18/sr3700.data18 2516590592 47 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata5/sr3700_19/sr3700.data19 2516590592 48 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata5/sr3700_20/sr3700.data20 2516590592 49 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata5/sr3700_21/sr3700.data21 2516590592 50 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata5/sr3700_22/sr3700.data22 2516590592 51 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata5/sr3700_23/sr3700.data23 2516590592 52 2424836 NOLINK FILE 0 0 8192
PSAPSR3700 ONLINE* ONLINE /oracle/DEV/sapdata5/sr3700_24/sr3700.data24 4294975488 54 2424836 NOLINK FILE 0 0 8192
PSAPSR3USR ONLINE* ONLINE /oracle/DEV/sapdata1/sr3usr_1/sr3usr.data1 20979712 40 2424836 NOLINK FILE 0 0 8192
PSAPTEMP ONLINE# ONLINE+ /oracle/DEV/sapdata2/temp_1/temp.data1 4257226752 -1 2424836 NOLINK FILE 10485760000 20971520 8192
PSAPUNDO ONLINE- ONLINE /oracle/DEV/sapdata3/undo_1/pundo1.data1 4294975488 2 2424836 NOLINK FILE 0 0 8192
SYSAUX ONLINE* ONLINE /oracle/DEV/sapdata1/sysaux_1/sysaux.data1 2147491840 3 2424836 NOLINK FILE 0 0 8192
SYSTEM 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.22
BR0057I Backup of database: DEV
BR0058I BRBACKUP action ID: beduvrln
BR0059I BRBACKUP function ID: anr
BR0110I Backup mode: ALL
BR0077I Database file for backup: /oracle/DEV/sapbackup/cntrlDEV.dbf
BR0061I 59 files found for backup, total size 131255.719 MB
BR0143I Backup type: online
BR0112I Files will not be compressed
BR0130I Backup device type: rman_util
BR0280I BRBACKUP time stamp: 2010-08-03 17.27.22
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:
BR0280I BRBACKUP time stamp: 2010-08-03 17.27.23
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
BR0280I BRBACKUP time stamp: 2010-08-03 17.27.23
BR0501I Starting normal database backup using RMAN...
BR0280I BRBACKUP time stamp: 2010-08-03 17.27.28
BR0202I Saving /oracle/DEV/sapdata5/sr3700_24/sr3700.data24
BR0280I BRBACKUP time stamp: 2010-08-03 17.27.28
BR0202I Saving /oracle/DEV/sapdata1/sr3_1/sr3.data1
BR0280I BRBACKUP time stamp: 2010-08-03 17.27.28
BR0202I Saving /oracle/DEV/sapdata3/sr3_15/sr3.data15
BR0280I BRBACKUP time stamp: 2010-08-03 17.27.28
BR0202I Saving /oracle/DEV/sapdata6/sr3_30/sr3.data30
BR0278E 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.11
allocated channel: sbt_1
channel sbt_1: sid=46 devtype=SBT_TAPE
channel sbt_1: NMO v4.5.0.0
Starting backup at 03-AUG-10
channel sbt_1: starting full datafile backupset
channel sbt_1: specifying datafile(s) in backupset
input datafile fno=00054 name=/oracle/DEV/sapdata5/sr3700_24/sr3700.data24
input datafile fno=00004 name=/oracle/DEV/sapdata1/sr3_1/sr3.data1
input datafile fno=00018 name=/oracle/DEV/sapdata3/sr3_15/sr3.data15
input datafile fno=00058 name=/oracle/DEV/sapdata6/sr3_30/sr3.data30
channel sbt_1: starting piece 1 at 03-AUG-10
RMAN-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:23
RMAN-10038: database session for channel sbt_1 terminated unexpectedly
RMAN>
RMAN>
Recovery Manager complete.
BR0280I BRBACKUP time stamp: 2010-08-03 17.30.25
BR0279E Return code from 'SHELL=/bin/sh /oracle/DEV/102_64/bin/rman nocatalog': 1
BR0522E 4 of 58 files/save sets processed by RMAN
BR0536E RMAN call for database instance DEV failed
BR0280I BRBACKUP time stamp: 2010-08-03 17.30.25
BR0503E Normal database backup using RMAN failed
BR0056I End of database backup: beduvrln.anr 2010-08-03 17.30.25
BR0280I BRBACKUP time stamp: 2010-08-03 17.30.27
BR0054I BRBACKUP terminated with errors
mofo
58 Posts
1
August 6th, 2010 00:00
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.