Skip to Content
0
Former Member
Aug 17, 2011 at 11:51 AM

FullOffline Backup ->ORA-19566: exceeded limit of 0 corrupt blocks for file

198 Views

Dear SAP gurus,

I am getting an error from the DBA Planning Calendar every time the job for "Full Offline backup" is run. And it is always as you can see from the log on the same file "oracle/SHD/sapdata4/sr3_16/sr3.data16".

The oracle error is the following:

ORA-19566: exceeded limit of 0 corrupt blocks for file /oracle/SHD/sapdata4/sr3_16/sr3.data16

I found the SAP Note 969192 - RMAN Backup of SYSTEM tablespace terminates with ORA-19566

but it does no apply because this is for the tablespace SYSTEM and not PSAPSR3.

Please find below the log:

BR0051I BRBACKUP 7.00 (46)

BR0055I Start of database backup: begomwsv.ffd 2011-08-17 10.01.37

BR0484I BRBACKUP log file: /oracle/SHD/sapbackup/begomwsv.ffd

BR0477I Oracle pfile /oracle/SHD/102_64/dbs/initSHD.ora created from spfile /oracle/SHD/102_64/dbs/spfileSHD.ora

BR0101I Parameters

Name Value

oracle_sid SHD

oracle_home /oracle/SHD/102_64

oracle_profile /oracle/SHD/102_64/dbs/initSHD.ora

sapdata_home /oracle/SHD

sap_profile /oracle/SHD/102_64/dbs/initSHD.sap

backup_mode FULL

backup_type offline_force

backup_dev_type disk

backup_root_dir /mnt/backup/oracle/SHD

compress no

disk_copy_cmd rman

cpio_disk_flags -pdcu

exec_parallel 0

rman_compress no

system_info shdadm/orashd eccdev01 Linux 2.6.16.60-0.87.1-smp #1 SMP Wed May 11 11:48:12 UTC 2011 x86_64

oracle_info SHD 10.2.0.4.0 8192 17654 1114483454 eccdev01 UTF8 UTF8

sap_info 700 SAPSR3 0002LK0003SHD0011Y01548735220015Maintenance_ORA

make_info linuxx86_64 OCI_102 Jan 29 2010

command_line brbackup -u / -jid FLLOF20110817100136 -c force -t offline_force -m full -p initSHD.sap

BR0116I ARCHIVE LOG LIST before backup for database instance SHD

Parameter Value

Database log mode No Archive Mode

Automatic archival Disabled

Archive destination /oracle/SHD/oraarch/SHDarch

Archive format %t_%s_%r.dbf

Oldest online log sequence 17651

Next log sequence to archive 17654

Current log sequence 17654 SCN: 1114483454

Database block size 8192 Thread: 1

Current system change number 1114501246 ResetId: 664011854

BR0118I Tablespaces and data files

...

BR0202I Saving /oracle/SHD/sapdata3/sr3_15/sr3.data15

BR0203I to /mnt/backup/oracle/SHD/begomwsv/sr3.data15 ...

#FILE..... /oracle/SHD/sapdata3/sr3_15/sr3.data15

#SAVED.... /mnt/backup/oracle/SHD/begomwsv/sr3.data15 #1/15

BR0280I BRBACKUP time stamp: 2011-08-17 10.28.42

BR0063I 15 of 48 files processed - 44100.117 of 121180.346 MB done

BR0204I Percentage done: 36.39%, estimated end time: 11:15

BR0001I ******************________________________________

BR0202I Saving /oracle/SHD/sapdata4/sr3_16/sr3.data16

BR0203I to /mnt/backup/oracle/SHD/begomwsv/sr3.data16 ...

BR0278E Command output of 'SHELL=/bin/sh /oracle/SHD/102_64/bin/rman nocatalog':

Recovery Manager: Release 10.2.0.4.0 - Production on Wed Aug 17 10:28:42 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN>

RMAN> connect target *

connected to target database: SHD (DBID=1683093070, not open)

using target database control file instead of recovery catalog

RMAN> *end-of-file*

RMAN>

host command complete

RMAN> 2> 3> 4> 5> 6>

allocated channel: dsk

channel dsk: sid=223 devtype=DISK

executing command: SET NOCFAU

Starting backup at 17-AUG-11

channel dsk: starting datafile copy

input datafile fno=00019 name=/oracle/SHD/sapdata4/sr3_16/sr3.data16

released channel: dsk

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03009: failure of backup command on dsk channel at 08/17/2011 10:30:30

ORA-19566: exceeded limit of 0 corrupt blocks for file /oracle/SHD/sapdata4/sr3_16/sr3.data16

RMAN>

Recovery Manager complete.

BR0280I BRBACKUP time stamp: 2011-08-17 10.30.30

BR0279E Return code from 'SHELL=/bin/sh /oracle/SHD/102_64/bin/rman nocatalog': 1

BR0536E RMAN call for database instance SHD failed

BR0280I BRBACKUP time stamp: 2011-08-17 10.30.30

BR0506E Full database backup (level 0) using RMAN failed

BR0222E Copying /oracle/SHD/sapdata4/sr3_16/sr3.data16 to/from /mnt/backup/oracle/SHD/begomwsv failed due to previous errors

BR0280I BRBACKUP time stamp: 2011-08-17 10.30.34

BR0307I Shutting down database instance SHD ...

BR0280I BRBACKUP time stamp: 2011-08-17 10.30.34

BR0308I Shutdown of database instance SHD successful

BR0280I BRBACKUP time stamp: 2011-08-17 10.30.34

BR0304I Starting and opening database instance SHD ...

BR0280I BRBACKUP time stamp: 2011-08-17 10.30.47

BR0305I Start and open of database instance SHD successful

Do you guys have any idea on how to solve this issue??

Thanks in advance, Marc