Welcome to Oracle Masters. The portal, as the tagline says, is for anything Oracle. FAQs, Certifications, Resources! In addtion, there will be pages on real life scenarios, Oracle internals, approaching the DBA job at various stages in your career and many other useful resources.Further, if you have a question, you can ask it and we will answer it at the earliest!
So join in. Learn, share and prosper! Register with us!
Are you interested in Weekend/Online Training in Oracle DBA? Do you have business/consulting requirements? Click here Enquiry Form to leave your requirements or mail me at Ramesh Menon
I have backupieces of 3 days existing in disk,Now i want to restore 3 days old backup
As by default if you do resoratin it will restore latest backup,But i want to restore 3 day old backup,suppose I have backup of 17th,18th,19th dec and now I want to restore backup of 17th dec.
I have one question,That query is running fine yesterday and today is running slow.
now my question is how we can find explain plan of that query for yesterday one.
You can use a stored outline that allows use of a standard execution plan to be maintained, irrespective of the changes
in the system. This feature gives plan stability for queries. This can be useful when you cannot change the code as it
is a third party application, but feel that a certain query can run better with a particular execution plan.
The following article shows the technical aspects of setting up outlines in Oracle database.
I have good explain plan of query.How to save that plan in Oracle dataabse,so that if some for reason plan change and query behaves bad,then I can load that good plan for particular query.
So question is how should I tell to optimizer to used this plan.
With releases prior to Oracle 11GR2, addition or deletion of nodes would entail the client tnsnames.ora file being updated with the correct VIP address. This would be cumbersome if there are many clients that connect to the cluster. With Oracle 11gR2 GRID, Oracle has introduced the concept of SCAN.Clients connect to the cluster providing the database service, via the scan listener (initial connection) and based on the load profile of the node, the scan listener would “hand off” the connection to the local listener, establishing the final database connection.
I have some problem with my Oracle Installation, we had a virus called Sality and I think it might have
affected some of my Oracle system files. After we installed Karspersky AntiVirus 6.0.4,
I now can’t launch any of the Oracle Tools, like Enterprise Manager Console, Net Service Configuration, SQLPlus etc.
But surprisingly when I check the Oracle Services, they are started, but I am unable to access the DB via SQLPLUS nor EM Console, nor can
I reconfigure the TNS.
So am wondering what to do next, could you possibly know of a way I can fix this kind of a problem?
My Data files .i.e .DBF files are fortunately on a separate drive (D:), but I wonder if there
is a way I can recover the affected Oracle system files and then restore the data.
Please guide me on how to go about this issue.
thanks®ards,
NB:
When you insert the Oracle 10g R2 CD, is there an option to Repair?
With Oracle 11g, you can use physical standby database while your it is open in read only mode. Hence, the users can get real time data, which is almost as of production time. This feature is called Active Dataguard or Real Time Query.
This feature is part of the Oracle Enterprise edition and requires separate license for use. Read the rest of this entry »
