RE: RMAN backup fails
- From: "Mathias Zarick" <Mathias.Zarick@xxxxxxxxxxxx>
- To: <gheibia@xxxxxxxxx>
- Date: Wed, 23 Sep 2009 09:47:02 +0200
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
Other related posts:
