IDS Forum

RE: Messy backup procedures

Posted By: Murray Wood (IList)
Date: Tuesday, 25 May 2004, at 5:19 p.m.

In Response To: Messy backup procedures (KEVIN STRUCKHOFF)

9.20 is very old now. I would look at upgrading to 9.40.
To change the logging of a number of database just continue the list of databases - ontape -s -U db1 db2 db3 db4 etc ...

You can backup/restore to/from disk, but in 9.20 you are limited to 2Gb for each file you create - 9.40 has no such limit. You can use ALARMPROG in $ONCONFIG to backup logical logs to disk - log_full.sh comes partly set up for code 23 (logical log full), but you need to configure for ontape and your environment.

You need to plan how you are going to do if you have a disk failure.

MW

> -----Original Message-----
> From: forum.subscriber@iiug.org [mailto:forum.subscriber@iiug.org]On
> Behalf Of KEVIN STRUC....
> Sent: Wednesday, 26 May 2004 5:05 a.m.
> To: ids@iiug.org
> Subject: Messy backup procedures [3019]
>
>
> have just come onboard here and the backup processes are in a
> shambles. We are running 9.20HC3 on an HP-UX 11 box with 1 tape
> drive. Currently we manually run a Level 0, but sometimes they
> don't even get done. My plan is to automate the backup process
> using ontape and run a Level 0 backup Monday thru Friday. We at
> least have a large window of time for backups.
>
> I then need to turn on transaction logging for all databases, of
> which there are 1000 of them. Is there a way to start logging for
> all db's at once? I couldn't find any reference to that situation
> in the docs. It just says use ontape -s -U dbname as an example.
>
> Then I need to create a logical log backup procedure. I would
> like to use continuous backup to minimize data re-entry in case
> of a crash. Can I do the backup and restore to/from disk? The
> docs lead me to believe that I can't.
>
> Any ideas appreciated.
>
> Thanks.
> Kevin Struckhoff
> Customer Analytics Mgr.
> NewRoads West
> Office 818.253.3819 * Fax 818.253.3880
> kevin.struckhoff@newroads.com
>
>

Messages In This Thread

• Messy backup procedures
  KEVIN STRUCKHOFF -- Tuesday, 25 May 2004, at 1:05 p.m.
  • RE: Messy backup procedures
    Murray Wood (IList) -- Tuesday, 25 May 2004, at 5:19 p.m.
  • Re: Messy backup procedures
    AJAY GUPTA -- Tuesday, 25 May 2004, at 6:05 p.m.
  • Re: Messy backup procedures
    KENNETH PENZA -- Wednesday, 26 May 2004, at 5:55 a.m.
  • RE: Messy backup procedures
    mosserp@wellsfargo.com -- Friday, 28 May 2004, at 7:15 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.