OraFAQ Forum: Backup & Recovery » Prepare Cold Standby Server

Home » RDBMS Server » Backup & Recovery » Prepare Cold Standby Server (Oracle 12)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Prepare Cold Standby Server [message #657283]

Fri, 04 November 2016 05:39

matthiaswolf1984
Messages: 15
Registered: November 2016

Junior Member

Hello,

We have one Oracle Server (running Windows 2012 R2) and
we are planing to create a cold standby server.
The server should be prepared in case we have an OS or hardware issue.

Would would be the correct way to prepare the new server?

My idea was:
- Install OS, name the server the same hostname (no network connection)
- Install Oracle Software

My question is, how would I register the databases on the new server?
Our Oracle DB is saved on a LUN in our SAN.
So in case I can map this LUN to the new server, but how would I get the
DB registered?

Report message to a moderator

Re: Prepare Cold Standby Server [message #657287 is a reply to message #657283]

Fri, 04 November 2016 07:27

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

You need to be sure of your licence situation. Have you licensed both machines? It is easy to get into trouble setting up this sort of thing.

Report message to a moderator

Re: Prepare Cold Standby Server [message #657289 is a reply to message #657287]

Fri, 04 November 2016 07:38

matthiaswolf1984
Messages: 15
Registered: November 2016

Junior Member

Hello John,

what I thought was, that if there is only one instance of Oracle is running, there is no second license required.
But I might be wrong.
So you say, even if the second server is offline, it would require a license because Oracle is installed?

Report message to a moderator

Re: Prepare Cold Standby Server [message #657290 is a reply to message #657289]

Fri, 04 November 2016 07:50

matthiaswolf1984
Messages: 15
Registered: November 2016

Junior Member

Anyway, what would be the technical way to create such a standby server?
What would be the right order?

Report message to a moderator

Re: Prepare Cold Standby Server [message #657298 is a reply to message #657290]

Fri, 04 November 2016 11:11

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

If the standby is always off, how could this be a standby?
Define what you mean by "cold stanby".
Explain what is the actual business requirements.

Report message to a moderator

Re: Prepare Cold Standby Server [message #657300 is a reply to message #657289]

Fri, 04 November 2016 12:22

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

matthiaswolf1984 wrote on Fri, 04 November 2016 12:38

Hello John,

what I thought was, that if there is only one instance of Oracle is running, there is no second license required.
But I might be wrong.
So you say, even if the second server is offline, it would require a license because Oracle is installed?

Here's the doc,
http://www.oracle.com/us/corporate/pricing/data-recovery-licensing-070587.pdf

Report message to a moderator

Re: Prepare Cold Standby Server [message #657323 is a reply to message #657283]

Sun, 06 November 2016 01:47

matthiaswolf1984
Messages: 15
Registered: November 2016

Junior Member

Hello Michel,

with cold standby I mean:

- a server that is prepared with OS, Oracle software is installed
- a server that is offline and could be actived in case the primary server fails
- the database files itself will be mounted via iSCSI from the SAN

So the idea was to create a "standby" server (maybe the wrong term)
that can be used in case the primary server has a hardware or software fail.

Report message to a moderator

Re: Prepare Cold Standby Server [message #657324 is a reply to message #657323]

Sun, 06 November 2016 01:54

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks, John gave you the answer and reference.

Report message to a moderator

Re: Prepare Cold Standby Server [message #657330 is a reply to message #657283]

Sun, 06 November 2016 07:55

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

matthiaswolf1984 wrote on Fri, 04 November 2016 05:39

Hello,

We have one Oracle Server (running Windows 2012 R2) and
we are planing to create a cold standby server.
The server should be prepared in case we have an OS or hardware issue.

And what if your "hardware issue" is the SAN - where your database files are located?

What if your "hardware issue" is a fire or flood that takes out the entire data center?

Report message to a moderator

Re: Prepare Cold Standby Server [message #657331 is a reply to message #657330]

Sun, 06 November 2016 08:14

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

Actually, this type of fault tolerance is not that unreasonable (or uncommon). It may well be (depending on detail) that Matthias will not have to license the second node. Furthermore, if he installs Grid Infrastructure on both nodes using the SAN as the shared storage, he can then define the database as policy managed to automate failover of the instance from one node to another, with the failover being transparent to users because they will connect through SCAN listeners. All they will see is a short break in service as their sessions reconnect.
You can get pretty good HA very cheaply that way.

Report message to a moderator

Re: Prepare Cold Standby Server [message #657346 is a reply to message #657331]

Mon, 07 November 2016 04:01

matthiaswolf1984
Messages: 15
Registered: November 2016

Junior Member

Ok, I did not mention the SAN has a async replica in a different branch a few kilometers from here.

So I will verfiy the license situation.

We did also think of the Grid solution. Did anyone use Grid on Windows before?
Our Oracle consultant told us that he would not recommend to use Grid on Windows because he
ran into a lot issues in past.

Report message to a moderator

Re: Prepare Cold Standby Server [message #657360 is a reply to message #657346]

Mon, 07 November 2016 08:22

John Watson
Messages: 8965
Registered: January 2010
Location: Global Village

Senior Member

Quote:

Our Oracle consultant told us that he would not recommend to use Grid on Windows because he
ran into a lot issues in past.

That tells you that your Oracle consultant is incompetent. I'm installing RAC on Windows this week.

I'm sure you now understand that there is a huge difference in licensing between "Our Oracle DB is saved on a LUN in our SAN.
So in case I can map this LUN to the new server, " and "the SAN has a async replica in a different branch a few kilometers from here.".

Report message to a moderator

Re: Prepare Cold Standby Server [message #665136 is a reply to message #657360]

Wed, 23 August 2017 00:19

matthiaswolf1984
Messages: 15
Registered: November 2016

Junior Member

Hello,

I have asked Oracle and they told me
that in this case we will have to license both machines.
So we have decided against this solution.

Report message to a moderator

Re: Prepare Cold Standby Server [message #665334 is a reply to message #665136]

Wed, 30 August 2017 21:40

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

matthiaswolf1984 wrote on Wed, 23 August 2017 05:19

Hello,

I have asked Oracle and they told me
that in this case we will have to license both machines.
So we have decided against this solution.

A question from November 2016 till August 2017, I though a scenario: You walked through to Oracle head office, sent a question to someone who have had responsibility to answer to you, and you met a beautiful girl. In your mind at this time, the boss's requirement would be gone to somewhere, maybe over the earth, and ... your couple have just finished on going to holiday till now.

My question is: What a kind of your boss? Is he is very gently man? Where is your office, I just want to apply! Very Happy

Report message to a moderator

Previous Topic:	Retention Policy for Control File Auto Backups
Next Topic:	Old backups not getting deleted

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 00:42:28 CST 2025