RMAN backup fails
- From: Amir Gheibi <gheibia@xxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Sep 2009 15:40:30 +0800
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
Other related posts:
