home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!usc!wupost!darwin.sura.net!seismo!jean
- From: jean@seismo.CSS.GOV (Jean Anderson)
- Newsgroups: comp.databases.oracle
- Subject: Re: Oracle Backup
- Message-ID: <50983@seismo.CSS.GOV>
- Date: 22 Jul 92 20:51:35 GMT
- Sender: usenet@seismo.CSS.GOV
- Organization: SAIC Open Systems Division, San Diego CA
- Lines: 41
- Nntp-Posting-Host: beno.css.gov
-
- In <45406@shamash.cdc.com>, ldh@svl.cdc.com (Lawrence D. Hare) writes:
- > 1) How do you back up Oracle databases today?
-
- Many of my sites do nightly full database exports out of cron. We accept
- a 24 hour "worst case" data loss. This is not as bad as it might seem.
- If "the worst" happens (which it has), we rebuild from the previous night's
- export and re-process, catching up to real-time in a matter of hours.
-
- Back in April, I posted the instructions somebody sent me on compressing UNIX
- exports. I have been running them since May and it has been great, reliable,
- reducing the amount of disk we previously had to allocate for exports. I have
- even had the misfortune of needing to restore from a compressed backup and
- it worked.
-
- Here are the instructions again. The credit goes to somebody who wishes to
- remain anonymous because of the employer's restrictions on posting.
-
- I have found that the best way to do this is using Unix's named-pipes
- feature. Simply:
-
- % mknod /tmp/compresspipe p
- % compress -c </tmp/compresspipe>/backup/oraexp/exp1MAY92.dmp &
- % exp system/manager full=y ..... file=/tmp/compresspipe
-
- Voila! After the compress receives an EOF (sent by exp), it
- terminates, leaving a nice compressed file. This saves using various
- undocumented features (as file=stdout must be?!)
-
- To import, do the same thing:
-
- % uncompress -c </backup/oraexp/exp1MAY92.dmp >/tmp/compresspipe &
- % imp system/manager .... file=/tmp/compresspipe
-
- +-----------------------------------------------------------------------+
- | Jean Anderson, DBA email: jean@seismo.css.gov |
- | SAIC Open Systems Division, MS A2-F or: jean@esosun.css.gov |
- | 10210 Campus Point Drive phone: (619)458-2727 |
- | San Diego, CA 92121 fax: (619)458-4993 |
- +-----------------------------------------------------------------------+
- | std_disclaimer("mine"); |
- +-----------------------------------------------------------------------+
-