home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.databases.ingres
- Path: sparky!uunet!gatech!ncar!uchinews!gsbacd.uchicago.edu!cs_mj
- From: cs_mj@gsbacd.uchicago.edu (Mark Jaeger)
- Subject: Re: What is the best method to backup Ingres DataBase ?
- Message-ID: <1992Nov19.135831.1@gsbacd.uchicago.edu>
- Lines: 42
- Sender: news@uchinews.uchicago.edu (News System)
- Organization:
- References: <C324A32A7A7F2003B9@ichcmns.cmns.mnegri.it> <Bxyx9r.LtA@umassd.edu>
- Date: Thu, 19 Nov 1992 19:58:31 GMT
-
- In article <C324A32A7A7F2003B9@ichcmns.cmns.mnegri.it>,
- OLIVIERI@ICHCMNS.CMNS.MNEGRI.IT (Marco Olivieri) writes:
-
- >> What is the best method to backup Ingres DataBase ?
- >>
- >> We work with microVax 3600, VMS 5.5-1 & 6.4/01 (vax.vms/01) and SUN/UNIX.
- >> Now the System Manager of the VAX does not BACKUP ingres DataBase,and I do the
- >> CHECKPOINT on tape (TK70 - I checkpoint only 3 small DataBase) but not for all
- >> DataBase, now I would like to change the Backup Method, in order to obtain a
- >> total security for data.
-
- In article <Bxyx9r.LtA@umassd.edu>, ctremblay@UMASSD.EDU (Claire
- Tremblay) writes:
-
- > I've been using the COPYDB instruction. This instuction produces 2 SQL
- > scripts: 1) to copy the data out, 2) to allow the data to be copied back
- > into the database along with the supporting views and grants.
-
- If you do it this way, then you'll probably want to invoke the copy.out
- script with the "-l" switch on the "sql" command. This will ensure that
- you have a an exclusive lock on the database before you start copying
- the data, and hence that no one will be changing it while you're
- copying.
-
- Unfortunately this does not give you the journaling capability that
- "ckpdb" does. With journaling, you can recover a database to the state
- it was in right up to the time that something awful happened to it (disk
- failed, some dodo dropped a critical table or deleted all the data in
- it, etc.). If you have a lot of update activity on the database (we
- do), then this can save your users a _lot_ of work.
-
- Also, "ckpdb" gives you much faster recovery since it uses standard OS
- backup commands (tar, cpio, VMS backup, etc.) to do the work. Using
- a copy.in script to repopulate a database can take orders of magnitude
- longer.
-
- --Mark Jaeger internet: cs_mj@gsbvax.uchicago.edu
- Graduate School of Business yellnet: (312) 702-0328
- University of Chicago faxnet: (312) 702-0233
- Disclaimer: My opinions are my own and not those of my employer.
- Ich bin ein Virus. Mach' mit und kopiere mich in Deine .signature.
-
-