UNSOLVED

100x

updated

16 years ago

1

100x

1 Rookie

83 Posts

1

6680

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

==================