559 reputation
1927
bio website dba010.wordpress.com
location Tbilisi, Georgia
age 23
visits member for 3 years
seen Jun 17 at 8:00

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


Jun
27
comment Incremental level 1 backup with no Incremental level 0?
@LeighRiffel I have already tested and after crosscheck it made inc 0 backup first and then inc 1. (without crosschek it makes inc 1 just) I just wonder to know how you do when using Netbackup as backup server. Do you use crosscheck in backup script? I was not using crosscheck but after founding that inc 1 may be done with no errors even u don't have inc 0 which means that you are not able to restore database because u don't have all backups AND you don't know about this! :(
Jun
27
accepted Change Oracle IP
Jun
27
asked Incremental level 1 backup with no Incremental level 0?
Jun
27
answered Incremental backups - differences
Jun
14
comment Change Oracle IP
thank you for your response. In these files there are written IPs, not domain names.
Jun
11
asked Change Oracle IP
May
30
comment How to troubleshoot enq: TX - row lock contention?
@Phil I have sql_id for both but still don't know the exact blocking statement because is contains bind variables. That are not captured in v$sql_bind_capture.I have added some info in "Additional Info" section in my post above, please see.
May
30
revised How to troubleshoot enq: TX - row lock contention?
added 816 characters in body
May
30
asked How to troubleshoot enq: TX - row lock contention?
May
11
accepted My database dramatically increased in size. Why?
May
11
comment My database dramatically increased in size. Why?
@ipip Haven't yet. Now I am analyzing archived log files using Log Miner.
May
11
asked My database dramatically increased in size. Why?
May
7
asked Is commit necessary after DML operation in Function/Procedure?
May
7
comment How to schedule function in Oracle?
that was what I wanted to read thank you...
May
7
accepted How to schedule function in Oracle?
May
7
comment How to schedule function in Oracle?
I have added some lines in my post, please see and help me. Thank you a lot.
May
7
revised How to schedule function in Oracle?
Additional information, to better clarify the situation.
May
7
comment How to schedule function in Oracle?
Current user........
May
7
comment How to schedule function in Oracle?
It says: ORA-06550: line 1, column 729: PLS-00221: 'AUD_CLEAR_FUN' is not a procedure or is undefined ORA-06550: line 1, column 729: PL/SQL: Statement ignored ORA-06512: at "SYS.DBMS_ISCHED", line 185 ORA-06512: at "SYS.DBMS_SCHEDULER", line 486 ORA-06512: at line 2 View program sources of error stack?
May
7
comment How to schedule function in Oracle?
it means that I cannot schedule function, right? I have opportunity to call procedure but not function?