Re: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELOG mo

bigplanet34_at_hotmail.com wrote:

> but isn't cold backup is possible only if ur running in noarchieve mode else
> you have to go for hot backup.
> BigP

OK let's get the definitions down first. AFAIK:

cold backup := database shut down and an OS copy of all the necessary files.

hot backup := place TS in backup mode, the do an OS copy of the files for that TS.

first can be done to any database, second only to databases in archivelog mode.

-- 
--
Bill "Shrek" Thater              ORACLE DBA
                 bthater2_at_netscape.net
------------------------------------------------------------------------
You gotta program like you don't need the money,
You gotta compile like you'll never get hurt,
You gotta run like there's nobody watching,
It's gotta come from the heart if you want it to work.
------------------------------------------------------------------------
I used to have a life, then I got v32bis!




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: bill thater
  INET: bthater2_at_netscape.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).