Robert,
Let me disagree with you.
Cold *backup* is the same in archivelog mode and in noarchivelog mode.
The *recovery* is (could be) different.
Consider the following. I make a cold backup of a production DB, and restore into another server to build a test DB. What is wrong with this approach?
Alex.
-----Original Message-----
From: Freeman, Robert [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 18, 2002 11:48 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Should we say COLD or HOT backup OR ARCHIVELOG or
NOARCHIVELO
I agree with your definitions....but the cold backup in archivelog mode is
fundamentally different from one done in noarchivelog more (with respect to
online redo logs and control files) if you are in archivelog mode and want
to be able to do point in time recovery.
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 2:04 PM
To: Multiple recipients of list ORACLE-L
NOARCHIVELOG mo
[EMAIL PROTECTED] 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
[EMAIL PROTECTED]
------------------------------------------------------------------------
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
