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?
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.
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
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.
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.
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
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.
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
thanks you very much for your very very useful of video tutorials….. i have gone through with creating duplicate with RMAN….
i could manage to clone 9i to 9i but the major consign is we have oracle ebusiness suite 11i backed is 9i…..so when I resnchronize clone using RMAN the login does not displayed.
kindly please suggest any i would appreciated you help.
It is working fine now. The issue was that I was ftping the files as another user and “oracle” user did not have read permissions on those files. Once the permissions were set right it is working now.. Thanks for your great tutuorial.
This is Raj Gupta, I have around 2 years exp. as Oracle DBA. Currently I am associated with Wipro Ltd.. Hope you heard that name? Thanks a lot for this effort I like your all valuable video of Oracle video tutorial.. Sir Now I want to install Oracle RAC system in my home computer for the same I have checked your site I got one of the link for the same and I am trying for the same. Sir I would like to request you if you have any video for Oracle RAC installation On VMware (Linux) then I please share with on your blog/site.
i followed your Instructions for “database converted” i modified converted database and modified successfully but when i try for sqlplus it gave me error command not found,i have fresh linux there is no database installed before.
do i need to install database for db_1 directory or we can use the converted database?
plz looking for more help.
I want to know that is there any book or full tutorial on ORACLE FORMS9i/10g/11g into your site where each thing get understand with good graphic..kindly confirm as I’ve some books on forms/reports but they are not so useful for me to do the well work on D2K and for clearing interview…Kindly reply with best book or tutorial….I’ll be very regardful for u….Thanx….
These are great efforts you have done. These videos are very useful who are new in this field. I am also new one. i am trying to install RAC 10g on Linux from your snapshot tutorial, but i fail to do so. Can you provide the video of Installing RAC on Linux.I will be very thankful to you. There are so many people who are demanding the same. Thanks
hi kamran. I want to install rhel 5.0 on my laptop.I am using Vmware workstation.At the same time i want to install oracle 10g r 10.2.0.So can u suggest me how may mount points are required for installing oracle.
pls tell me abt this also.how many mount points are required for linux? how much space should i reserve for each mount point?.What are the rpms required for oracle 10g installation.
few days back when i am trying to install oracle 10g, i created a oracle user.But whn i log in to the system the prompt i am getting is bash 3.1$.I am not getting a oracle user prompt directly.In this prompt whn i issue any command it is throwing an error as Permission denied.Please tell me a solution for this problem.
when i am going to login from oracle user on my REDHAT LINUX5, following error appeared.
$HOME/.dmrc is being ignored … the file should be owned by the user and have 664 permision, user’s HOME directory should be owned by the *.dmrc
Thanks for your videos. Where will I get audio files for Oracle 11gR2 RAC (Installation/Administration/Maintenance)?. I like to hear the audio files when I am driving. In Dubai, most of the times we struck in traffic, hence audio files are useful for the guys like me to listen peacefully. Kindly advise ASAP.
i’m expecting on performance issue on Oracle 11gR2 as well as how many index creation can be done for table & how to keep update parameter to avoid performance issues ..can you please provide videos on it…