About me
KAMRAN AGAMEHDI AGAYEV
I’m an Oracle ACE and Oracle Certified Professional DBA with 7 years of experience managing UNIX- based Oracle Databases.
As a working IT professional, I have experience in a wide range of mission critical technologies, specializing in database administration best practices for backup and recovery. I have hands-on experience with real-world Production environments and have risen in the ranks from a developer to a managing DBA.
Currently I’m working at AzerCell Telecom as an Expert DBA and serve as an adjunct professor teaching Oracle Database Administration in a Qafqaz University.
I’m an author of upcoming book – “Oracle Backup & Recovery: Expert secrets for using RMAN and Data Pump” and also publish a popular blog at http://kamranagayev.com
I also presented at Oracle OpenWorld conference twice (2010/2011) at San Francisco, and at the TROUG (Turkish Oracle User Groups) event at Istanbul at 2011.
I’m available at Twitter, Facebook , Linkedin and MSN
July 1st, 2009 at 3:55 pm
hi sir,
i am impressed by your remarks for my question in oracle forums.
i am just about to be graduated.
can please help in guiding my career in your foot steps.
i am also very much instrested in working on oracle.
i am currently preparing for ocp fundamentals exam.
lokking forward for your reply.
regards sunil
July 4th, 2009 at 2:27 pm
Hi Sunil
I’d suggest you to read documentations and some Oracle books. Refer to tahiti.oracle.com and there you can find 2 Days Administration Guides which will guide you through the basic administration tips
Moreover, you should practice a lot. Without practicing, you will not be able to learn more
I’d suggest you to refer to Oracle Ace Tonguc Yilmaz’s well written article, related with Oracle Introduction for newbies. You can find it from below link:
http://tonguc.files.wordpress.com/2009/06/oracle-introduction-for-newbies.doc
Good Luck. Keep reading, practicing and asking your questions (of course after google-ing it
) on OTN forums 
July 10th, 2009 at 4:33 pm
Privet Kamran!
tebya pozdravliyayu iz za tvoy krasiviy blog. ya tebya iz oracleturk yahoo group znayu… u menya nick ‘ordba’ i moy blog: http://www.ordba.blogspot.com … ti j azeri i ya znayu shto ti toje znayesh russkiy yazık, iz za etogo hatel tebya po ruskiy pisat.. tak j interesno
)
esli sprosish, ya v kırgızstane uchilsya 5 let, poetomu znayu po ruskiy i uje 9 let gavaryu…
xarosho shto u tebya uje est OCA i OCP sertifikat… nedeyus u menya toje budet skora, no poka ne dumayu..
poka, tebya poka.
July 10th, 2009 at 6:40 pm
Oooo Privet Orhan. Kak dela?
That’s perfect!
Mashallah vidno shto russkiy ti otlicno znayesh
Cok memnun oldum sen blog-umda gormeye Orhan. Comment icin, ilgin icin sana tesekkur ediyorum
Blogu tez tez ziyaret et. Gorusuruz kendine iyi bak (Commentim 4 dilde oldu 
)
Inshallah sen de imtahana hazirlasib o sertifikalari alarsan. Onemli olan sertifika deyil, onemli olan bilgi, ve tecrubedir
Sene uqurlar arzulayiram
August 9th, 2009 at 8:28 pm
Hi Kamran Agayev,
I need the links for Books on RMAN backups and on Datapump.
And i need some critical scenarious which we face as DBA.
Thanks & Regards,
Krishna
August 10th, 2009 at 9:06 am
Hi Krishna. The link of the book is on my home page
But this book hasn’t finished yet, so when it’ll be finished, I’ll inform you
In this book, you’ll see many different scenarious which every DBA may face in his career
October 26th, 2009 at 10:45 am
hello kamran. i want to learn oracle and start a career as dba. i am a rhce. but am confused which exam i will go for. will i go for 9i dba exams or 10g dba exams particularly. and there is also 11g. plz advice me which way to go? i also want to learcn rac. and another q, is it necessary to learn pl/sql if i work as dba.
thx for this wonderful blog. i have completed installing 10g on centos 5.3 using virtualbox v3.
October 28th, 2009 at 10:51 am
Hi aniruddha and welcome to my blog
If you’re at the beginning of Oracle career, don’t try to start from exam. Try to read some docs (Administrators Guide and Concept) from http://tahiti.oracle.com
Then, I’d suggest you to read Sybex books to prepare to Oracle exams. Yes, there’re mainly 3 different versions in Oracle which you can give an exam. 9i is not supported version of Oracle but to be more successful, I’d suggest you to start learning from 9i. Because there’re many things that were automated in 10g. By starting from 10g or 11g, you may be aware of some Oracle features (especially in Performance Tuning). It’s my suggestion. But you can even start from 11g. It’s the new supported version
But remember, to be 11g OCP by having any 9i or 10g exam, you’ll need to pass only one “New Features” exam. It’s the same for 10g. If you passed 9i exams, you’ll need to pass only one exam to be 10gOCP and another one exam to be 11gOCP
It’s necessary to know SQL and PL/SQL to be successfull DBA. You don’t need to learn PL/SQL at developers level, but you need to know some basics as well
Good Luck!
October 31st, 2009 at 12:57 am
thx a lot kamran for ur suggestion. i will surly start from oracle 9i.
February 11th, 2010 at 5:56 pm
Salam Kamran muallim . Man ozum Java proqrammistam . Lakin hala hech vaxt Oracle-la islamamisam . Esasen MySQL -le ishlemisem . Database-ler haqqinda yaxshi melumatim var .PL/SQL-i ise bilmirem .
)
1. Siz mana hansi kitablari maslahat gorerdiniz ki baslayim oxumaga ?
2. Eger praktiki masalalarda tetbiq ede bilmeyecemse oxumagin na daracada faydasi olacaq (sadece bizim proyektde Oracle tetbiq edilmir
February 17th, 2010 at 11:42 am
Salam Rufat
Evvela sen ozune kankret bir yön secmelisen. DBA olmaq isteyirsen yoxsa Developer? Onlar ferqli ferqli seylerdi. Eslinde her DBA bir developer kimi development-i bilmelidi (bu Oracle-da beledi). Amma her Developer ise DBA kimi administration bilmese de olar
Eger bundan sonra Java-ya davam edeceksense, onda Oracle baresinde besit administration biliklerini menimseyib esas Development-e guc vermelisen. Yeni SQL ve PL/SQL dillerini advanced seviyyede menimsemelisen
Bu berede kitablar coxdu. En tovsiye etdiyim kitab, “PL/SQL by examples” kitabidi (fourth edition). Web-den pdf versiyasini tapib oxuya bilersen.
O ki qaldi praktika meselesine, bu umumi bir problemdi. Tek bizim olkede yox, butun dunya olkelerinde demek olar ki beledi. Sen menim sene tovsiye etdiyim kitabi tap, oxumaqa bashla. Orada olan butun misallari ozunde tetbiq et. Sonra her hansi bir sirketde PL/SQL isine uyqun olaraq Junior isci kimi ise bashlayib gelecekde istedyin praktikani yiqacaqsan
Uqurlar
March 1st, 2010 at 9:59 pm
Hi,
Excellent Blog !
Basically I m pursuing BE Computer Engg. , and I have lot interest in Database, Datawarehousing & Data Mining.
I want to pursue my career in DB Administration or Warehousing.
Q.1 : Is BE + OCA sufficient for starting career in databases ?
Or are there any other courses that can help me get into Dataware housing ?
Q.2 : What is scope as fresher ? What things I need to consider for getting entry level job as junior DBA ?
Thanx for ur help in advance.
Hope ur advice helps me brighten up my future…..ofcourse as DBA
March 2nd, 2010 at 7:26 pm
Dear Tanny
I think that you’ll start your Oracle career as a Junior DBA. But one thing should be mentioned that administering VLDB (Very large database – data warehouse) and OLTP systems are different. So you need to make a decision for that.
I’d suggest you to read documentation, read some certification books and practice, practice and practice
Good Luck !
March 6th, 2010 at 10:39 am
Thanx a lot sir…..!
Just one more thing…can u suggest me some books which can help me for practicing at home as I have opted for self-study mode….
Or should I continue with certification books from oracle press ?
March 29th, 2010 at 9:19 pm
My name is Piter Jankovich. oOnly want to tell, that your blog is really cool
And want to ask you: is this blog your hobby?
P.S. Sorry for my bad english
March 30th, 2010 at 1:09 pm
Hi Piter and welcome to my blog
I’m blogging because I love it. I love to help people and share my knowledge. It’s my hobby and way of life
April 1st, 2010 at 11:39 am
Salam o alikum,
You are simply impressive. May Allah bless you more success in life.
Regards,
Nadeem Hameed
Saudi Arabia.
April 1st, 2010 at 12:09 pm
Va aleykum Salam Nadeem
Thank you for your comment and may Allah bless you
April 15th, 2010 at 11:58 pm
Hello Sir,
Iam a newbie to oracle 10g,i want to make a career in dba and dba most imp job is to keep the data secured and available,sir can i refer your book “BACKUP and RECOVERY”..
April 16th, 2010 at 11:10 am
Hi Don
What do you mean with “refer”? I hope you need a pdf version of the book, but unfortunately it’s not available as the book hasn’t finished yet. Good Luck
April 22nd, 2010 at 2:10 am
Salam Kamra mlm. Seminarda verdiyiniz kitablarin adlari ve sertifikat ucun gosterdiyiniz addimlar cox iwe yaradi.
En azindan indi haradan bawlayib haraya gedeceyimi cox yaxwi bilirem.
Bunlara gore cox sag olun.
Blog uda cox beyendim.
Inwallah daha boyuk ugurlara imza atarsiniz
April 22nd, 2010 at 8:26 am
Salam Babakisiyev
Bu yolda cox kicik de olsa sizlere yardimim deyibse, bu cox sevindirici bir haldir
Uqurlar
April 24th, 2010 at 8:59 pm
Salam Kamran mlm.
Kamran mlm sizin dediyiniz kimi exam topics print etdim.
Ve 2 Day DBA oxumaga bawlamiwam. Artiq 60 sehifeden cox oxumuwam ve demek olar ki oxuduqlarimi anlayiram.
Sizce men exam topic deki movzulari bawdan bawlayib axtarim ve oxuyum, yoxsa 2 Day DBA deki topic ardicilligini izleyim?.
April 28th, 2010 at 12:19 am
As’salaamualikum Brother
Dear Kamran,
I recently happened to come across your Blog , Your effort is a source of inspiration & quite helpful for newbie like me seeking career as an Oracle DBA. Ma’sha Allah..
Thank You . May Almighty reward for your effort & keep up the good work
Jazakallah Khair
April 28th, 2010 at 9:04 am
Va aleykum salam dear Zeshan and thank you for your kind words
I’m so happy that my blog posts really help you and I’ll try to not give up and go on with new interesting posts
Thanks again.
May 4th, 2010 at 7:08 pm
Kamran selam,
Bugun Oracle Ace oldugunu ogrendim, cok sevindim. Basarılarının devamını dilerim.
En kısa zamanda gorusmek uzere
Zekeriya Besiroglu
May 4th, 2010 at 7:16 pm
Ilginiz icin tesekkur edirem Zekeriya bey. Sizin egitimlerinize katilmamin bu basarida rolu vardir
Kendinize iyi bakin.
June 8th, 2010 at 3:10 am
HI Kamran,
how in the world are you able to obtain multiple Oracle certifications, author books for Rampant Press, teach Oracle admin courses, and pursue a PHD? You are definitely an inspiration for me.
Regards,
Oraclelearner
June 12th, 2010 at 10:31 am
Man, you can speak 5 languages. Too Good !!!
June 12th, 2010 at 12:36 pm
Yes buddy
Now willing to learn some French, they have so romantic language 
July 24th, 2010 at 8:38 am
Dear Mr. Kamran Agayev,
Nice to know you, i’m from indonesian. Would you like to help me…I have problem with my oracle database. My Server harddisk was broken but i can recovery the data back. I have installed new OS and oracle 10g in new harddisk. Can I replace the datafile with my old datafile ?
Thank you sir
Regards,
Samuel Eric T
July 25th, 2010 at 2:24 pm
Dear Samuel
If you have RMAN backup you can perform disaster recovery and recover the database on the different server. Look at the following video tutorial:
http://kamranagayev.wordpress.com/2010/03/29/rman-video-tutorial-series-performing-disaster-recovery-with-rman/
Moreover, you can rename datafile using ALTER DATABASE RENAME FILE in the MOUNT stage
Good Luck
July 26th, 2010 at 2:48 pm
Dear Mr. Kamran Agayev,
Hello sir, would you like to help me ? When I connect to oracle 10g by TOAD or connect by sqlplus, I got this message :
ORA-01578: oracle data block corrupted (file # 1, block # 38557)
ORA-01110: data file 1: ‘c:\oracle\product\10.2.0\oradata\orclkdi\system01.DBF’
I have no backup for system01.dbf datafile. Can you give some information to fix it ?
Thanks you very much.
Regards,
Eric Tololiu
August 2nd, 2010 at 3:12 pm
Dear Eric
Why you don’t have backup of the SYSTEM tablespace? Don’t you know that if you lose the SYSTEM tablespace without having its backup, it means that you lost your database at all! Be careful and take dailiy backups (I hope you’re currently running on the test db)
If you haven’t backup of the database and you got a Data Block error, use DBMS_REPAIR to mark the block corrupted. For this, you need to create a REPAIR_TABLE using DBMS_REPAIR.ADMIN_TABLES procedure. Then use CHECK_OBJECT procedure to look for the corruption and update REPAIR_TABLE. Then use SKIP_CORRUPT_BLOCKS to tell Oracle to skip the corrupted blocks and use FIX_CORRUPT_BLOCKS to mark the block as a software corrupted
August 31st, 2010 at 11:22 am
I am an experienced DBA and happened to see your blog. Amazing how you keep up with the blog, authoring a book and pursuing a PhD. Inspiring indeed! Keep up the good work.
September 8th, 2010 at 3:28 pm
Dear sir,
i am impressed by your remarks for my question in oracle forums.
i am just about to be graduated.
can please help in guiding my career in your foot steps.
i am also very much instrested in working on oracle.
i am currently preparing for DBA 9i sql, fundamentals exam.
lokking forward for your reply.
September 8th, 2010 at 3:42 pm
Hi dear Tausif
If you want to be an Oracle DBA, you need to read a lot and practice everything you read. I’d suggest you to start reading documentation (Concepts and Administrators Guide) from http://tahiti.oracle.com address. Next, install Virtual Machine, Linux and Oracle and start practicing what you read (you can use my video tutorials as well)
Moreover, read the following .doc file written by Tonguc Yilmaz
http://tonguc.files.wordpress.com/2009/06/oracle-introduction-for-newbies.doc
Good Luck!
December 10th, 2010 at 12:26 am
Dear kamran,
is it important for dba’s to analyze projects and creating db logical design for projects.. i am getting problem for creating tables for projects…and normalization also….is it important for me…i am doing 10g ocp..i like to work in oracle….reply me soon.
December 13th, 2010 at 1:51 pm
Dear MadhanKumar
Sure, it’s your duty to create such objects, to make logical db design and etc. as a experienced DBA
So I’d suggest you to read basics of Relational Database Systems
December 14th, 2010 at 4:34 pm
Salam Kamran bey. Size bir sualim var. Neye gore bizim sizin kimi, Teymur Haciyev ve digerleri kimi Oralce uzre mutexessislerimiz ola ola yerli kurslar xaricden mutexessis devet edirler? Mence onlara az pul vermirler. Hemin pulu bizimkilere versalar(meselen size) daha yaxsi olmaz?
December 14th, 2010 at 4:45 pm
Salam Rovshan
Oracle Approved kurslarinda ders demek ucun kursdan asili olaraq 3-5 gun ard arda 6-8 saatliq ders demek ucun vaxt lazimdir. Shexsen men, hal hazirda calisdiqim shirketde (AzerCell) kursda ders demek ucun bu qeder vaxtliq icaze almaqim qeyri mumkundur. Ancaq onu da qeyd edim ki, bir il once bashqa shirketde ishlediyim halda bu vaxtim var idi, SoftLine-a bunu teklif etdim, cox sevindiler, lakin mesele yene hell olunmamis qaldi. Sebebini mence hec ozleri de bilmir …
February 4th, 2011 at 12:13 pm
Hi Kamran,
I hope you’re well. Is there any chance of you modifying your WordPress settings so that your full articles show up in the feed? This can be changed in Settings -> Reading -> “For each article in a feed, show”.
Thanks in advance for considering it.
Regards,
Martin
February 4th, 2011 at 12:17 pm
Hi Martin. Nice to meet you
I’ve changed it
Take care and keep in touch!
February 9th, 2011 at 7:13 am
Hi Kamran,
I show your Vidio Tutorial and it is very very useful. Thanks for sharing.
I request you to please share a vidio tutoria for Performance Tuning.
Regards,
Nirav
March 27th, 2011 at 10:52 am
Salam Kamaran,
After seeing ur blog, i was really impressed, i worked in various platform(Sun solaris, Suse linux,IBM aix) and also different version of DB, quite played some Developer role as well.
But after seeing ur blog, i am changed my mind to do only core DBA activity. Need more posts of the real time scenarios from side will help all our DBA community.
Kindly increase ur posting (thrice in a month) of the DBA Real time scenarios. (Hope its hard)
my heartful thanks for ur great effort and best wishes.
Regards,
Abdul kalam.
March 29th, 2011 at 9:10 am
Dear Abdul Kalam
I’m very happy that my articles are helpful! Thanks for feedback and wish you every success in your DBA career!
April 7th, 2011 at 12:11 pm
Excellent work n experience keep it up !!
April 25th, 2011 at 1:14 pm
hi sir,
i am completed oracle 10g ocp certification.now i am looking for a oracle 10g dba junior jobs in dubai-uae.how to get the jobs and how to prepare for the interview.
pls guide me.
thank you,
suja
May 23rd, 2011 at 4:16 pm
hi Kamran
i am very impresssive saw your video scanrio and
i want to learn Oracle Datagarud. can give oracle data garud video links
my heartful thanks for ur great effort and best wishes.
Ahamed
May 27th, 2011 at 12:12 am
Hi Ahamed. You can check my video tutorial, there’s already a step by step guide on creating a Standby database using RMAN
http://kamranagayev.wordpress.com/oracle-video-tutorials/
Good Luck!
July 26th, 2011 at 5:10 pm
Hi Sir,
The Book which you are writing Now. When it will get released????. The release date for this book is July 2011. I am waiting for this book since last 6 Months.
regards
Roshan
August 30th, 2011 at 8:33 am
Assalam Alikum
i am Riaz and i am working as an Oracle DBA and Trainer. i am 9i,10g,11g OCP now i want to give Oracle OCM.
please help me for this
allah hafiz
–Riaz
October 26th, 2011 at 10:41 am
CV-ye baxdiqca fexr hisleri keciririk
November 18th, 2011 at 4:44 pm
Hi Kamran,
I could resolve many of my oracle admin related queries through this blog. Nice efforts.
Thanks
Saurabh
sbhoracle.wordpress.com
November 20th, 2011 at 4:44 pm
Hai kamran,
Thanks for your kind information which u r posting for us…
and i had installed OEL4 in VMWare and i am trying to connect through putty ..
i am not able to connect its giving error. network error.
please give me step by step process how to do that…
my mail id: aslam2510@gmail.com
Thanks & Regards,
Aslam Khan
December 1st, 2011 at 8:36 am
Aswk Sir, MAY ALLAH give you more Knowledge to share with us . I am very glad about your Achievements . I am trying to learn Oracle DB completed OCA(10g) & waitng to be OCP. Sometime i loose my confidence becz i am not getting job in this field mean want to work on Real project.
Will you tell me how we can create more than one instance ?
Pray for my Career in Oracle DB.
KHUDA-HAFIZ
December 1st, 2011 at 8:39 am
Will wait for your Suggestion for my Carrer in Oracle DBA.
I want to become OCM.
December 9th, 2011 at 7:24 am
You need to be a little bit patient, because no one gets job immediately after learning something. Try to read more and more, make practices, apply for open jobs and you’ll definetly success
January 12th, 2012 at 11:37 am
Hi Kamran,
Happily I would like to let you know that I am authoring a book on Oracle 11g Advanced PL/SQL concepts with PacktPub publishers. I would like to seek your help in reviewing process. I would be happy if you could extend your support in this regard or refer somebody to carry on the content reviewing task. I shall be obliged.
Thanks
Saurabh
sbhoracle.wordpress.com
January 13th, 2012 at 2:54 pm
Hi Saurabh, nice to meet you
I can review your book, so feel free to contact me
February 2nd, 2012 at 12:02 pm
Respected sir,
I have recently completed my ORACLE 10g OCP certification training.And my exams for certifications are going to be completed in next week.
I have referred you blog and I found it very much useful for a newbee or an experienced DBA as well.It is very much helpful.
I have also downloaded all the videos and installation material provided by you on your blog.And I am awaiting for your upcoming book:
Oracle Backup & Recovery:
Expert secrets for using RMAN and Data Pump
Kamran Agayev Agamehdi & Aman Sharma
I think these will be very much helpful to all DBA persons to learn something new about the Backup and Recovery techniques.
I want to know something about how to take backup of recovery area into tape for disaster recovery.I have watched the video provided by you for Disaster recovery for disks.I also want to learn about: disaster recovery of the backup we have taken.
If you can provide some good material or a video for this so that I can get some idea.And It may be helpful for others as well.
Thank you for hearing from me.
Best Regards,
Hardik B Jethava
phone: +91-9033421584
Email: hardikjethava@yahoo.com
hardikjethava1@gmail.com
February 14th, 2012 at 12:09 pm
Hello sir,
I want to find out session details which are log in and log out since last 4 hours without auditing enabled ??
Can I do this thing??
Thank you
February 14th, 2012 at 12:49 pm
No you can’t
February 14th, 2012 at 1:30 pm
Ok sir.
thank you.
February 16th, 2012 at 10:56 pm
Salam Brother.
This is really helped me alot. I really appreciate your help.
Thanks,
Akbar