Message-ID: <F001.00481891.20020619095835@fatcity.com>
Date: Wed, 19 Jun 2002 09:58:35 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Rachel Carmichael <wisernet100@yahoo.com>
Subject: RE: RE: RE: Online vs offline backups
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 8bit

oh heck, if the recovery is that drastic, I'd probably backup the files
CURRENTLY on disk before restoring anything, just so that I had a place
I could return to if the restore didn't work properly (yes, I make
typos at 3AM!)


--- "Mercadante, Thomas F" <NDATFM@labor.state.ny.us> wrote:
> chaos,
> 
> if you believe everything you read in the oracle docs, then your are
> NOT a
> thinking DBA.  just because they failed to mention that you should
> backup
> the log files does NOT mean you should not back them up.
> 
> as everyone who knows anything has stated in this thread, this is a
> very bad
> idea.  never mind the "what if" scenario you mentioned.  anyone who
> is
> performing a database restore had better know exactly what and where
> they
> are restoring to (what point in time), and the condition of all of
> the
> database files on the disk before they begin.  if they don't, they
> are in
> for trouble.
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> 
> -----Original Message-----
> Sent: Wednesday, June 19, 2002 11:43 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> hi, Mercadante, Thomas F，您好！
>     But according to Oracle Document(which i believe), oracle backup
> and
> recovery guide (version 8.1.6)page 4-4: it said:
> 
>    Use operating system commands or a backup utility to make backups
> of all
> datafiles and all control files specified by the CONTROL_FILES
> parameter of
> the initialization parameter file. Also back up the initialization
> parameter
> file
> and other Oracle product initialization files. To find them, do a
> search for
> *.ora starting in your Oracle home directory and recursively search
> all of
> its
> subdirectories.
> 	You can see, oracle mentions everything it need, but it does not
> mention the online redo log.
> 	And:
> 	Is the online redo log useful in recovery since you do a full  clean
> cold backup? Just do a clear logfile group 1,2,3 and you cleanly
> opened your
> database when you Just restore the datafile,controlfiles.If you want
> to make
> full recovery, the online redo log is also totally USELESS. And if
> you
> carelessly overlay the old online redo log, the CURRENT ACTIVE ONLINE
> REDO
> LOG WILL BE DESTROYED! so , you cannot do complete recovery.
> 	This is my opinions.Though i also do not do coldbackup.
> 
> Good luck!
> 
>             chaos
>             chaospku@163.net
> 
> zhu chao
> DBA of Eachnet.com
> 86-021-32174588-667
> 
> 
> 在 2002-06-19 06:43:00 You wrote:
> >chal_ping
> >
> >What?  Makes no sense.  Why NOT backup everything if you are taking
> a Cold
> >Backup.  Why make yourself perform an open reset logs upon a
> recovery?
> >
> >This is bad advice.
> >
> >Personally, I use Rman performing hot backups all the time.  My
> database is
> >*always* open to the world.
> >
> >Tom Mercadante
> >Oracle Certified Professional
> >
> >
> >-----Original Message-----
> >Sent: Wednesday, June 19, 2002 8:38 AM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >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@163.net
> >
> >-- 
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >-- 
> >Author: chal_ping
> >  INET: chaospku@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@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).
> >-- 
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >-- 
> >Author: Mercadante, Thomas F
> >  INET: NDATFM@labor.state.ny.us
> >
> >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@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).
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: chaos
>   INET: chaospku@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@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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mercadante, Thomas F
>   INET: NDATFM@labor.state.ny.us
> 
> 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@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@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@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).