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:[EMAIL PROTECTED]] 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:[EMAIL PROTECTED]> ] 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 [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 <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 <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). -- 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).