IBM P650 OS:AIX5.3 ORACLE10.2.0.3 RAC RAW

ORA-19502: write error on file blockno 257 (blocksize=8192)

ORA-27063: number of bytes read/written is incorrect

ORA-19625: error identifying file /opt/oracle/archive/oa_arch/1_2483_631301302.dbf
ORA-27037: unable to obtain file status

allocated channel: c1
channel c1: sid=1480 instance=oa2 devtype=DISK

sql statement: alter system archive log current

executing command: SET COMMAND ID

Starting backup at 23-MAY-08
channel c1: starting incremental level 0 datafile backupset
channel c1: specifying datafile(s) in backupset
input datafile fno=00007 name=/dev/roa_tdocattach01
input datafile fno=00016 name=/dev/roa_tdocattach10
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c1 channel at 05/23/2008 12:12:28
ORA-19502: write error on file "/orabak/rman/OADB_20080523_2616", blockno 257 (blocksize=8192)
ORA-27063: number of bytes read/written is incorrect
IBM AIX RISC System/6000 Error: 28: No space left on device
Additional information: -1
Additional information: 1048576
ORA-19502: write error on file "/orabak/rman/OADB_20080523_2616", blockno 1 (blocksize=8192)
ORA-27063: number of bytes read/written is incorrect

RMAN> backup archivelog all format '/orabak/rman/arch_%s_%t';

Starting backup at 23-MAY-08
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1407 instance=oa2 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=1507 instance=oa2 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=1395 instance=oa2 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 05/23/2008 18:32:03
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /opt/oracle/archive/oa_arch/1_2483_631301302.dbf
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3

-----------------------------------------------

Applies to:

Oracle Server - Enterprise Edition - Version: 8.1.7.4 to 10.2.0.4
This problem can occur on any platform

Cause

Space issue

ORA-19502: write error on file
"/san_backup/rman_backup/rpmprod/rpmprod_dbf_3sil6d1a_16_1_626209834", blockno 198401 (blocksize=8192)
ORA-27063: skgfospo: number of bytes read/written is incorrec

This means RMAN is attempting to write 198401*8192= 1,625,300,992 bytes to backupset /san_backup/rman_backup/rpmprod/rpmprod_dbf_3sil6d1a_16_1_626209834 and enough space is not available.

Solution

1) Delete unnecessary file(s) in backup directory.

2) Move backup location to a mount point with more space.