RMAN backup fails

From: Amir Gheibi <gheibia_at_gmail.com>
Date: Wed, 23 Sep 2009 15:40:30 +0800
Message-ID: <c906cd460909230040k5fe3dd3fg4b3868693ed7be44_at_mail.gmail.com>

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_TAG20090923T151614_%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][oracle]
*
*>>*

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:40:30 CDT