[ipac] interbase backup and restore?

[Chadwick, John, DCA]

Running Linux and using gbak command line tool, there is no need to stop
and start firebird to do the backup.

http://www.destructor.de/firebird/gbak.htm 

To quote the first two paragraphs:

GBAK is Firebird's command line tool for online backup and restore of a
complete database.

GBAK is able to perform a backup while the database is running. There is
no need to shut down the database during a GBAK backup. GBAK will create
a consistent snapshot of the database at the time it starts running. You
will, however, notice a perfomance degradation during the backup, so it
is a good idea to backup at night. As GBAK visits all pages of the
database, so it will also perform a garbage collection on the database.

John

+-----------------------------------------------------------------------
+
John Chadwick, Ed.D. Information Technology Manager
New Mexico State Library
1209 Camino Carlos Rey
Santa Fe, NM 87507
Phone: 505-476-9740  Cell: 505-629-8116 Fax: 505-476-9761
john.chadwick at state.nm.us
http://www.nmstatelibrary.org

-----Original Message-----
From: ipac-bounces at lists.tblc.org [mailto:ipac-bounces at lists.tblc.org]
On Behalf Of Jonathan Rochkind
Sent: Friday, August 08, 2008 1:03 PM
To: Dynix's Horizon Information Portal,formerly iPac (discussion)
Subject: Re: [ipac] interbase backup and restore?

Yeah, googling for general advice on interbase and firebird, it looks 
like you really are supposed to shut down the db before running backup 
and restore---particularly the restore part, it's fine to do the backup 
part without shutting it down.

Of course, it is no surprise that SD doesn't tell us that or reccommend 
that.

SD does, I see in the knowledge base, "require" us to run backup and 
restore weekly for HIP.  Oops. Now I've got to figure out how to get 
firebird to automatically shut down and restart. Although really, it's 
_probably_ sufficient to just make sure hzapp is stopped---what else 
talks to firebird?

[ It also looks like HIP uses a 6.x version of interbase/firebird. The 
interbase/firebird web pages say that "no version of 6.x is considered 
stable, and it should not be used." Surprise!]

Jonathan

Vern Mastel wrote:
> OK, what about the open files problem when backing up?
>
> When I backup my Windows HIP, I always stop all the HIP services and
backup 
> (and restore, I have done it) works properly. If I do not stop the HIP

> services, the backup is worthless.
>
> I know there are commercial backup products that can backup open
files.
>
> Does gbak fall in this category? Does the backup work job because it
is a 
> Linux system?
>
>
>
>
>   
>> I do this while hip is running.
>>
>>
>>
>> John
>>
>> ----------
>> From: ipac-bounces at lists.tblc.org
[mailto:ipac-bounces at lists.tblc.org] On 
>> Behalf Of Jay Roos
>> Sent: Friday, August 08, 2008 11:44 AM
>> To: Dynix's Horizon Information Portal,formerly iPac (discussion)
>> Subject: Re: [ipac] interbase backup and restore?
>>
>>
>>
>> Are you doing this while hip is running or do you have to stop it
first?
>>
>> On Fri, Aug 8, 2008 at 12:40 PM, Chadwick, John, DCA 
>> <<mailto:john.chadwick at state.nm.us>john.chadwick at state.nm.us> wrote:
>>
>>
>> I am backing up the database 5 days a week and we have done a
successful
>> test restore. Here is the script. We run it as a cron job. You may
want
>> to play around with this a bit.
>>
>> #!/bin/bash
>> BCKNAME=/backup/ipacdb/`date +%Y`/ipacadmin-`date +%F`.gbk
>> LOGNAME=/backup/ipacdb/`date +%Y`/log/ipacadmin-`date +%F`.log
>> if [ ! -d /backup/ipacdb/`date +%Y` ]; then
>> mkdir /backup/ipacdb/`date +%Y`
>> fi
>> if [ ! -d /backup/ipacdb/`date +%Y`/log ]; then
>> mkdir /backup/ipacdb/`date +%Y`/log
>> fi
>> rm -f $BCKNAME.gz
>> rm -f $LOGNAME
>> find /backup/ipacdb/* -mtime +6 -exec rm {} \;
>> (/opt/firebird/bin/gbak -b -v
>>
localhost:/opt/dynix/appserver/jboss/server/default/data/ipacadmin.gdb
>> -user sysdba -pass xxxxxx $BCKNAME 2>&1) > $LOGNAME
>> gzip $BCKNAME
>>
>>
>>
>>
>> -----Original Message-----
>> From: <mailto:ipac-bounces at lists.tblc.org>ipac-bounces at lists.tblc.org

>> [mailto:ipac-bounces at lists.tblc.org]
>> On Behalf Of Jonathan Rochkind
>> Sent: Friday, August 08, 2008 11:30 AM
>> To: Dynix's Horizon Information Portal,formerly iPac (discussion)
>> Subject: [ipac] interbase backup and restore?
>>
>> Is anyone running regularly scheduled 'backup and restore' processes
on
>> their interbase/firebird dbs using gbak?
>>
>> I want to start scheduling such a thing. It is not clear to me if it
can
>>
>> be done when the database is running, or if I need to shut down Jboss
>> first.
>>
>> Jonathan
>> _______________________________________________
>> ipac mailing list
>> <mailto:ipac at lists.tblc.org>ipac at lists.tblc.org
>> http://lists.tblc.org/mailman/listinfo/ipac
>>
>>
______________________________________________________________________
>> This inbound email has been scanned by the MessageLabs Email Security
>> System.
>>
______________________________________________________________________
>>
>>
>> Confidentiality Notice: This e-mail, including all attachments is for
the 
>> sole use of the intended recipient(s) and may contain confidential
and 
>> privileged information. Any unauthorized review, use, disclosure or 
>> distribution is prohibited unless specifically provided under the New

>> Mexico Inspection of Public Records Act. If you are not the intended 
>> recipient, please contact the sender and destroy all copies of this 
>> message. -- This email has been scanned by the Sybari - Antigen Email
System.
>>
>>
>>
>>
>>
>> _______________________________________________
>> ipac mailing list
>> <mailto:ipac at lists.tblc.org>ipac at lists.tblc.org
>> http://lists.tblc.org/mailman/listinfo/ipac
>>
>>
>>
>>
>> --
>> Jay Roos
>> Computer & Information Systems Coordinator
>> Great River Regional Library
>> 405 W. St. Germain
>> St. Cloud, MN 56301
>> (320) 650-2534
>>
>>
>>
______________________________________________________________________
>> This inbound email has been scanned by the MessageLabs Email Security
System.
>>
______________________________________________________________________
>>
>>
>> Confidentiality Notice: This e-mail, including all attachments is for
the 
>> sole use of the intended recipient(s) and may contain confidential
and 
>> privileged information. Any unauthorized review, use, disclosure or 
>> distribution is prohibited unless specifically provided under the New

>> Mexico Inspection of Public Records Act. If you are not the intended 
>> recipient, please contact the sender and destroy all copies of this 
>> message. -- This email has been scanned by the Sybari - Antigen Email
System.
>>
>>
>> _______________________________________________
>> ipac mailing list
>> ipac at lists.tblc.org
>> http://lists.tblc.org/mailman/listinfo/ipac
>>     
>
> Vern Mastel
> Technology Coordinator, Bismarck Veterans Memorial Public Library
> Desk Phone 701-355-1499 Cell Phone 701-426-5897
>
>
>
> _______________________________________________
> ipac mailing list
> ipac at lists.tblc.org
> http://lists.tblc.org/mailman/listinfo/ipac
>
>   

-- 
Jonathan Rochkind
Digital Services Software Engineer
The Sheridan Libraries
Johns Hopkins University
410.516.8886 
rochkind (at) jhu.edu

_______________________________________________
ipac mailing list
ipac at lists.tblc.org
http://lists.tblc.org/mailman/listinfo/ipac

______________________________________________________________________
This inbound email has been scanned by the MessageLabs Email Security
System.
______________________________________________________________________


Confidentiality Notice: This e-mail, including all attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited unless specifically provided under the New Mexico Inspection of Public Records Act. If you are not the intended recipient, please contact the sender and destroy all copies of this message. -- This email has been scanned by the Sybari - Antigen Email System.