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.
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