451 reputation
417
bio website dba010.wordpress.com
location Tbilisi, Georgia
age 22
visits member for 1 year, 10 months
seen Apr 5 at 12:57
stats profile views 78

I am OCA and I work as a DBA at JSC Bank of Georgia.


Jun
28
comment Incremental level 1 backup with no Incremental level 0?
one more question: Do I need to indicate recovery windows in RMAN?
Jun
28
comment Incremental level 1 backup with no Incremental level 0?
thank you for you responce. But the following sentence confuses me: "copies all blocks that have been changed since the file was created" Which file is mentioned? which file was created? Thank you
Jun
28
accepted Incremental level 1 backup with no Incremental level 0?
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.