Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Mon, 18 Mar 2002 17:38:20 -0800
Message-ID: <F001.0042CAE3.20020318173820@fatcity.com> 





No no.. You are correct.



In my case, since no changes are made to the database other than the data
loads, and there are no issues about recovering from the last cold backup &
the downtime involved, we can live with noarchivelog mode. That's all. 



Cold backups with noarchivelog mode are useless if point-in-time recovery is
desired.   



It all depends on the requirements.






-----Original Message-----


Sent: Monday, March 18, 2002 7:03 PM


To: Multiple recipients of list ORACLE-L
NOARCHIVELO



Hi, 



Pardon me if I am wrong, I thought the only reason for the database to be in
archive log mode is so that I can recover the database up to the time when
the database crushes.



For example, we do cold backup nitely. If the database were to crush etc at
2pm, I would be able to recover my database up to 2pm by using the cold
backup and the archive log generated until 2 pm.



However, if my database has no archivelog, I can only recover my database
using the backup last nite.  



In my opinion, database in archive log mode is very important if I need to
be able to recover the database up to the point of failure.



Please correct me if I am wrong. Thanks.



Regds,


New Bee

		-----Original Message-----
		From:	Deshpande, Kirti
[mailto:kirti.deshpande_at_verizon.com]
		Sent:	Tuesday, March 19, 2002 8:13 AM
		To:	Multiple recipients of list ORACLE-L
		Subject:	RE: Should we say COLD or HOT backup OR


ARCHIVELOG or NOARCHIVELO


		Here is en exception: 
		I happen to administer a couple of data mart databases, that
are loaded once
		or twice a month. Both run in noarchive log mode. This is
how these have
		been set up when we started back in 1998. We take cold
backups after the
		data load, table/partition analyze. It takes 5 hours max on
a Sunday. No
		other changes are made to any of the data till the next data
load. 
		We have yet to see a reason for these databases to be
running in archivelog
		mode. In the worst case, the recovery of the largest db


(80GB) is about 8

		hours from backups (Yes, we do DRP drills). And that type of
downtime is
		perfectly alright with the business and end users. 

		- Kirti 

		-----Original Message-----
		Sent: Monday, March 18, 2002 4:59 PM
		To: Multiple recipients of list ORACLE-L
		NOARCHIVELO


		Connor - Good points, but obviously there are exceptions. We
have a data
		warehouse that we keep in NOARCHIVELOG mode. After the
weekly load we do a
		cold backup. However, lately there has been talk of some
updates during the
		week, so that may have to change.
		Dennis Williams
		DBA
		Lifetouch, Inc.
		dwilliams_at_lifetouch.com


		-----Original Message-----
		Sent: Monday, March 18, 2002 3:28 PM
		To: Multiple recipients of list ORACLE-L
		NOARCHIVELO


		Just to add to the controversy, I often make the
		argument to developers/users/managers/etc that
		noarchivelog does not exist.  

		In my opinion, 'noarchivelog' is like waving a flag
		saying "I stand an excellent chance of losing a whole
		lot of data one day".

		Some years ago at a place I worked, some idiot came up
		with some piece of nonsense along the lines of "We
		don't make any changes, we do a cold backup each
		night, and we can easily reapply the flat files that
		are sqlldr'd into the db each morning"... and thus
		went for a noarchivelog strategy.

		When it did go belly up, this "simple" option turned
		into a nightmarish exercise...

		Even worse, the idiot happened to be me at the time
		:-)

		 --- "Freeman, Robert " <Robert_Freeman_at_csx.com>
		wrote: > I can read your question 2 ways, so let me
		answer it
		> both ways...
		> 
		> If you are asking if you can only do a cold backup
		> when in noarchivelog
		> mode, you are correct.
		> 
		> However, in archivelog mode you can do cold or hot
		> backup. The procedure is
		> a bit different in archivelog mode, because of the
		> recovery implications of
		> being in archivelog mode.
		> 
		> RF
		> 
		> Robert G. Freeman - Oracle8i OCP
		> Oracle DBA Technical Lead
		> CSX Midtier Database Administration
		> 
		> The Cigarette Smoking Man: Anyone who can appease a
		> man's conscience can
		> take his freedom away from him.
		> 
		> 
		> 
		> -----Original Message-----
		> Sent: Monday, March 18, 2002 1:28 PM
		> To: Multiple recipients of list ORACLE-L
		> NOARCHIVELOG mo
		> 
		> 
		> but isn't cold backup is possible only if ur running
		> in noarchieve mode else
		> you have to go for hot backup.
		> BigP
		> 
		> ----- Original Message -----
		> To: "Multiple recipients of list ORACLE-L"
		> <ORACLE-L_at_fatcity.com>
		> Sent: Monday, March 18, 2002 7:41 AM
		> 
		> 
		> > Ok.... maybe you will think this is a silly
		> thread, but I've wondered
		> > about this before...
		> >
		> > We (DBA's) use the terms hot and cold backups all
		> the time. I wonder
		> though,
		> > when we talk about cold backups if the terminology
		> should not include the
		> > mode of the backup:
		> >
		> > cold archivelog mode backup
		> > cold noarchivelog mode backup
		> >
		> > When we say "cold" backup, do we just assume it's
		> NOARCHIVELOG mode...and
		> > enjoy the fact that we don't have to type or say
		> as much...or should we be
		> > more specific to help the junior DBA's (or perhaps
		> even those out there
		> who
		> > have never really considered that there is a
		> distinction between the two)
		> > out there? When books are written, I notice that
		> they mostly just talk
		> about
		> > hot and cold backups, assuming that the cold
		> backup is in NOARCHIVELOG
		> > mode...
		> >
		> > what about the junior DBA who does a cold backup
		> in ARCHIVELOG mode and
		> > follows the standard cold backup procedure
		> (backing up control files and
		> > redo logs) assuming that he can just recover
		> them....(granted, anyone
		> should
		> > test
		> > their backup and recovery strategy, but this is a
		> Jr. DBA!)
		> >
		> > Just thinking aloud... is it a silly question?
		> >
		> > Robert G. Freeman - Oracle8i OCP
		> > Oracle DBA Technical Lead
		> > CSX Midtier Database Administration
		> >
		> > The Cigarette Smoking Man: Anyone who can appease
		> a man's conscience can
		> > take his freedom away from him.
		> >
		> >
		> > --
		> > Please see the official ORACLE-L FAQ:
		> http://www.orafaq.com
		> > --
		> > Author: Freeman, Robert
		> >   INET: Robert_Freeman_at_csx.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).
		> >
		> -- 
		> Please see the official ORACLE-L FAQ:
		> http://www.orafaq.com
		> -- 
		> Author: Big Planet
		>   INET: bigplanet34_at_hotmail.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).
		> -- 
		> Please see the official ORACLE-L FAQ:
		> http://www.orafaq.com
		> -- 
		> Author: Freeman, Robert 
		>   INET: Robert_Freeman_at_csx.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). 

		=====
		Connor McDonald
		http://www.oracledba.co.uk (mirrored at 
		http://www.oradba.freeserve.co.uk)

		"Some days you're the pigeon, some days you're the statue"

		__________________________________________________
		Do You Yahoo!?
		Everything you'll ever need on one web page
		from News and Sport to Email and Music Charts
		http://uk.my.yahoo.com
		-- 
		Please see the official ORACLE-L FAQ: http://www.orafaq.com
		-- 
		Author: =?iso-8859-1?q?Connor=20McDonald?=
		  INET: hamcdc_at_yahoo.co.uk

		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).
		-- 
		Please see the official ORACLE-L FAQ: http://www.orafaq.com
		-- 
		Author: DENNIS WILLIAMS
		  INET: DWILLIAMS_at_LIFETOUCH.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).
		-- 
		Please see the official ORACLE-L FAQ: http://www.orafaq.com
		-- 
		Author: Deshpande, Kirti
		  INET: kirti.deshpande_at_verizon.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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: CHAN Chor Ling Catherine (CSC)
  INET: clchan_at_nie.edu.sg

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.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 Mon Mar 18 2002 - 19:38:20 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US