Re: Repost: Offline vs Online

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Wed, 19 Jun 2002 11:43:35 -0800
Message-ID: <F001.00481BDB.20020619114335@fatcity.com>

by definition, a 24x7 shop would not be able to execute an offline backup since that would mean that the database was not 24x7

Jeremiah's first post, pointing you to the note on his website did answer your question.

bottom line, if your database is in archivelog mode, and you have an uptime requirement that makes it difficult if not impossible to shut the database down for the length of an offline backup, you can certainly do ONLY online backups as long as you also backup the archived redo logs

Offline backups are done for peace of mind, but are NOT necessary if you have thoroughly tested your recovery procedures (as Tom already pointed out)

• Tracy Rahmlow <tracy.rahmlow_at_aexp.com> wrote:
  > I appreciate the ongoing discussion regarding the logs, but does
  > anybody have
  > any comments
  > regarding the questions I previously asked? Here they are again:
  >
  >
  > If you create a new database and do a full online backup (this also
  > includes
  > future regular full online backups) is it ever necessary to do a full
  > offline
  > backup(ie shutdown, backup, startup)? I have heard conflicting
  > answers,
  > regarding
  > this and am looking for some clarification. Don't 24x7 applications
  > always
  > have to
  > execute offline backups? Are offline backups done for peace of mind,
  > and if
  > yes why? What
  > issues are introduced if only offline backups are issued. In
  > addition, we are
  > using BMCs Sql BackTrack product and I am not sure if it is a
  > requirement of
  > the tool that an offline backup be periodically performed. If you
  > know that as
  > well, please share. Thanks
  >
  >
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > --
  > Author: Tracy Rahmlow
  > INET: tracy.rahmlow_at_aexp.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
  > San Diego, California -- Public Internet access / Mailing
  > Lists
  > --------------------------------------------------------------------
  > To REMOVE yourself from this mailing list, send an E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB ORACLE-L
  > (or the name of mailing list you want to be removed from). You may
  > also send the HELP command for other information (like subscribing).
  

  ---

Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed Jun 19 2002 - 14:43:35 CDT