home *** CD-ROM | disk | FTP | other *** search
- Path: sparky!uunet!oracle!unrepliable!bounce
- Newsgroups: comp.databases.oracle
- From: kjou@us.oracle.com (Kathy Jou)
- Subject: Re: Oracle Backup
- Message-ID: <1992Jul22.182710.25444@oracle.us.oracle.com>
- Sender: Kathy Jou
- Nntp-Posting-Host: hqpyr1.us.oracle.com
- Organization: Oracle Corporation, Redwood Shores CA 94065
- References: <45406@shamash.cdc.com>
- Date: Wed, 22 Jul 1992 18:27:10 GMT
- X-Disclaimer: This message was written by an unauthenticated user
- at Oracle Corporation. The opinions expressed are those
- of the user and not necessarily those of Oracle.
- Lines: 38
-
- In article <45406@shamash.cdc.com> ldh@svl.cdc.com (Lawrence D. Hare) writes:
- >Given that most of us live on the edge of total neurosis due to the
- >pressures of backup, I have been elected to look into the problems of
- >database backup and Oracle in particular. To this end I have a few
- >questions:
- >
- >1) How do you back up Oracle databases today?
- >
- >2) What can be done to make it better?
- >
- >3) What is the ideal solution?
- >
- >All help is appreciated.
- >--
- >Lawrence D. Hare Control Data - Silicon Valley Operations
- >Consultant Voice: (408) 496 4339 - C/N [234] 4339
- >ldh@svl.cdc.com Mail: SVLa60 FAX: (408) 496-4106
-
- Chapter 15, Backup and Recovery, of the DBA Guide will introduce you to
- different types of backups: export, cold backup (database shutdown), and hot
- backup (database running, tablespace in backup mode). The type of backup to
- use depends on the availability of the database. If this is a 24 hour shop,
- then hot backups make the most sense. If the database is not used at night,
- then nightly exports or cold backups are reasonable. A cold or hot backup
- involves physically copying the Oracle datafiles (control and log files also)
- to another location (tape or spare disk). On UNIX systems, DBAs often tar or
- cpio the files to tape. Other systems have utilities that may be used to
- backup files on the machine to tape or another directory.
-
- Backup strategies should be very carefully thought out and thoroughly tested
- because it could make life much easier when a database recovery must be
- performed. There is no ideal solution to backups. You will need to determine
- a solution/stategy that will be the most beneficial to your company.
-
-
- Kathy Jou
- Oracle Corporation
-
-