| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELO
I agree... cold can be the same, but recovery is different.
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-----
[mailto:Alexander.Feinstein_at_mitchell1.com]
Sent: Monday, March 18, 2002 4:23 PM
To: Multiple recipients of list ORACLE-L
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-----
<mailto:Robert_Freeman_at_csx.com> ]
Sent: Monday, March 18, 2002 11:48 AM
To: Multiple recipients of list ORACLE-L
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
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.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
<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).
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). Received on Mon Mar 18 2002 - 16:29:21 CST
 |
 |