xfs
[Top] [All Lists]

re: using xfs_dump to backup an Oracle DB in hot backup mode.

To: Austin Gonyou <austin@xxxxxxxxxxxxxxx>, <linux-xfs@xxxxxxxxxxx>
Subject: re: using xfs_dump to backup an Oracle DB in hot backup mode.
From: Greg Freemyer <freemyer@xxxxxxxxxxxxxxxxx>
Date: Wed, 25 Sep 2002 18:59:47 -0400
Organization: The NorcrossGroup
Sender: linux-xfs-bounce@xxxxxxxxxxx
 >>  Anyone have an order of operation for something like this?

 >>  I was thinking, that while oracle is in hot_backup mode, I would just be
 >>  able to do xfs_dump /dev/sdb /dev/sdaa or some such thing, until all
 >>  volumes are done.

 >>  If I don't use xfs_freeze though, is that a good copy?

 >>  I'm a bit confused at this point, and wanted to ask the community. TIA

I thought Oracle's hot_backup was specifically designed to work with snapshots.

I.e.  freeze Oracle -->  xfs_freeze --> create snapshot --> unfreeze xfs --> 
unfreeze Oracle

If you are going to have it in that mode for the entire duration of your 
backup, you may have problems.  In particular, I don't think the write buffers 
are all that huge.

Even worse, if you go into hot_backup for an hour or so, and you have a machine 
crash during this time, your new data is lost!!!!

If you do want to try to go disk to disk extremely rapidly, you will need to 
either not use xfs_freeze, on mount your drive with -noatime.

Greg Freemyer
Internet Engineer
Deployment and Integration Specialist
Compaq ASE - Tru64 v4, v5
Compaq Master ASE - SAN Architect
The Norcross Group
www.NorcrossGroup.com


<Prev in Thread] Current Thread [Next in Thread>