RE: RMAN backup fails

From: Mathias Zarick <>
Date: Wed, 23 Sep 2009 09:47:02 +0200
Message-ID: <>

Hi Amir,  

your failure is reported when writing the first block after the first 2GB.
looks like you have a filesystem, that does not support files larger than
So - use maxpiecesize clause to limit the size of backuppieces.  

HTH Mathias

[] On Behalf Of Amir Gheibi Sent: Wednesday, September 23, 2009 9:41 AM To: ORACLE-L
Subject: RMAN backup fails

Hi listers,

I've got an Oracle 10g R2 installed on a HP Unix box. I tried to get a full backup from database using RMAN (as I did few times on this particular database before without any problem) and I've got the following error:

>>rman target /

Recovery Manager: Release - Production on Wed Sep 23 15:16:06 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: PRODXTEW (DBID=2880461687)

RMAN> backup database;

Starting backup at 23-SEP-09
using target database control file instead of recovery catalog allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=733 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00002 name=/u01/oradata/PRODXTEW/undotbs01.dbf
input datafile fno=00004 name=/u01/oradata/PRODXTEW/some_data_file.DBF
input datafile fno=00003 name=/u01/oradata/PRODXTEW/auxdbj01.dbf input datafile fno=00001 name=/u01/oradata/PRODXTEW/system01.dbf channel ORA_DISK_1: starting piece 1 at 23-SEP-09
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 09/23/2009 15:17:29
ORA-19502: write error on file
"/u04/flash_recovery_area/PRODXTEW/backupset/2009_09_23/o1_mf_nnndf_TAG2 0090923T151614_%u_.bkp", blockno 262017 (blocksize=8192) ORA-27072: File I/O error
HP-UX Error: 2: No such file or directory
Additional information: 4
Additional information: 262017
Additional information: 1040383

The path "/u04/flash_recovery_area/PRODXTEW/backupset/2009_09_23" exists.. I checked..

>>cd /u04/flash_recovery_area/PRODXTEW/backupset/2009_09_23
[SVR001TW56][/u04/flash_recovery_area/PRODXTEW/backupset/2009_09_23][ora cle]

I also made sure that I have enough space left from what I've allocated to the backup and archive destination (Which is about 200GB).

part of the SPFILE:

  log_archive_format       = %t_%s_%r.arc
  db_recovery_file_dest    = /u04/flash_recovery_area
  db_recovery_file_dest_size= 211968000000

SQL> select * from v$flash_recovery_area_usage;


------------ ------------------ -------------------------
CONTROLFILE                   0                         0
ONLINELOG                     0                         0
ARCHIVELOG                 9.63                      1.02
BACKUPPIECE                1.72                       .76
IMAGECOPY                     0                         0
FLASHBACKLOG                  0                         0

Any idea what might be the cause? Any help is appreciated. ~ Amir Gheibi

Received on Wed Sep 23 2009 - 02:47:02 CDT

Original text of this message