29 Haziran 2012 Cuma

RMAN-03009: failure of backup command on ORA_DISK_1 channel


Hi,

I was getting backup application's database,I got these errors in below.
Master problem is;

ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/test_db/sys/system09.dbf

We use E-Business Suite R12,so we have a lot of system dbf.

Problem:

channel ORA_DISK_1: starting piece 1 at 29-JUN-12


RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/29/2012 10:20:22

ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/test_db/sys/system09.dbf

continuing other job steps, job failed will not be re-run

channel ORA_DISK_1: starting full datafile backup set

channel ORA_DISK_1: specifying datafile(s) in backup set

including current control file in backup set

channel ORA_DISK_1: starting piece 1 at 29-JUN-12

channel ORA_DISK_1: finished piece 1 at 29-JUN-12

piece handle=/u01/backup/NECOTEST_787227623_42.rman tag=TAG20120629T101617 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

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

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/29/2012 10:20:22
ORA-19566: exceeded limit of 0 corrupt blocks for file /u01/test_db/sys/system09.dbf


Solution:

SQL> select file_name,tablespace_name,bytes/1024/1024/1024 from dba_data_files where tablespace_name='SYSTEM';

FILE_NAME
--------------------------------------------------------------------------------
TABLESPACE_NAME                BYTES/1024/1024/1024
------------------------------ --------------------
/u01/test_db/sys/system09.dbf
SYSTEM                                   1.46484375

/u01/test_db/sys/system08.dbf
SYSTEM                                    1.7578125

/u01/test_db/sys/system07.dbf
SYSTEM                                   .732421875

Our system09.dbf is 1,46 GB.We will change this dbf size then return old size.

SQL> alter database datafile '/u01/test_db/sys/system09.dbf' resize 1000m


Then;


SQL> alter database datafile '/u01/test_db/sys/system09.dbf' resize 1464m

After this changes

We can take backup successfully...

Have a nice weekend:)))

1 yorum: