This forum is currently locked. You can't register or post questions at this time. (read more)

What's an alternative to Oracle (Windows) Fail Safe?

Questions relating to Oracle Real Application Clusters (RAC) and Clusterware.

Moderator: Tim...

pb2070
Member
Posts: 25
Joined: Mon Apr 21, 2014 2:09 pm
Location: Germany

What's an alternative to Oracle (Windows) Fail Safe?

Postby pb2070 » Fri May 30, 2014 10:39 am

Hi Tim.

Could you please share 2 or 3 alternatives for Windows Fail Safe.
I recently came to know that there exists Oracle Fail Safe that is designed for only Windows :)

Reading the below link and other links I am convinced Oracle Fail Safe is a cheap alternative.
http://www.dba-oracle.com/t_oracle_fail_safe_vs_rac.htm

We have a couple of Clients who run Windows Fail Safe and at work we had discussion about this and
I said them that are some wonderful HA solutions from Oracle, like:
1) Data Guard
2) Active Data Guard
3) Oracle Streams

What would you suggest for an alternative to Fail Safe?

Thanking you,
PB

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: What's an alternative to Oracle (Windows) Fail Safe?

Postby Tim... » Fri May 30, 2014 11:08 am

Hi.

I have never used failsafe, so I can't really comment on its pros and cons compared with other technologies.

If it is working and your customer is happy with the level of availability it gives, then I see no reason to change...

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

pb2070
Member
Posts: 25
Joined: Mon Apr 21, 2014 2:09 pm
Location: Germany

Re: What's an alternative to Oracle (Windows) Fail Safe?

Postby pb2070 » Fri May 30, 2014 11:22 am

Hi.
Sorry, I missed out the important thing!
One of the Client's Fail Safe Node is dead long ago and want to migrate to Single Instance.
Neither they want to go with Fail Safe and RAC on Windows but want to HA solution.
If you have any suggestion then please do share.

Thanking you,
PB

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: What's an alternative to Oracle (Windows) Fail Safe?

Postby Tim... » Fri May 30, 2014 11:46 am

Hi.

Oracle Streams is no longer being developed. It is only present now for the sake of backwards compatibility. As such I would advise against using that for any new projects. If you are sticking with Oracle technology and want to avoid RAC and RAC One Node, then the options are:

- Data Guard (Regular or Active dedpending on licensing).
- Golden Gate.

There are numerous other 3rd party solutions available. The one I have some experience with is Dbvisit. They do replication and standby technology for Oracle.

http://www.dbvisit.com/

Depending on the environment, there may be simpler solutions. We run many of our databases in VMware virtual machines. We don't use HA products for them. Instead, we use VMware's ability to restart failed VMs on different hosts or data centres. We get a similar level of availability to Data Guard or RAC One Node with no additional configuration or costs...

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

pb2070
Member
Posts: 25
Joined: Mon Apr 21, 2014 2:09 pm
Location: Germany

Re: What's an alternative to Oracle (Windows) Fail Safe?

Postby pb2070 » Mon Jun 02, 2014 9:07 am

Hi Tim.

In the last message we spoke about the failure of a Windows Node.
The Client said they would like to migrate to single instance databases on Windows Server and say good bye to Fail Safe Cluster.

We checked and found they are 3 Databases running on Windows Fail Safe Cluster.
The size of 3 Databases is 1.10 Tb. Oracle Database is 11GR2.
So, I think the best method is to use RMAN Active Duplicate for this Migration Process. Am i correct Tim ?
My colleauges said Data Pump is the way to go etc.
The Client informed network bandwidtch is good.

Thanks.
PB

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: What's an alternative to Oracle (Windows) Fail Safe?

Postby Tim... » Mon Jun 02, 2014 11:13 am

Hi.

Are you saying you want to move from one Windows server to a new Windows server, in both cases using the same version of Oracle?

In that case, I would:

1) Create a new instance on the new server with the same SID and DB name.
2) Turn off both the new instance and the original instance.
3) Copy the files (datafiles, tempfiles, redo logs, controlfiles) across from the old instance to the new instance. This is replacing all the stuff that was already present in the new instance.
4) Turn on the new instance (doing any file renames if paths have changed).

Since there is no platform or version change, you can just copy the files...

Database duplication is unnecessary. Active duplications put extra load on the production system. I don't see the point in doing this when a straight file copy is possible.

Export and import will be very slow on something this size and ultimately unnecessary...

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

pb2070
Member
Posts: 25
Joined: Mon Apr 21, 2014 2:09 pm
Location: Germany

Re: What's an alternative to Oracle (Windows) Fail Safe?

Postby pb2070 » Mon Jun 02, 2014 6:43 pm

Thank you very much to guide us !!!

Could you please confirm one more thing.
The situation is:
1) A new Windows Server for Oracle.
2) 3 databases will be runned on this Server.
3) 64 GB RAM and Hardware seems to be good.
4) My boss gave me the task to do the Software installation and analysing the requirements accurately :-)
5) My collagues want their own traditional way of export and import and i do not want to argue with them.

So, I want to do my task and job clean and good.
The client ran Oracle home on C drive. I think this is not the right way to do.
And, I want to tell the client to install Oracle Home on a different drive and seperate the Oracle Home with System Drive.
Am i correct Tim? Is not it the right way to do it?

Thanking you,
PB

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: What's an alternative to Oracle (Windows) Fail Safe?

Postby Tim... » Mon Jun 02, 2014 7:48 pm

Hi.

Personally, I would have the ORACLE_HOME on something other than the C drive, but I know a lot of people do this, figuring the C drive will be almost empty, so why not use it for something...

If you can, I would suggest:

C : System drive.
D : Oracle Home
E Onward: Drives for data, backups, redo etc.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

pb2070
Member
Posts: 25
Joined: Mon Apr 21, 2014 2:09 pm
Location: Germany

Re: What's an alternative to Oracle (Windows) Fail Safe?

Postby pb2070 » Wed Jun 04, 2014 11:35 am

Hi Tim :-)
Installed Software and did the Patching for the new Oracle Home too and it seems the Client learned a lesson with Partitions.
They are going with individual Partitions for Data, Redo, Index etc.. for the Databases on the new Server.

Also, I am very happy that my colleagues want to go with the simple File Copy as you suggested but not with export or import :-) !!!

Thanking you,
PB

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: What's an alternative to Oracle (Windows) Fail Safe?

Postby Tim... » Wed Jun 04, 2014 12:31 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

pb2070
Member
Posts: 25
Joined: Mon Apr 21, 2014 2:09 pm
Location: Germany

Re: What's an alternative to Oracle (Windows) Fail Safe?

Postby pb2070 » Wed Jun 04, 2014 2:32 pm

Hi Tim.

The production Database is now running with 43 GB RAM (AMM ). It is 11.2. and Standard Edition.
The Client wants 140 GB RAM to be allocated (AMM) and started on the new Server.
It is absolutely Client's decision and they want such a huge Memory.

Do we need to be careful with any thing after copying files and before Starting the Database on the new Server with such a huge memory?


Thanking you,
Praveen

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: What's an alternative to Oracle (Windows) Fail Safe?

Postby Tim... » Wed Jun 04, 2014 3:10 pm

Hi.

That should be fine.

I would suggest monitoring the resize event to see if any extreme thrashing starts to happen.

http://www.oracle-base.com/dba/script.p ... ze_ops.sql

If you start seeing excessive resizing operations, you might want to use the parameters like pga_aggregate_target and sga_target to specify lower limits on these sections.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

pb2070
Member
Posts: 25
Joined: Mon Apr 21, 2014 2:09 pm
Location: Germany

Re: What's an alternative to Oracle (Windows) Fail Safe?

Postby pb2070 » Fri Jun 06, 2014 11:25 am

Hi Tim.
We had a test of the network bandwidth. Copied files from the production to the new server.
It is unsatisfied. We informed them the result.
Then they decided and informed us that a RMAN Backup will be placed on the new Server.
My colleagues are fine with it and they said they know it.

But, I want to be sure of with it. Please confirm me.

From this article
http://www.oracle-base.com/articles/11g ... -11gr2.php
I understood to perform the below when RMAN Backup is placed on the new Server:

1. set ORACLE_SID=DB11G and STARTUP NOMOUNT;

2. No target or catalog. Metadata comes from backups.
rman AUXILIARY /
or
3. Target, but no catalog. Metadata comes from target database controlfile.
$ rman TARGET sys/password@DB11G-SOURCE AUXILIARY /

'spfile' should not be used
4.DUPLICATE DATABASE TO DB11G
-- SPFILE
BACKUP LOCATION '/PATH-on-New Server/fast_recovery_area/'
NOFILENAMECHECK;
5 Recover Database is needed?

Thanking you,
pb

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: What's an alternative to Oracle (Windows) Fail Safe?

Postby Tim... » Fri Jun 06, 2014 1:03 pm

Hi.

In the event of a failure, you will not have access to the original (target) database, so you should use option (2) "rman AUXILIARY /".

Regarding the SPFILE, it depends what you are doing. If you are going to recover the SPFILE from the backup, amend it and use that, then the SPFILE option should not be present in the duplicate command. If you want to create the SPFIEL as part of the duplicate, then you need it.

The duplicate will recover the database. The final database will be as up to date as the backups that are present. If you put a 1 day old backup on the server, the do the duplicate, you will have a 1 day old version of the database. If you want it to be up to date, you need to take a recent backup...

While you are setting this up you should practice a variety of failure scenarios, so you know what you are capable of doing...

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

pb2070
Member
Posts: 25
Joined: Mon Apr 21, 2014 2:09 pm
Location: Germany

Re: What's an alternative to Oracle (Windows) Fail Safe?

Postby pb2070 » Sat Jun 07, 2014 12:11 pm

Hi Tim.

I am extremely sorry that I wasted your time in the last message about RMAN etc.
I was misleaded by a colleague. The client did not go for any kind of RMAN Backup on the new Server.

:-) we did the migration yesterday night and it was successful!
Copied files and started the databases on the new Server.

I feel it was successful because you made us successful !

There was not any kind of trouble when we assigned 140GB of RAM to one of the Database Instance (used AMM Parameters).
In the end we could see that 54GB of RAM was used :-)

And, we had a bit of information that the old Server's IP was assigned to the new Server.
Application team informed that they could connect the databases on the new Server.

Thanking you,
PB


Return to “Oracle RAC and Clusterware”

Who is online

Users browsing this forum: No registered users and 3 guests

cron