Good video tutorial on “Performing disaster recovery with RMAN”.
I have a question for you… What if the destination mount points are different? How the RMAN Performance the recovery with different destination mount points?
Hello Kamran,
I would like to get your feedback on the flashback archive (total recall) feature on 11gR2. I am trying to test it on 11gR2 on linux x86-64 and it is not working. The documentation does not demand any special setting on the database or init parameters.
All I am doing is to create a tablespace, create a flashback archive and put a table under FBA mode. First of all the history tables are not being created. Then the FBDA background process dumps ORA-00942 error trying to find out the “supposed to be available” history tables..
Have you tested this on single instance and RAC?
On a single instance, this seems to take a while to create the history tables. Only after performing DML activity on that table,the tables are created. Do you have any insights? Any help would be appreciated.
Yes, I did see that. Would you tell me what was OS you tested on? I tested on a single instance 11gR2 and it created those history tables after a while. But it did create those tables.
When I tested on our development environment which is a 3 node RAC, it is not at all working. I have a SR open on this issue and awaiting response.
Did you observe the SYS_FBA tables as soon as you put your tables on FB mode? There is definitely an issue here. Please let me know your observations on this.
Thanks
Kumar
Hi ,
Sir iam trying to install oracle10g on OEL 5.5 …….but in my case when i run ./runInstaller it takes my ORACLE_HOME as
u1/oracle/oracle/product/10.2.0/db_1 then i browse it and make it as
u1/oracle/product/10.2.0/db_1 then i start with installation and when it is been prompted to logged in as root and execute the script first one i execute the second where u hve shown i.e cd $ORACLE_HOME/ when i execute iam not taken into db_1 directory Sir iknow iam going some where wrong so can u pls rectify me or tell me where am i going wrong
Hi,
Well ,I visit your video blog its very useful .. Thank u So much for your valuable effort . Keep uploading interesting things Even i forwarded the link to my all friend who r all career related to Oracle.
Hello Kamran Sir, thank you very much for these awesome informative videos of Oracle ASM and Grid control. Appriciate your help for posing these videos as always.
I was wondering if you have any Performing Disaster Recovery with RMAN tutorial for windows. Looks like the one you have is in linux. Sorry if this is an ignorant question.
I am Lekha from India.I am very much interested in learning oracle dba stuff.As I am a newbie for this domain.I request you to suggest me some topics where I can start up and also I request you to provide me some links or documents where I can learn the basic things.
I have oracle 10gR2 in my system using VMWare I installed it.Now I wanted to upgrade that from 10g to 11g release 2.So,I request you to please provide me the steps of upgrading from 10gR2 to 11gR2.?
Thanks Dear Kam
What is difference in creating RAC on VMware Server or VMware Workstation and which one is preferred and why
Do you have some video of Oracle RAC which can help in going through to Oracle RAC
Thanks in advance
This week I’m going to post a very long, step by step explained guide for installing Oracle RAC on vmware. For the next week, I hope I’ll post its video tutorial as well
HI THIS IS RAVI I AM A TRAINER DBA I WANT TO LEARN 10G RAC OR 11 RAC PLEASE — I DON T KNOW HOW TO INSTALL
AND HOW TO GET ALL SOFTWARE REGARDING RAC -CRS OR RAC PLEASE SUGGEST ME FROM WHERE I GET THAT SOFTWARE
AND STEP HOW TO INSTALL IF VIDEO IS THERE IT IS GOOD FOR ME PLEASE LET ME KNOW I M WAITING TO YOUR RESPONSE.
I HAVE 1LAPTOP AND I CAN ARRAGE 1 SYSTEM ALSO PLEASE PLEASE TELL ME HOW TO INSTALL RAC AND CRS SOFTWARE
WHAT IS THE BASIC REQUIREMENT FOR THAT ,IF BOOK IS THERE IT IS GOOD.
Kamran your doing a good job,God bless your work if you believe in HIM!
But some of the VIDEO Tutorials (if not all) don’t have clear sound (low volume). Please can you rectify on this b’coz I am in high demand of your video to improve my Oracle Database Expertize
Is it not possible to rectify on the current video tutorials, b’coz i need them, but they are disappointing me on volume especially these tutorial Installing ASM on Linux and Windows, and Installing Oracle 10gR2 Grid Control and deploying agent on Linux and Windows OS
I’ve seen a video tutorial for OCP certification, but don’t think that it really helps you to get the OCP certification. There’s only a voice in the background whcih reads a text and demonstrates some basic steps ,that’s all
I’d suggest you to read the documentation, make practices based on the subjects of the exam and read any certification book
Hello kamran , i saw your side that is very fantastic and clearly define regarding rman.
Kamran i have a facing problem regarding rman backup and recovery oracle 9i.
Can you help me. If you help me i would thankful to you.
– You can attend “Managing Oracle database on Linux” Oracle University
– Install and configure RAC, start reading documentation and make practices
– Read books that’re written for RAC on Oracle. The first one is the book “Real Application Clusters Handbook” for Gopalakrishnan, and the second one RAC for 11g “Overview of Oracle 11g R1/R2 Real Application Clusters Essentials” for Syed Jaffar Hussein http://www.packtpub.com/oracle-11g-r1-r2-real-application-clusters-essentials/book
Allah razı olsun qardaş.bu əməyin əvəzi inşallah cənnət olsun.çox həvəsli işləyirəm sizin tutoriallarla.inşallah bunların sayını artırmaq lazımdı biizniallah
I am new to oracle world , i want to become Oracle DBA, so how should i start and how should i prepare for it . plz give me some useful material and videos to get knowledge.
Can you please post the videos for the below topics. I would be more happy to follow your blog as it gives immense energy and confidence when we listen your videos and articles.
Explain the general architecture of Oracle Data Pump
Use Data Pump Export and Import to move data between Oracle databases
Girish said
Hi Kamran Agayev,
Good video tutorial on “Performing disaster recovery with RMAN”.
I have a question for you… What if the destination mount points are different? How the RMAN Performance the recovery with different destination mount points?
Thanks..
Kamran Agayev A. said
Hi Girish
In such case you’ll SET NEWNAME FOR DATAFILE 1 TO ‘/filename’ command to change the default location of the specified filename
Badr said
Awsome tutorial! Very comprehensive and very well commented!
Loved it! Can´t wait for the next one.
Girish said
Thanks Kamran for your reply.
I have some more question.
Rman backup has been taken with nocatalog
source rman backup: /u01/backup/rman
This rman backup has to be restored on a remote server with different mount points. How this can be carried out? Please provide steps.
Thanks
Girish
Kamran Agayev A. said
Dear Girish
For this you need to use SET NEWNAME FOR DATAFILE command as it’s explained in the following documentation:
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/recov004.htm#sthref585
Nesimi said
Tesekkurler Kamran bey
Roshan Fanse said
Hi Kamran,
Just want to know when is your Oracle Backup and recovery book will be available in the market.
I really want to buy that book.
Please reply as soon as possible.
Thanks
Roshan
Kamran Agayev A. said
Hi Roshan
It should be available for the March 2011
shahid said
could u please provide me a link for video trainning for implementing oracle streams………
Javid said
Teshekkurler!!!
Kumar Ramalingam said
Hello Kamran,
I would like to get your feedback on the flashback archive (total recall) feature on 11gR2. I am trying to test it on 11gR2 on linux x86-64 and it is not working. The documentation does not demand any special setting on the database or init parameters.
All I am doing is to create a tablespace, create a flashback archive and put a table under FBA mode. First of all the history tables are not being created. Then the FBDA background process dumps ORA-00942 error trying to find out the “supposed to be available” history tables..
Have you tested this on single instance and RAC?
On a single instance, this seems to take a while to create the history tables. Only after performing DML activity on that table,the tables are created. Do you have any insights? Any help would be appreciated.
Thanks
Kamran Agayev A. said
Dear Kumar
Have you read my article on Flashback Data Archive?
“https://kamranagayev.wordpress.com/2010/07/21/oracle-flashback-data-archive-total-recall/”
I’ve shown a real-world demonstration on this feature
Kumar Ramalingam said
Yes, I did see that. Would you tell me what was OS you tested on? I tested on a single instance 11gR2 and it created those history tables after a while. But it did create those tables.
When I tested on our development environment which is a 3 node RAC, it is not at all working. I have a SR open on this issue and awaiting response.
Did you observe the SYS_FBA tables as soon as you put your tables on FB mode? There is definitely an issue here. Please let me know your observations on this.
Thanks
Kumar
kavita yadav said
Hi ,
Sir iam trying to install oracle10g on OEL 5.5 …….but in my case when i run ./runInstaller it takes my ORACLE_HOME as
u1/oracle/oracle/product/10.2.0/db_1 then i browse it and make it as
u1/oracle/product/10.2.0/db_1 then i start with installation and when it is been prompted to logged in as root and execute the script first one i execute the second where u hve shown i.e cd $ORACLE_HOME/ when i execute iam not taken into db_1 directory Sir iknow iam going some where wrong so can u pls rectify me or tell me where am i going wrong
Regards & Thanks
Kavita
Kamran Agayev A. said
Dear Kavita
Please follow my video tutorial and you’ll definetly success with installation
sharravanan said
Hi,
Well ,I visit your video blog its very useful .. Thank u So much for your valuable effort . Keep uploading interesting things Even i forwarded the link to my all friend who r all career related to Oracle.
Kamran Agayev A. said
Thank you Sharravanan 🙂
Suman Das said
Hello Kamran Sir, thank you very much for these awesome informative videos of Oracle ASM and Grid control. Appriciate your help for posing these videos as always.
Amritesh said
Can you upload video regarding RAC configuration
Kamran Agayev A. said
Hi Amirtesh
I’m currently working on it
Ahmed said
Hi Kamran,
I was wondering if you have any Performing Disaster Recovery with RMAN tutorial for windows. Looks like the one you have is in linux. Sorry if this is an ignorant question.
Kamran Agayev A. said
Dear Ahmed
As most companies uses Oracle on Linux, I try to perform all my video tutorials on Linux
In windows it’s same, except you need to create a Windows Service using oradim utility
Lekha said
Hi Kamran,
I am Lekha from India.I am very much interested in learning oracle dba stuff.As I am a newbie for this domain.I request you to suggest me some topics where I can start up and also I request you to provide me some links or documents where I can learn the basic things.
Regards
Lekha
Kamran Agayev A. said
Hi Lekha
I would suggest you to start reading documentation from http://tahiti.oracle.com :
http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/toc.htm
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/toc.htm
Moreover, you can watch my video tutorials and have base knowledge on some practical Oracle administration
Bhoodev P Sharma said
Thanks Kamran for putting such a great effort to help others and
My self Bhoodev from India have find your documentation in good way
Thanks once again
Lekha said
Hi Kamran,
Thank you.Thankx a lot for the reply.I have one doubt using SQL Loader .How to upload xml files data using sql loader?
Regards
Lekha
Lekha said
Hi Kamran,
I have oracle 10gR2 in my system using VMWare I installed it.Now I wanted to upgrade that from 10g to 11g release 2.So,I request you to please provide me the steps of upgrading from 10gR2 to 11gR2.?
Awaiting your reply.
Regards
Lekha
Kamran Agayev A. said
Dear Lekha
You can try two ways:
– Using DBUA (Database Upgrade Assistan)
– Using manual way
I’d suggest you to follow the installation guide from the documentation:
http://download.oracle.com/docs/cd/E11882_01/server.112/e17222/toc.htm
Bhoodev P Sharma said
Thanks Dear Kam
What is difference in creating RAC on VMware Server or VMware Workstation and which one is preferred and why
Do you have some video of Oracle RAC which can help in going through to Oracle RAC
Thanks in advance
Kamran Agayev A. said
Dear Bhoodev
This week I’m going to post a very long, step by step explained guide for installing Oracle RAC on vmware. For the next week, I hope I’ll post its video tutorial as well
Imtiaz Syed said
Dear Kamran,
Thanks for your time & splendid work which is highly appreciated, Keep it up.
Kamran Agayev A. said
Thanks for feedback Syed
mehdi said
Hi Kamran,
I implemented a snapshot replication
can i sync it by export and import when data is out of sync
best reghrads ,
mehdi
ravi said
HI THIS IS RAVI I AM A TRAINER DBA I WANT TO LEARN 10G RAC OR 11 RAC PLEASE — I DON T KNOW HOW TO INSTALL
AND HOW TO GET ALL SOFTWARE REGARDING RAC -CRS OR RAC PLEASE SUGGEST ME FROM WHERE I GET THAT SOFTWARE
AND STEP HOW TO INSTALL IF VIDEO IS THERE IT IS GOOD FOR ME PLEASE LET ME KNOW I M WAITING TO YOUR RESPONSE.
I HAVE 1LAPTOP AND I CAN ARRAGE 1 SYSTEM ALSO PLEASE PLEASE TELL ME HOW TO INSTALL RAC AND CRS SOFTWARE
WHAT IS THE BASIC REQUIREMENT FOR THAT ,IF BOOK IS THERE IT IS GOOD.
REGARDS,
RAVI
FROM INDIA
ravi said
HI HOW TO INSTALL RAC
I DONT KNOW PLEASE TELL ME
Kamran Agayev A. said
Check my blog. I’ve a step by step tutoril on this which consists of 150 screenshots!
https://kamranagayev.wordpress.com/2011/04/05/step-by-step-installing-oracle-10g-rac-on-vmware/
You can downoad all software from http://www.oracle.com
Sadock said
Kamran your doing a good job,God bless your work if you believe in HIM!
But some of the VIDEO Tutorials (if not all) don’t have clear sound (low volume). Please can you rectify on this b’coz I am in high demand of your video to improve my Oracle Database Expertize
Kamran Agayev A. said
Hi Sadock
Sure I believe in Allah, Most Gracious, Most Merciful
Thanks for the feedback, I’ll try to increase the volume on my next video tutorials
Sadock said
Sorry Kamran
Is it not possible to rectify on the current video tutorials, b’coz i need them, but they are disappointing me on volume especially these tutorial Installing ASM on Linux and Windows, and Installing Oracle 10gR2 Grid Control and deploying agent on Linux and Windows OS
Sadock
shanmuk said
hi sir
am shanmuk
am thinking to write oca can u suggest me the book and if any videos available to self prepartion
Kamran Agayev A. said
Dear Shanmuk, it depends on which version you’re going to give the exam. Check amazon.com by searching “oracle exam guide” keywords
saheed said
dear kamran
Thanks for taking time to come up with site like this God will bless you. Please my
problem is not only RMAN . i have done my OCA certification 10g, and am willing to
do the OCP 10g(Admin ii 043) but i need the complete OCP video tutorial, to
enable me study for the exam. Though i have OCP texbooks but i comprehend
fastly with the video tutorial. i have done everything possible but could not get one.
I beg you in the name of God kindly help me. If there is anybody in the house that
can help. my email address is (silvadexy@yahoo.com)
Rashid Ali said
salam kamran brother plz send me video tutorial of oracle forms 10g plz
i am waiting
regards
Rashid Ali
Kamran Agayev A. said
Salam Rashid
I used Oracle Forms for some years, but now as I’m a DBA, I’m not using it and don’t have any video tutorial
Kamran Agayev A. said
Dear Saheed
I’ve seen a video tutorial for OCP certification, but don’t think that it really helps you to get the OCP certification. There’s only a voice in the background whcih reads a text and demonstrates some basic steps ,that’s all
I’d suggest you to read the documentation, make practices based on the subjects of the exam and read any certification book
Good Luck!
M. Arshad said
Hello kamran , i saw your side that is very fantastic and clearly define regarding rman.
Kamran i have a facing problem regarding rman backup and recovery oracle 9i.
Can you help me. If you help me i would thankful to you.
Please reply me and give me some issue solution.
Thanks.
M.Arshad
E-mail: arshad_0255@yahoo.com
gaurav nigam said
Hi Sir,
Thanks for uploading such a nice VT.
could u plese upload a video or provide any document related to Full Database Reorganization.
thanks in advance.
purvi patel said
Hello Sir
I must say your blog is much useful.
Thaks a lot
purvi patel said
Hello Sir,
I have some questions. Can u please tell me how can i learn managing oracle 10g on linux and oracle 10g RAC?
I am waiting
thank youu
Kamran Agayev A. said
Dear Purvi
Here are my suggestions:
– You can attend “Managing Oracle database on Linux” Oracle University
– Install and configure RAC, start reading documentation and make practices
– Read books that’re written for RAC on Oracle. The first one is the book “Real Application Clusters Handbook” for Gopalakrishnan, and the second one RAC for 11g “Overview of Oracle 11g R1/R2 Real Application Clusters Essentials” for Syed Jaffar Hussein
http://www.packtpub.com/oracle-11g-r1-r2-real-application-clusters-essentials/book
Good Luck!
purvi patel said
Thanks sir
Ashraf İslamsevər said
Allah razı olsun qardaş.bu əməyin əvəzi inşallah cənnət olsun.çox həvəsli işləyirəm sizin tutoriallarla.inşallah bunların sayını artırmaq lazımdı biizniallah
purvi patel said
Hello sir,
I am trying to create partitions on redhat 5 which i have installed in virtual box for practice.can u please tell me how can i accomplish this?
thanks
Frank Ebo Quansah said
I am Biochemist and an Oracle OCA working my way up to change my career and to
OCP. Level. I love Oracle So much.
Thanks for this tutorial.
God Bless
purvi patel said
hello sir,
can u please tell me that how can i get the practice scripts for 10g admin 1 and admin 2(the one which are given in practice after each chapter) ?
i dont have that scripts
thank u
vasundhara said
how to install oracle forms 11g in windows 7
takreem said
hello ,
I am new to oracle world , i want to become Oracle DBA, so how should i start and how should i prepare for it . plz give me some useful material and videos to get knowledge.
Thanks
Kamran Agayev A. said
Installing Oracle products on Windows is simple, all you need is choose the product (item) and Click “Next” buttons
Kamran Agayev A. said
Hi Purvi
What do you mean with practice scripts? Do you mean OU course? If so, you can’t find it from anywhere, it’s used at OU courses only
ashish said
Great work … Thanks a lot for taking effort .. keep it up ..
Allam said
Hi Kamran,
Can you please post the videos for the below topics. I would be more happy to follow your blog as it gives immense energy and confidence when we listen your videos and articles.
Explain the general architecture of Oracle Data Pump
Use Data Pump Export and Import to move data between Oracle databases
Regards,
Allam M