Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN-03009: Failure of backup command

Vijayaraghavan KrishnanMay 22 2009 — edited May 22 2009
Hi to all,

I am facing a error when i'am trying to backup the Offline Archive Logs from the SAP.

what will be possible causes for this. Please help me to sort this.

BR0202I Saving /oracle/PRD/sapdata3/undo_1/undo.data1
BR0278E Command output of 'SHELL=/bin/sh /oracle/PRD/102_64/bin/rman nocatalog':
Recovery Manager: Release 10.2.0.2.0 - Production on Fri May 15 12:57:15 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
RMAN>
RMAN> connect target *
connected to target database: PRD (DBID=1736599138)
using target database control file instead of recovery catalog
RMAN> **end-of-file**
RMAN>
host command complete
RMAN> 2> 3> 4> 5> 6>
allocated channel: sbt_1
channel sbt_1: sid=52 devtype=SBT_TAPE
channel sbt_1: Data Protection for SAP(R)
Starting backup at 15-MAY-09
channel sbt_1: starting full datafile backupset
channel sbt_1: specifying datafile(s) in backupset
input datafile fno=00002 name=/oracle/PRD/sapdata3/undo_1/undo.data1
channel sbt_1: starting piece 1 at 15-MAY-09
could not write to trace file
released channel: sbt_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on sbt_1 channel at 05/15/2009 12:58:03
ORA-19506: failed to create sequential file, name="PRD_beaortbe.298_1", parms=""
ORA-27028: skgfqcre: sbtbackup returned error
ORA-19511: Error received from media manager layer, error text:
ANS0282E (RC168) Password file is not available.
RMAN>
RMAN>
Recovery Manager complete.
BR0280I BRBACKUP time stamp: 2009-05-15 12.58.04
BR0279E Return code from 'SHELL=/bin/sh /oracle/PRD/102_64/bin/rman nocatalog': 1
BR0522E 1 of 40 files/save sets processed by RMAN
BR0536E RMAN call for database instance PRD failed
BR0280I BRBACKUP time stamp: 2009-05-15 12.58.04
BR0503E Normal database backup using RMAN failed
BR0056I End of database backup: beaortbe.anr 2009-05-15 12.58.04
BR0280I BRBACKUP time stamp: 2009-05-15 12.58.06
BR0054I BRBACKUP terminated with errors
BR0280I BRBACKUP time stamp: 2009-05-15 12.58.06
BR0291I BRARCHIVE will be started with options '-U -jid ALLOG20090515125713 -d rman_util -c force -p initPRD.sap -cds'
BR0280I BRBACKUP time stamp: 2009-05-15 12.58.23
BR0292I Execution of BRARCHIVE finished with return code 5


Thanks and Regards,
Vijayaraghavan K
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 19 2009
Added on May 22 2009
4 comments
8,604 views