568 reputation
21132
bio website dba010.wordpress.com
location Tbilisi, Georgia
age 24
visits member for 3 years, 3 months
seen Oct 21 at 7:31

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


Feb
7
comment What problems can be caused by dropping a rollback segment manually?
@Phil Thank you. Your query returns nothing.
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
I found that segments with PARTLY AVAILABLE statuses contains an active dead transactions.
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
When I query status column of dba_rollback_segs view, filtering by UNDOTBS2, it shows me that most of them are OFFLINE and others are PARTLY AVAILABLE. If I drop OFFLINE segments, why it should be a problem?
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
@MindaugasRiauba I have undo retention 24 hours. It is already 1 week I've deleted node from the RAC.
Feb
7
comment What problems can be caused by dropping a rollback segment manually?
@Phil I am going to follow, these are just examples.
Feb
7
asked What problems can be caused by dropping a rollback segment manually?
Feb
5
comment ORA-13901 Object UNDOTBS01 was not found. ORA-06512: at “SYS.DBMS_SERVER_ALERT”, line 7
@Phil I have the full installation of 11.2.0.3. Can I upgrade my 11.2.0.1 database using this installation? Or do I need to download the patch? Is the patch software different from the fresh installation? Does runInstaller of the fresh installation have the option like upgrade? And is the patch(11.2.0.1->11.2.0.3) different from the patch(11.2.0.2 to 11.2.0.3)?
Feb
4
asked ORA-13901 Object UNDOTBS01 was not found. ORA-06512: at “SYS.DBMS_SERVER_ALERT”, line 7
Jan
28
accepted Oracleasm deletedisk failed Unable to clear disk
Jan
22
asked Advice to set minimum preferable value for MEMORY_TARGET
Jan
21
awarded  Popular Question
Jan
20
answered Oracleasm deletedisk failed Unable to clear disk
Jan
20
revised Oracleasm deletedisk failed Unable to clear disk
Investigation, more info
Jan
20
revised Oracleasm deletedisk failed Unable to clear disk
More detailed output
Jan
20
asked Oracleasm deletedisk failed Unable to clear disk
Jan
17
comment ORA-03137: TTC protocol internal error
@Phil I have 11.2.0.1.0
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