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:)))
Kaydol:
Kayıt Yorumları (Atom)
thank you
YanıtlaSil