578 reputation
21334
bio website dba010.wordpress.com
location Tbilisi, Georgia
age 24
visits member for 3 years, 5 months
seen Dec 19 at 11:55

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


Jan
17
asked ORA-03137: TTC protocol internal error
Jan
16
revised ASM drop disk hangs (STATE DROPPING)
syntax correction
Jan
16
comment ASM drop disk hangs (STATE DROPPING)
@MindaugasRiauba after running ocrconfig -showbackup it showed me 5 backups named: backup00.ocr, backup01.ocr, backup02.ocr, day.ocr, week.ocr. Which one should I save to another place?(for safety)
Jan
16
revised ASM drop disk hangs (STATE DROPPING)
Some findings are added
Jan
16
comment ASM drop disk hangs (STATE DROPPING)
@MindaugasRiauba No there is not. Just one question about these files. Do I have to backup OCR and votedisk?
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