topic Re: MC Service guard and Oracle in Operating System - HP-UX

MC Service guard and Oracle

YOUNG C. JUN_1 — Thu, 28 Dec 2000 14:50:43 GMT

Hello All,

I have a question regarding MC service guard with Oracle. When It trys to failover, Does it requires oracle restart?

I have two HP machines and setup with MC service guard. But, Whenever HP has a problem, It didn't failover. I mean MC looks ok but Oracle is always in the middle of backup.
And, Oracle had a problem because it was in the middle of backup.

Thanks

Re: MC Service guard and Oracle

Roulet — Thu, 28 Dec 2000 15:07:10 GMT

The database is in backup mode, you need to switch in end backup mode, and restart

Hope this will help you.

PR

Re: MC Service guard and Oracle

YOUNG C. JUN_1 — Thu, 28 Dec 2000 15:08:47 GMT

Yeah, I know. So, I'm looking for solution to avoid manual recovery.

Re: MC Service guard and Oracle

Rhonda Thorne — Tue, 02 Jan 2001 17:50:26 GMT

You can set a flag when you stat your backup that MC/SG can look for first and if it sees the flag, you can run a script to take oracle outta backup mode before doing and oracle shutdown and restart after cluster has switched over.

I have samples of script taking oracle outta backup mode that we use.

Rhonda

Re: MC Service guard and Oracle

YOUNG C. JUN_1 — Tue, 02 Jan 2001 18:17:38 GMT

Rhonda,
Can you post your script?
Thank you