Re: Oracle Backups

Noah Monsey (noah_at_indirect.com) wrote:
: William J. Lopez (wjl_at_peabody.ftc.scs.ag.gov) wrote:
 

: : How does one backup an instance of Oracle?
: : /\
: : / \ /^\ Computer Data Systems, Inc.
: : / ^^ \ \/^\/^^\ 2625 Redwing Drive, Suite 340
: : / ^^^^ \ / \ Fort Collins, CO 80526
: : ~~~[]~~~ ---------------------------------------------------------
: : Willie Lopez Phone: 303-282-2476
: : internet: wjl_at_kaine.ftc.nrcs.usda.gov
 

: : << "Different action produces different results!", Tony Robbins >>
 

: There are several methods of backing up an Oracle database.
 

: The simplest and safest way is to do a normal shutdown
: and back up all of the data files, control files, redo logs
: at once.
 

: If you cannot afford to be down for the time it takes
: to do an offline backup you can backup all of the individual
: tablespaces except the system tablespace while the system is
: running. Online backups require you to take each tablespace
: offline (user's can still access data), while you are backing
: it up.
 

: If you are running in "archive log mode" it is simple to take
: you last complete offline backup and restore the database to the
: state it was in when the instance failed. If you keep your
: "archive log dest" on a different physical disk drive from the
: database files, and keep the redo logs for a sufficient amount
: of time offline backups are somewhat unnecessary. Offline
: backups are hard to manage unless all user data is kept
: in the same tablespace.

: Oracle Master Database Administration April 92
: Noah Monsey
: noah_at_indirect.com

I made a mistake in the earlier posting. I meant to say

If you keep all of the redo logs since the last offline backup then the online backup's become unnecassary. The offline backup's are the fastest way to insure that you can recover from an instance or hardware failure in a short time.

Noah Received on Tue Jan 24 1995 - 19:51:49 CET