568 reputation
11132
bio website dba010.wordpress.com
location Tbilisi, Georgia
age 24
visits member for 3 years, 3 months
seen 19 hours ago

I am 11g OCP and I work as a Senior DBA at Ministry of Justice of Georgia.


Jan
16
comment ASM drop disk hangs (STATE DROPPING)
@Phil you are right , I have to do scandisks instead of createdisk on node2.. please see my edition notes in the post.
Jan
16
revised ASM drop disk hangs (STATE DROPPING)
added 1198 characters in body
Jan
16
asked ASM drop disk hangs (STATE DROPPING)
Jan
13
comment Oracle Transaction recovery: lock conflict caught and ignored
@Phil The Oracle version is 11.2.0.1.0
Jan
10
comment Oracle Transaction recovery: lock conflict caught and ignored
@Ivan As I remember when there was supplemental logging enabled it contained ORA- in front of it and incident files were being created. But after disabling it just that statement is repeated for many times.
Jan
10
comment Oracle Transaction recovery: lock conflict caught and ignored
@Ivan No ORA- , just "Transaction recovery: lock conflict caught and ignored" 132(92 sometimes 223) lines together
Jan
10
asked Oracle Transaction recovery: lock conflict caught and ignored
Jan
9
awarded  Popular Question
Jan
9
accepted RMAN list archivelogs that are needed for to recover specified backup
Jan
8
asked RMAN list archivelogs that are needed for to recover specified backup
Dec
27
revised Drop table without its dependencies and solve block corruption
added 57 characters in body
Dec
27
revised Drop table without its dependencies and solve block corruption
Solution of one problem and question about the second problem.
Dec
27
comment Drop table without its dependencies and solve block corruption
Your solution worked. But my solution that, I think is the same as your did not work, why? /*Please, see my updated post*/
Dec
27
comment Drop table without its dependencies and solve block corruption
You are a rock! :) but don't understand my table re-creation did not work :(
Dec
27
accepted Drop table without its dependencies and solve block corruption
Dec
27
comment Drop table without its dependencies and solve block corruption
you are great! but I will check your solution now... but a little thing I did not understand. While I dropped the table containing corrupted block, and then recreated it with the same parameters the error still raised during the creation, according your reply during the re-creation the table the corrupted block should have been re-initialized and corrected, why not happened so?.(I did it before I read you post, will try now and write what happens)
Dec
24
awarded  Popular Question
Dec
21
comment Drop table without its dependencies and solve block corruption
@MindaugasRiauba you are right, after dropping a table corrupted blocks are still corrupted. I've read somewhere on the internet that after dropping a segment containing the corrupted block solves the corruption but it is not in 10g Oracle as I see. If I don't have backup how can I solve this problem? Can I move segments from this datafile to another one and drop this datafile after that?
Dec
20
comment Drop table without its dependencies and solve block corruption
I've tested now and if you drop all constraints, then drop table .. child records remain itself :)
Dec
20
asked Drop table without its dependencies and solve block corruption