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

What about the ability to be able to do point in time recovery? What about the ability to be able to make a copy of a database without having
to shut it down?
What about the ability to recover specific datafiles without having to shutdown the entire database.
What about the ability to recover specific blocks in your datafiles in 9i with the datafiles online?
What about the ability to be able to do incremental backups with RMAN? What about the ability to create a standby database architecture? What about the ability to store archived redo logs so we can mine them later?

Lots of reasons/benefits for archivelog mode, not a great deal of cost in return (some disk space, minimal CPU requirements).

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: Tuesday, March 19, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L NOARCHIVELO "CHAN Chor Ling Catherine (CSC)" wrote:
>
> 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.
>

You are right except for ONLY. Another reason is the desire to take hot backups (although indeed both reasons are usually linked).

-- 
Regards,

Stephane Faroult
Oriole Ltd
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.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).