November 14, 2011 at 11:55 pm
Hi Guys
Not sure if anyone will be able to help me out.
We've got a tablespace OZFX that's relatively full. If I try to extend specific datafiles I get the following issue:
KCF: write/open error block=0x30d3fa online=1
file=939 +TB_DATA1/ozfx02.dbf
error=17510 txt: ''
Automatic datafile offline due to write error on
file 939: +TB_DATA1/ozfx02.dbf
Tue Nov 15 08:23:23 2011
ORA-372 signalled during: ALTER DATABASE DATAFILE '+TB_DATA1/ozfx02.dbf' RESIZE 25000M...
Now I have to recover the datafile again.
Why am I unable to extend these datafiles? Data corruption? Faulty ASM?
This is happening quite often now. Having no problem recovering the files though.
Thanks in advance
November 16, 2011 at 11:23 am
RuanK (11/14/2011)
Not sure if anyone will be able to help me out.We've got a tablespace OZFX that's relatively full. If I try to extend specific datafiles I get the following issue:
KCF: write/open error block=0x30d3fa online=1
file=939 +TB_DATA1/ozfx02.dbf
error=17510 txt: ''
Automatic datafile offline due to write error on
file 939: +TB_DATA1/ozfx02.dbf
Tue Nov 15 08:23:23 2011
ORA-372 signalled during: ALTER DATABASE DATAFILE '+TB_DATA1/ozfx02.dbf' RESIZE 25000M...
Now I have to recover the datafile again.
Why am I unable to extend these datafiles? Data corruption? Faulty ASM?
This is happening quite often now. Having no problem recovering the files though.
Two questions...
1- Is affected tablespace a readonly one?
2- What's the space status on +TB_DATA1?
Last but not least... why not adding a new datafile instead of extending existing ones?
I would add a new datafile rather than
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.November 16, 2011 at 10:22 pm
Thanks for the reply:
1. No, it is readwrite
2. We have over 900gb left on the ASM for that diskgroup.
We have always only extended the datafiles (currently 7 datafiles)
I want to know why this is happening. I have logged a SR with Oracle as well.
Regards
December 8, 2011 at 11:53 am
RuanK (11/16/2011)
I have logged a SR with Oracle
I think that's the sensitive thing to do.
By the way, have you checked Metalink note #370921.1 "ASM - Scalability and Limits"?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply