Re: RE: Online vs offline backups

From: Rachel Carmichael <wisernet100_at_yahoo.com>
Date: Wed, 19 Jun 2002 07:13:29 -0800
Message-ID: <F001.004812CD.20020619071329@fatcity.com>

>I am sure people doing cold backup will do shutdown
> normal/immediate, not shutdown abort.So there is no need to backup

Are you? I'm not. I don't presume that the database has been shutdown cleanly unless I've done it myself. For a while (version 6 I think) you HAD to do a shutdown abort as a shutdown immediate had the potential to corrupt the database.

> the online redo log at all! Backup the online redo log also take the
> risk of damage the current online redo log when you want to do full
> recovery.

If you are not in archivelog mode when you do the cold backup, you don't CARE about the current online redo logs. And if you've done a shutdown abort before the backup you NEED the redo logs from the time of the backup or you have to open resetlogs

And open resetlogs is a messy way of recreating your redo logs.

• chal_ping <chaospku_at_163.net> wrote:
  > Ferenc Mantfeld£¬
  >
  > >The same person that advocated a cold backup
  > >did not back up the online redo logs, so what use was it anyway,
  > since the
  > >only way they would force open their DB is with a resetlogs option
  > anyway.
  > For cold backup, oracle does not recommend backup the online redo
  > log. And if you restore the whole cold backup, why need the online
  > redo log? I am sure people doing cold backup will do shutdown
  > normal/immediate, not shutdown abort.So there is no need to backup
  > the online redo log at all! Backup the online redo log also take the
  > risk of damage the current online redo log when you want to do full
  > recovery.
  > So, never backup the online redo log when doing cold backup.
  >
  > ÖÂ
  > Àñ£¡
  >
  > chal_ping
  > chaospku_at_163.net
  >
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > --
  > Author: chal_ping
  > INET: chaospku_at_163.net
  >
  > 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 - 10:13:29 CDT