oracle 03002,RMAN-03002 ORA-19625 ORA-27037 报错

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[@more@]

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.