How does one guarantee the integrity of snapshot done at block level

35 pts.
Tags:
Backup
EqualLogic
Red Hat Enterprise Linux
Red Hat Enterprise Linux 4.0
SAN
Hi, I have an equallogic SAN and I am looking at using the snapshot function for backup. My server are linux (redhat 4.0) with oracle database 10.2.0.3. What, if any, actions must I do to ensure that the snaphot made on the SAN (block level) is complete. In other word, does Linux have a cache somewhere that I have to flush prior to making the snapshot to garanty the integrity of the data of the snap. Thank you. Andre

Answer Wiki

Thanks. We'll let you know when a new response is added.

Are you asking is there a way to have the Equallogic snapshot function force the database to flush all pending operations to disk before taking the snapshot?

If this is what you are asking, then out of the box, the answer is no. I’ve never done this before, but Equallogic provides some perl examples on its support site on how you can interface with the array to force a snap. All you need to do is write a perl script to tell the database to flush all pending operations to disk. Immediately after that completes have the array take a snapshot of the oracle volume.

Next, you will need to mount the snapshot and then get your backup software to backup the data in the snapshot, then destroy the snapshot after the backup completes.

I hope this answers your question.

Thank you for your answer. I went on the Equallogic site. Didn’t find the perl script but find a nice article title Backup and recovery Overview. In the article it is made mention of microsoft Volume Shadow Copy service (VSS) that seem to do exactly what I need to garantee the integrity of the snapshot made at the SAN level. Do you know if any think similar is being develop for linux?

André

Perl examples will be part of the Host Scripting Tools download which can be found by clicking on the link for the version of the firmware you are running on the array(s). There is an example that shows how to create a snapshot. You will need to do the additional scripting work to then mount that snapshot.

I can’t speak for Equallogic about the future of VSS and Linux. But, I do know there are some individuals within Equallogic who are trying to promote the value of VSS to the Linux community. If you really like this feature that Microsoft provides in Windows then I suggest you plead your case to the Linux community.

André,

Your hunch is right. Before you take snapshots of online read/write Oracle database tables/volumes for backup you do need to flush the buffers and quiesce any writes to these tables/volumes to guarantee the integrity of the data in the snapshots. As you discovered (and mentioned above) VSS is a Windows only technology today. So, one way to get around this issue in Oracle 10g on Linux (RHAT 4.0) is to use an Oracle feature called “hot backup mode”.

Oracle database needs to be “put in hot backup mode” prior to taking snapshots of Oracle volumes and “taken out of hot backup mode” after taking snapshots of Oracle volumes. When the Oracle database is in the “hot backup mode” it copies the changed data buffers of an open Oracle database into the redo logs, and stops doing so after you take the Oracle database out of the “hot backup mode”. When restoring the database tables/volumes backed up from these snapshots, the database asks for the appropriate set of redo logs to apply if recovery is needed. The redo logs contain all changes required to recover the tables/volumes and make them consistent. Oracle requires database configured in ARCHIVELOG mode in order to use Oracle’s “hot backup mode” feature.

During the time Oracle database is in “hot backup mode”, Oracle continues to flush the changes data buffers into the redo logs. This slows down database performance. In EqualLogic storage snapshot of multiple volumes can be done almost instantaneously. This helps reduce performance problems while snapshots are being taken.

I hope this helps. For more information please visit the following links:

1. “PS Series Groups Backup and Recovery Overview”, a Dell EqualLogic white paper.

http://www.equallogic.com/psp/PDF/tr1004-backup-and-recovery-overview.pdf

2. “Backup and Recovery Basics”, 10g Release 2 (10.2), B14192-03.

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192.pdf

3. “Backup and Recovery Advanced User’s Guide”,10g Release 2 (10.2), B14191-03.

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191.pdf

4. “Deploying Oracle Database on Dell EqualLogic PS5000XV iSCSI Storage”, a Dell EqualLogic whitepaper

http://www.dell.com/downloads/global/solutions/oracle_ps5000xv_ref_config.pdf?c=us&cs=555&l=en&s=biz

SKJ79

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following