DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: loss of data using a SAN

  1. 07-15-2010, 04:57 AM #1
    ssmith
    ssmith is offline Senior Member
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258

    loss of data using a SAN

    Hi, we are testing failovers for two Windows 2008 servers using an Oracle 11g R2 database on a SAN. The SAN is disabled/enabled between these 2 servers.

    In the documentation it says:

    Loss of data if the SAN drive is being written to when the HBA card is disabled. You must ensure that all interfaces are shutdown before implementing the failover process.

    Question: How can you lose data on the SAN? Surely the SAN is just a set of disks and Oracle can recover using the redo logs once you enabled the SAN onto the secondary server?

    Thank you.
    Regards, Sheryl
    Reply With Quote Reply With Quote
  2. 07-15-2010, 05:02 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    and what if the write didn't happen to the disks, what then
    Reply With Quote Reply With Quote
  3. 07-16-2010, 05:11 AM #3
    ssmith
    ssmith is offline Senior Member
    Join Date
    Apr 2001
    Location
    Congleton
    Posts
    258
    Hi, thanks for the comment, but I don't understand. The database should only know about commits, which are written to the redo logs, if there is no commit then it would surely rollback the transaction.

    Is using the SAN as a failover option not a good decision? Thanks.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width