Re: RMAN backup fails
Date: Wed, 23 Sep 2009 16:06:48 +0800
Message-ID: <c906cd460909230106r19bd21fdo7d042fc227e2edf_at_mail.gmail.com>
Thanks for the replies.. I'll try your suggestions..
On Wed, Sep 23, 2009 at 3:49 PM, Niall Litchfield < niall.litchfield_at_gmail.com> wrote:
> 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-lReceived on Wed Sep 23 2009 - 03:06:48 CDT