Click to give Water and Food

Saturday, January 9, 2010

Easy Disaster Proof Production : My New OTN Article published

I am pleased to announce that in the first month of the new year 2010, a brand-new technical article of mine has been published on the Oracle Technology Network :

Easy Disaster Proof Production with Grid Control
http://www.oracle.com/technology/pub/articles/havewala-easydr.html

The article, based on personal real-life experience, explains how the use of Oracle Enterprise Manager Grid Control for Data Guard setup, management (including switchover or failover), and monitoring can save a lot of time and resources.

Please read, enjoy and recommend to your friends and colleagues.

A Happy New Year 2010 to all of you. All the Best for the New Year.

Regards,

Porus Homi Havewala
(Oracle ACE Director).

5 comments:

Anonymous said...

Hello Sir,
Thanx so much for sharing your knowledge.

Question.

I installed oem grid rel5.

I do not see any link to restart physical stanby ? Did Oracle remove this completely ?

We used to have such a nice gui interface with java console for data guard administration where we could select a site and do restart.

Infact I cant even startup a physical standby from OEM.
If i give the option to start in mount state its says control file is for stanbdy .

AM I missing something

Please advise.
This seems to be such a basic requirement why should it be so difficult. May be I am wrong.

Porus Homi Havewala (પોરસ હોમી હવેવાલા) said...

Yes, definitely, you are missing something. First of all it looks like you have created the standby outside Grid Control. Try to create it in Grid Control instead. If you have created outside, then try to add it to the data guard configuration. Then Grid Control will understand it is a Data Guard pair. It should appear as such in the list of database targets. Read the article to see how to create a new standby via Grid control.

Anonymous said...

I did the Data guard from Grid.
It does show up as a pair.
If we click on the link to extreme RHS in the middle of database homepage for high availability ,it does show up.

But if you compare this interface to the 9i OEM I think definitely things are going missing.

I created a 9i physical standby database from GRID.

It shows both targets the primary as well the physical standby.

But when you try to stop and start the standby thats when it gets confused.

Porus Homi Havewala (પોરસ હોમી હવેવાલા) said...

Dont compare with 9i OEM - that is a Java client whiich took up a lot of memory, had to be installed on each PC and is older architecture.

You should not stop and start the standby without first stopping the application of logs. Perhaps this is where you are doing something wrong.

cv said...

Thanks a lot for making this downloadable..loved this blog..just started my career in Oracle!


Administrative Manager CV Template

Disclaimer

Opinions expressed in this blog are entirely the opinions of the writers of this blog, and do not reflect the position of Oracle corporation. No responsiblity will be taken for any resulting effects if any of the instructions or notes in the blog are followed. It is at the reader's own risk and liability.