Thursday 20 November 2014

EBS : RMAN backup fails with "ORA-19566: exceeded limit of 0 corrupt blocks for file"

Error:

Starting backup at 29-OCT-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=373 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00352 name=/d01/UAT/db/apps_st/data/system09.dbf
channel ORA_DISK_1: starting piece 1 at 29-OCT-14
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/29/2014 12:25:04
ORA-19566: exceeded limit of 0 corrupt blocks for file /d01/UAT/db/apps_st/data/system09.dbf

Solution:

1. Check the free space and used space of datafile system09.dbf
 
   SET PAGESIZE 60
   SET LINESIZE 300
   COLUMN "Tablespace Name" FORMAT A22
   COLUMN "File Name" FORMAT A82
   SELECT  Substr(df.tablespace_name,1,20) "Tablespace Name",
           Substr(df.file_name,1,80) "File Name",
           Round(df.bytes/1024/1024,0) "Size (M)",
           decode(e.used_bytes,NULL,0,Round(e.used_bytes/1024/1024,0)) "Used Space(M)",
           decode(f.free_bytes,NULL,0,Round(f.free_bytes/1024/1024,0)) "Free Space(M)",
           decode(e.used_bytes,NULL,0,Round((e.used_bytes/df.bytes)*100,0)) "% Used"
   FROM    DBA_DATA_FILES DF,
          (SELECT file_id,
                  sum(bytes) used_bytes
           FROM dba_extents
           GROUP by file_id) E,
          (SELECT Max(bytes) free_bytes,
                  file_id
           FROM dba_free_space
           GROUP BY file_id) f
   WHERE    e.file_id (+) = df.file_id
   AND      df.file_id  = f.file_id (+)
   AND      df.file_name like '%system09.dbf'
   /

   If the space used is less than 1000 MB,

2. Resize the datafile system09.dbf
     alter database datafile '/d01/UAT/db/apps_st/data/system09.dbf' resixe 1000M;
     alter database datafile '/d01/UAT/db/apps_st/data/system09.dbf' resixe 1500M;

3. Now re-run the RMAN backup.

No comments:

Post a Comment

SQL Developer displaying Junk characters (??????)

Change the Encoding in SQL Developer Preferences as below Tools --> Preferences --> Environment --> Encoding --> UTF...