If you receive the error below during a backup of a Oracle Instance, a faulty Perl module on the client is the source of the problem…
The problem is difficult to debug, so just ask support for QCIM2A24591_TM3. With the fix the module DPoracle.pm will be changed, this should resolve the problem.
Recovery Manager complete.
[Major] From: ob2rman@server "Instanz" Time: 02.08.2010 09:30:26
External utility reported error.
RMAN PID=PID nummer
[Major] From: ob2rman@server "Instanz" Time: 02.08.2010 09:30:26
Oracle Recovery Manager completed with errors.
[Major] From: ob2rman@server "Instanz" Time: 02.08.2010 09:30:26
Backup of target database failed.
I always been interested in this, thanks for post!
I am getting below error during backup. Please help
———————————————————————————–
[Normal] From: BSM@wc-backup \\\”REFUND_DB1_BKP\\\” Time: 2/15/15 6:00:02 PM
Backup session 2015/02/15-2 started.
[Warning] From: BSM@wc-backup \\\”REFUND_DB1_BKP\\\” Time: 2/15/15 6:00:02 PM
[61:7010] Medium 5b01400a:532801aa:afaf:0001 in prealloc list of the device \\\”HP:Ultrium 5-SCSI_1_wc-backup\\\”
is protected and full or have copies.
[Warning] From: BSM@wc-backup \\\”REFUND_DB1_BKP\\\” Time: 2/15/15 6:00:02 PM
[61:2013] Some of the backup devices are occupied. Session is waiting
for all the devices to get free.
[Normal] From: BSM@wc-backup \\\”REFUND_DB1_BKP\\\” Time: 2/15/15 6:00:06 PM
OB2BAR application on \\\”vm-db1\\\” successfully started.
[Normal] From: ob2rman@vm-db1 \\\”REFUND1\\\” Time: 02/15/2015 06:39:52 PM
Starting backup of target database.
Net service name: REFUND1.
Instance status: OPEN.
Instance name: REFUND12.
Database DBID = 3447028775.
Database control file type: CURRENT.
Database log mode: ARCHIVELOG.
[Normal] From: ob2rman@vm-db1 \\\”REFUND1\\\” Time: 02/15/2015 06:39:53 PM
Starting Oracle Recovery Manager.
Recovery Manager: Release 11.2.0.3.0 – Production on Sun Feb 15 18:39:53 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
RMAN> CONNECT TARGET *
2> CONNECT CATALOG *
3> HOST \\\’exit\\\’;
4> run {
5> allocate channel \\\’dev_0\\\’ type \\\’sbt_tape\\\’
6> parms \\\’SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so,ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=REFUND1,OB2BARLIST=REFUND_DB1_BKP)\\\’;
7>
8> send device type \\\’sbt_tape\\\’ \\\’OB2BARHOSTNAME=vm-db1\\\’;
9> backup
10> format \\\’REFUND_DB1_BKP.dbf\\\’
11> current controlfile;
12> }
13> EXIT
RMAN-06005: connected to target database: REFUND1 (DBID=3447028775)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04004: error from recovery catalog database: ORA-28001: the password has expired
Recovery Manager complete.
[Major] From: ob2rman@vm-db1 \\\”REFUND1\\\” Time: 02/15/2015 06:39:56 PM
External utility reported error.
RMAN PID=553
[Major] From: ob2rman@vm-db1 \\\”REFUND1\\\” Time: 02/15/2015 06:39:56 PM
The database reported error while performing requested operation.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04004: error from recovery catalog database: ORA-28001: the password has expired
Recovery Manager complete.
[Major] From: ob2rman@vm-db1 \\\”REFUND1\\\” Time: 02/15/2015 06:39:56 PM
Oracle Recovery Manager completed with errors.
[Major] From: ob2rman@vm-db1 \\\”REFUND1\\\” Time: 02/15/2015 06:39:56 PM
Backup of target database failed.
[Normal] From: BSM@wc-backup \\\”REFUND_DB1_BKP\\\” Time: 2/15/15 6:00:12 PM
OB2BAR application on \\\”vm-db1\\\” disconnected.
[Critical] From: BSM@wc-backup \\\”REFUND_DB1_BKP\\\” Time: 2/15/15 6:00:12 PM
None of the Disk Agents completed successfully.
Session has failed.
[Normal] From: BSM@wc-backup \\\”REFUND_DB1_BKP\\\” Time: 2/15/15 6:00:12 PM
Backup Statistics:
Session Queuing Time (hours) 0.00
——————————————-
Completed Disk Agents …….. 0
Failed Disk Agents ……….. 0
Aborted Disk Agents ………. 0
——————————————-
Disk Agents Total ……….. 0
===========================================
Completed Media Agents ……. 0
Failed Media Agents ………. 0
Aborted Media Agents ……… 0
——————————————-
Media Agents Total ………. 0
===========================================
Mbytes Total …………….. 0 MB
Used Media Total …………. 0
Disk Agent Errors Total …… 0
Hi Rahesh,
the error indicates that the password for the user, which is used during the backup, has been expired.
You need to login into the database and change it. Normally this is done b the Oracle administrator.
Best regards
Daniel