Re: RMAN backup fails

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 23 Sep 2009 08:49:49 +0100
Message-ID: <7765c8970909230049l6ceb91dw2246d40335c0b5f7_at_mail.gmail.com>

That looks rather suspiciously as if your backupset is restricted to 2gb in size (but the numbers don't quite work as 2g is 262144 8k blocks not 262017) - I'd try with a max file size of 2000m and see if it doesn't complete.

On Wed, Sep 23, 2009 at 8:40 AM, Amir Gheibi <gheibia_at_gmail.com> wrote:

> 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
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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

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