Re: Oracle Backups

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

all of the redo logs since the last Received on Mon Jan 23 1995 - 14:10:01 CET