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
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?
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.
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.
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
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
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
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.
vsampy
14 Posts
2861
0
Posted 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?