Murphy's Laws of DB recovery, it's not a matter of if it will happen, but when. Dick Goulet ________________________________ From: Howard Latham [mailto:howard.latham@xxxxxxxxx] Sent: Friday, April 03, 2009 10:15 AM To: Goulet, Richard Cc: Jack van Zanen; ORACLE-L Subject: Re: Dataguard switchover I agree entirely but what can I do. I've told my boss of my concerns I just hope it never happens! 2009/4/3 Goulet, Richard <Richard.Goulet@xxxxxxxxxxx> Why teach a trained monkey to do the job. Because upper management is being led to believe that a full time DBA is not really required to manage their databases. That the databases and their accessories (grid control as a for instance) are so simple that the trained monkey (at a lower pay scale) can do the job. Problem is, what does the trained monkey do when he's faced with a plain old vt100 terminal & sqlplus only to fix things? Dick Goulet ________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Howard Latham Sent: Friday, April 03, 2009 2:55 AM To: Jack van Zanen Cc: ORACLE-L Subject: Re: Dataguard switchover because I am the only dba and not being from Krypton I sleep get ill and take holidays! 2009/4/3 Jack van Zanen <jack@xxxxxxxxxxxx> Answers have been given Begs the question though.....WHY ask a trained monkey to do the switchover. This looks to me like it should be scripted or a DBA task not a manual job for an operator who may make a typo while connected as SYS, and than what? Brgds Jack 2009/4/2 Howard Latham <howard.latham@xxxxxxxxx> Has anyone written a guide for a non dba to do a manual dataguard switchover on Linux Oracle 11g? -- Howard A. Latham -- Jack van Zanen ------------------------- This e-mail and any attachments may contain confidential material for the sole use of the intended recipient. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of this e-mail or any attachment is prohibited. If you have received this e-mail in error, please contact the sender and delete all copies. Thank you for your cooperation -- Howard A. Latham -- Howard A. Latham