Home » Server Options » Data Guard » Failover (Oracle 10.2.0.1.0 - Linux)
Failover [message #380983] Wed, 14 January 2009 12:30 Go to next message
danyromimd
Messages: 73
Registered: August 2008
Member
Hi all!

I've got a question...
How broken must a DB be so as to have no way out but performing a Failover?

Thanks in advance,
Daniela.
Re: Failover [message #380986 is a reply to message #380983] Wed, 14 January 2009 12:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
When you can't use it.

Regards
Michel
Re: Failover [message #380987 is a reply to message #380983] Wed, 14 January 2009 12:48 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
That means when I can't make a 'startup mount', for example?
Re: Failover [message #380989 is a reply to message #380987] Wed, 14 January 2009 12:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All cases you can't use it.

Regards
Michel
Re: Failover [message #380991 is a reply to message #380983] Wed, 14 January 2009 13:01 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
I feel a bit confused...
When a datafile is deleted, for example, you cannot startup the db, but you can recover that datafile and make it work again.
So in this case it is not neccesary to perform a Failover, do you understand what I mean?
Re: Failover [message #380994 is a reply to message #380991] Wed, 14 January 2009 13:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends on the contract you have with your customer.
What is your maximum downtime?
Is it long enough to wait for a recover?

Regards
Michel
Re: Failover [message #380995 is a reply to message #380983] Wed, 14 January 2009 13:33 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
Here we make a file system backup, so we would just have to copy a single file... or perform a switchover... but
It all comes from what I read about failover in the internet... and it is that Failover oughts to be used when your DB is "destroyed", other way try to use "Switchover" or try to solve the problem some other way... as if Failover should be avoided or used when there's nothing else to do...
What does you experience say? Is it so much like that?
Re: Failover [message #381744 is a reply to message #380983] Mon, 19 January 2009 10:54 Go to previous messageGo to next message
sonumalhi
Messages: 62
Registered: April 2008
Member
Failover should be avoided?

I think we have Data Guard inplace only when we need to have minimum downtime.If you have good backup policy then there are very less scenario's where you need to Failover as you can recover from previous backups.

So if you can have enough downtime to do recovery.then you dont even need Data Guard.Why wasting money on another server.

Also if the DB size is small.you can easily recover.
Data Guard importance comes into picture where you cannot afford any downtime or Database Size in in TB's and will take long time to recover in case of disaster's.

Re: Failover [message #381745 is a reply to message #381744] Mon, 19 January 2009 11:06 Go to previous message
danyromimd
Messages: 73
Registered: August 2008
Member
Thank you Sonumalhi!!
You are right...
My problem was that I was writing a document about what to do in case of failure, to be read by people who doesn't know that much about Oracle, so I needed to be "minuscious" about what oughts to be done in each case.
I guess now, after reading and reading, I've lost my "fear" for Failover.
Thanks a lot for your help.
Daniela.
Previous Topic: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1 '.........\SYSTEM01.D'
Next Topic: Physical Standby from RAC (Primary) to non-RAC(Standby)
Goto Forum:
  


Current Time: Fri Mar 29 01:49:59 CDT 2024