OraFAQ Forum: Data Guard » DATA FILES IN Storage Area Network(SAN)

Home » Server Options » Data Guard » DATA FILES IN Storage Area Network(SAN) (ORACLE 10G, SAN)

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

DATA FILES IN Storage Area Network(SAN) [message #501513]

Tue, 29 March 2011 09:58

Najusmani
Messages: 7
Registered: March 2011
Location: Kabul

Junior Member

I am working in a bank as an system consultant, i have a SAN Storage Area and oracle as below.

SAN 1

This interface includes the DATA FILES of the oracle tablespace

SAN 2

SAN1 Mirrors the DATA FILES of the oracle tablespace to SAN 2

Questions ?

1. Can i rely on real time data recovery from SAN2 ?
2. if SAN1 (Data Files are currupted) will the SAN2 Data Files will be currupted as well.
3. If the SAN2 is currupted then what Oracle Features can be used to have uncurrupted data.

Thanks

Waiting for a prompt reply.

Report message to a moderator

Re: DATA FILES IN Storage Area Network(SAN) [message #501517 is a reply to message #501513]

Tue, 29 March 2011 10:35

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

Senior Member
Account Moderator

How is this a Data Guard question?

1. Can you? YOU are the system consultant we are just DBBMS guys. What service do you guarantee with your mirror?
2. Depends of the corruption I think, but once again YOU are the system consultant and this is not an Oracle issue
3. Oracle does not care about SAN2. Its files are on SAN1.

Regards
Michel

Report message to a moderator

Re: DATA FILES IN Storage Area Network(SAN) [message #501611 is a reply to message #501517]

Wed, 30 March 2011 02:11

Najusmani
Messages: 7
Registered: March 2011
Location: Kabul

Junior Member

Thanks for the information

I just need to know, what are oracle features to use failover concept

for example

when primary server gets down then secondary server gets up as a primary server and respond to client request.

Report message to a moderator

Re: DATA FILES IN Storage Area Network(SAN) [message #501620 is a reply to message #501611]

Wed, 30 March 2011 03:15

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

Senior Member
Account Moderator

Data Guard, see your other topic, or RAC depending on the failover against what: disk -> Data Guard, server -> RAC.

Regards
Michel

Report message to a moderator

Re: DATA FILES IN Storage Area Network(SAN) [message #501638 is a reply to message #501620]

Wed, 30 March 2011 06:10

Najusmani
Messages: 7
Registered: March 2011
Location: Kabul

Junior Member

If the data files or redo or archivlog is corrupted then the secondary should be up as primary server

the Dataguard is a good choice to configure or RAC

Report message to a moderator

Re: DATA FILES IN Storage Area Network(SAN) [message #501639 is a reply to message #501638]

Wed, 30 March 2011 06:33

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

Senior Member
Account Moderator

As I said, Data Guard against disk failure, RAC against server (OS) failure (Data Guard could also do it but slower and with, maybe, data lost).

Regards
Michel

Report message to a moderator

Previous Topic:	Disaster Recovery Best Practice With SAN
Next Topic:	DG Broker .Warning: ORA-16607: one or more databases have failed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 30 02:08:21 CST 2025