RE: RMAN backup fails

From: Mathias Zarick <Mathias.Zarick_at_trivadis.com>
Date: Wed, 23 Sep 2009 09:47:02 +0200
Message-ID: <370BF313301A024C962B05768686368301E1FE9E_at_MSXVS04.trivadis.com>

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
that.
So - use maxpiecesize clause to limit the size of backuppieces.  

HTH Mathias

---

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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 10.2.0.1.0 - 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;

FILE_TYPE PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

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

0

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

--
http://www.freelists.org/webpage/oracle-l

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