ORA-19502: write error on file ... (blocksize=8192)
Cac47May 12 2010 — edited May 13 2010Dear DBA's,
I'm facing an incredible crappy issue with RMAN and I don’t see where it come from.
Target Database is OS is RHEL5 with ORACLE 10.2.4
The RMAN repository is RHEL5 in Oracle 11g2
In the host there are 2 databases CFM1 and DMB1 and both are backup with RMAN in same Repository. In DMB1 I don’t have any issue
With CFM1 I’ve this error Message every time I run a Backup as follows :
RMAN> run
2> {
3> sql "Alter System Switch logfile";
4> sql "Alter System Archive Log Current";
5> Backup device type disk database plus archivelog;
6> Backup current controlfile for standby;
7> sql "Alter System Switch logfile";
8> sql "Alter System Archive Log Current";
9> Backup filesperset 10 ArchiveLog all;
10> }
sql statement: Alter System Switch logfile
sql statement: Alter System Archive Log Current
Starting backup at 12-MAY-10
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=226 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=43392 recid=36539 stamp=718803231
input archive log thread=1 sequence=43393 recid=36540 stamp=718803232
input archive log thread=1 sequence=43394 recid=36541 stamp=718803240
channel ORA_DISK_1: starting piece 1 at 12-MAY-10
channel ORA_DISK_1: finished piece 1 at 12-MAY-10
piece handle=/backup/ORA_BACKUP_CFMT/CFMT_120520100512_full_28ldg499_1_1 tag=TAG20100512T113401 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 12-MAY-10
Starting backup at 12-MAY-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00031 name=/u01/oradata/CFMT/data/iws_data_02.dbf
input datafile fno=00028 name=/u03/oradata/CFMT/index/tools_01.dbf
.
. Then It goes trough several datafiles
.
input datafile fno=00004 name=/u02/oradata/CFMT/system/users01.dbf
input datafile fno=00014 name=/u01/oradata/CFMT/data/iws_data_01.dbf
channel ORA_DISK_1: starting piece 1 at 12-MAY-10
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 05/12/2010 11:35:29
ORA-19502: write error on file "/backup/ORA_BACKUP_CFMT/CFMT_120520100512_full_29ldg49c_1_1", blockno 734721 (blocksize=8192)
ORA-27072: File I/O error
Linux-x86_64 Error: 9: Bad file descriptor
Additional information: 4
Additional information: 734721
Additional information: 917504
I've check in Metalink and open a Sr and so far no answer !!!
Any ideas ?
Txs
Carlos