[ipac] interbase backup and restore?

[Jonathan Rochkind]

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