Re: Should we say COLD or HOT backup OR ARCHIVELOG or 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).
Re: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELOG mo
but isn't cold backup is possible only if ur running in noarchieve mode else you have to go for hot backup. BigP - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, March 18, 2002 7:41 AM > Ok maybe you will think this is a silly thread, but I've wondered > about this before... > > We (DBA's) use the terms hot and cold backups all the time. I wonder though, > when we talk about cold backups if the terminology should not include the > mode of the backup: > > cold archivelog mode backup > cold noarchivelog mode backup > > When we say "cold" backup, do we just assume it's NOARCHIVELOG mode...and > enjoy the fact that we don't have to type or say as much...or should we be > more specific to help the junior DBA's (or perhaps even those out there who > have never really considered that there is a distinction between the two) > out there? When books are written, I notice that they mostly just talk about > hot and cold backups, assuming that the cold backup is in NOARCHIVELOG > mode... > > what about the junior DBA who does a cold backup in ARCHIVELOG mode and > follows the standard cold backup procedure (backing up control files and > redo logs) assuming that he can just recover them(granted, anyone should > test > their backup and recovery strategy, but this is a Jr. DBA!) > > Just thinking aloud... is it a silly question? > > 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. > > > -- > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Big Planet 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).
Re: Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELOG mo
Hi Robert, Oracle University training uses the terms online and offline and points out that online backups can only be made to databases that are in archivelog mode. Offline backups can be made to either archivelog or noarchivelog databases. John [EMAIL PROTECTED] wrote: >Ok maybe you will think this is a silly thread, but I've wondered >about this before... > >We (DBA's) use the terms hot and cold backups all the time. I wonder though, >when we talk about cold backups if the terminology should not include the >mode of the backup: > >cold archivelog mode backup >cold noarchivelog mode backup > >When we say "cold" backup, do we just assume it's NOARCHIVELOG mode...and >enjoy the fact that we don't have to type or say as much...or should we be >more specific to help the junior DBA's (or perhaps even those out there who >have never really considered that there is a distinction between the two) >out there? When books are written, I notice that they mostly just talk about >hot and cold backups, assuming that the cold backup is in NOARCHIVELOG >mode... > >what about the junior DBA who does a cold backup in ARCHIVELOG mode and >follows the standard cold backup procedure (backing up control files and >redo logs) assuming that he can just recover them(granted, anyone should >test >their backup and recovery strategy, but this is a Jr. DBA!) > >Just thinking aloud... is it a silly question? > >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. > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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).
Should we say COLD or HOT backup OR ARCHIVELOG or NOARCHIVELOG mo
Ok maybe you will think this is a silly thread, but I've wondered about this before... We (DBA's) use the terms hot and cold backups all the time. I wonder though, when we talk about cold backups if the terminology should not include the mode of the backup: cold archivelog mode backup cold noarchivelog mode backup When we say "cold" backup, do we just assume it's NOARCHIVELOG mode...and enjoy the fact that we don't have to type or say as much...or should we be more specific to help the junior DBA's (or perhaps even those out there who have never really considered that there is a distinction between the two) out there? When books are written, I notice that they mostly just talk about hot and cold backups, assuming that the cold backup is in NOARCHIVELOG mode... what about the junior DBA who does a cold backup in ARCHIVELOG mode and follows the standard cold backup procedure (backing up control files and redo logs) assuming that he can just recover them(granted, anyone should test their backup and recovery strategy, but this is a Jr. DBA!) Just thinking aloud... is it a silly question? 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. -- 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).
