[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 396
  • Last Modified:

Oracle data guard

Hi,

One simple question. Can we implement data guard 10g on windows 2003 cluster with 3 nodes all connected to same SAN, for a fail over only, as it seems that DG is a solution for DR only.

Regards,

--NS
0
naufal
Asked:
naufal
  • 4
  • 3
1 Solution
 
raju1105Commented:
Hi,

Dataguard is a high availability solution from oracle to have a standby database. You can create a standby database anywhere (either same data center or DR site) as long as your primary database is being able to ship the archive logs to the standby database.

Yes, in terms of any disaster to your main data center its better to have standby at a remote location. However, we do have a dataguard within the datacenter which we use for backups, reports etc. So its basically configuring the standby to serve your intended purpose.

0
 
naufalAuthor Commented:
Ok but if the both nodes of the cluster are connected to Same SAN then how will the logs be applied, as the data will already be same for both nodes.
0
 
raju1105Commented:
Hi,

Your system administrator will be adding storage to your windows server as partitions, so what is the issue?

Each server will have its storage in terms of partitions right??
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
naufalAuthor Commented:
Well, no, because in order for secondary database to become up, it needs the same path
0
 
raju1105Commented:
do you have rac setup... because only in RAC setup and Active/Passive setup we use the same datafiles.
0
 
naufalAuthor Commented:
No we are not using RAC. however even in the data guard implementation the files are replicated to secondary DR SAN using the same path, and I think that needs to be done in order for the database to come up on DR site automatically using the broker.

Regards,
0
 
naufalAuthor Commented:
We never reached consensus. However it is so old, you can close it. even with accepting the solution. no issues.

Regards
0
 
DavidSenior Oracle Database AdministratorCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now