Re: Database backup question.
Title: RE: Database backup question. You missed the last one. He is PHB again. Yechiel AdarMehish - Original Message - From: Whittle Jerome Contr NCI To: Multiple recipients of list ORACLE-L Sent: Friday, May 24, 2002 11:43 PM Subject: RE: Database backup question. Paul, There's a comic strip about office life called Dilbert. PHB stands for Pointy-Hair Boss. You can check it out at the site below. This week the PHB has been demoted back to worker-bee. http://www.dilbert.com/ Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Sherman, Paul R. [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 3:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: Database backup question. Jared, What in the W is a PHB ? Inquiring minds want to know. Thank you, Paul Sherman DBA Elcom, Inc. email - [EMAIL PROTECTED]
RE: Database backup question.
I don't understandy why you would switch to and from archivelog mode. You can establish a complete cold backup with your datafiles, control files, and online redo logs. Actually you don't need the online redo logs, but that used to be the case so I always back those up as well. Shut your DB down (normal), and back these files up. That is a complete cold backup. You certainly could place your database in archivelog mode, and still back it up with cold backups. In this scenario you just add the archived logs to your list of files to back up. The only valid reason I can think of for switching between modes would be to avoid excessive archivalresulting from very large processes. If you have room to archive logs you should consider leaving your DB in archivelog mode.Your odds of having a satisfying recovery scenario are greatly improved that way. Steve McClure -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Meomeo NguyenSent: Thursday, May 23, 2002 4:34 PMTo: Multiple recipients of list ORACLE-LSubject: Database backup question. Hi All, I need to perform a consistent backup for my whole database every Friday by using operating system utilities. My database has been currently operatingin NOARCHIVELOG mode, so the only files need to be backed up are datafiles, control files, the initialization parameter file and other oracle product initialization files (Based on Oracle8.1.6 Backup and Recovery Guide). Since the files in this type of backup are all consistent and do not need recovery, so the online logs are not needed. Since online redo logs is very crucial for recovery, so my question is do I need to back up the online redo log files as I choose to performcold backuptype for my entire database weekly?Here is step by step what I did to back up the whole database: after the database was closed cleanly and all the above mentioned files had been backed up into the tape. I had torestart the database and mount but not open,thenswitched between NOARCHIVELOG mode to ARCHIVELOG mode in order to archive the online redo log files. Finally, I copied all archived redo log files into the tape while the databasewas open and operated in ARCHIVELOG mode. when it wasalldone, I then switched the database back to NOARCHIVELOG mode. Just wondered whether my procedure to perform a whole consistent database backup is correct? Am I safe to this point? Your help is greatly appreciated it. Your help is greatly appreciated. Thanks in advance, Trang Do You Yahoo!?LAUNCH - Your Yahoo! Music Experience
Re: Database backup question.
On Thursday 23 May 2002 20:13, Tim Gorman wrote: ... So, here's the point: what if you take a cold backup in NOARCHIVELOG mode after a SHUTDOWN ABORT (that should have been a SHUTDOWN IMMEDIATE and wasn't) and you have *not* backed up those online redo log files? Answer: unusable backup. So, back up everything: all datafiles, controlfiles, and online redo logfiles. The latter are not too big anyway -- what's the point of excluding them? I have on more than one occasion been glad to have the online redo logs backed up. The common wisdom is that you don't need them. For various reasons they have at times made the difference between a recoverable backup and an unrecoverable backup. Particularly on NT, where there is no dearth of people that really don't know what they are doing with databases. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Database backup question.
Jared, What in the W is a PHB ? Inquiring minds want to know. Thank you, Paul Sherman DBAElcom, Inc. email - [EMAIL PROTECTED] -Original Message- Sent: Friday, May 24, 2002 4:25 PM To: Multiple recipients of list ORACLE-L On Thursday 23 May 2002 20:13, Tim Gorman wrote: ... So, here's the point: what if you take a cold backup in NOARCHIVELOG mode after a SHUTDOWN ABORT (that should have been a SHUTDOWN IMMEDIATE and wasn't) and you have *not* backed up those online redo log files? Answer: unusable backup. So, back up everything: all datafiles, controlfiles, and online redo logfiles. The latter are not too big anyway -- what's the point of excluding them? I have on more than one occasion been glad to have the online redo logs backed up. The common wisdom is that you don't need them. For various reasons they have at times made the difference between a recoverable backup and an unrecoverable backup. Particularly on NT, where there is no dearth of people that really don't know what they are doing with databases. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Sherman, Paul R. 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: Database backup question.
Title: RE: Database backup question. Paul, There's a comic strip about office life called Dilbert. PHB stands for Pointy-Hair Boss. You can check it out at the site below. This week the PHB has been demoted back to worker-bee. http://www.dilbert.com/ Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Sherman, Paul R. [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 3:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: Database backup question. Jared, What in the W is a PHB ? Inquiring minds want to know. Thank you, Paul Sherman DBA Elcom, Inc. email - [EMAIL PROTECTED]
RE: Database backup question.
-Original Message- From: Sherman, Paul R. [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 4:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: Database backup question. Jared, What in the W is a PHB ? Inquiring minds want to know. PHP is an abbreviation for Pointy Haired Boss, who is a shining example of damagement and lives at http://www.dilbert.com I cannot believe this!? There is actually somebody who doesn't know who is PHB? What is next? You will tell me that you don't know the answer to the question of life, universe and everything? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen 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: Database backup question.
Actually, *PHB* is Pointy-Haired Boss. *PHP* is a cool scripting language. PCP is Phencyclidin, aka Angel Dust. DNB is DBA Need Beer. TTFN! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 4:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Database backup question. -Original Message- From: Sherman, Paul R. [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 4:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: Database backup question. Jared, What in the W is a PHB ? Inquiring minds want to know. PHP is an abbreviation for Pointy Haired Boss, who is a -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Database backup question.
Mladen, It's not my fault. My karma was in the wrong quadrant as I read Jared's e-mail, and to make matters worse, the universal constant had become inconsistent. However, I do have all the answers that you seek. Simply send $1 million and I will reveal all. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -Original Message- Sent: Friday, May 24, 2002 5:54 PM To: Multiple recipients of list ORACLE-L -Original Message- From: Sherman, Paul R. [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 4:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: Database backup question. Jared, What in the W is a PHB ? Inquiring minds want to know. PHP is an abbreviation for Pointy Haired Boss, who is a shining example of damagement and lives at http://www.dilbert.com I cannot believe this!? There is actually somebody who doesn't know who is PHB? What is next? You will tell me that you don't know the answer to the question of life, universe and everything? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen 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: Sherman, Paul R. 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: Database backup question.
42 Gogala, Mladen wrote: -Original Message- From: Sherman, Paul R. [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 4:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: Database backup question. Jared, What in the W is a PHB ? Inquiring minds want to know. PHP is an abbreviation for Pointy Haired Boss, who is a shining example of damagement and lives at http://www.dilbert.com I cannot believe this!? There is actually somebody who doesn't know who is PHB? What is next? You will tell me that you don't know the answer to the question of life, universe and everything? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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: Database backup question.
dont forget DBA=DrinkBeerAgain Happy Memorial Day (a day to remember those who gave us this freedom)! Gene *Semper Fi* [EMAIL PROTECTED] 05/24/02 06:15PM Actually, *PHB* is Pointy-Haired Boss. *PHP* is a cool scripting language. PCP is Phencyclidin, aka Angel Dust. DNB is DBA Need Beer. TTFN! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 4:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Database backup question. -Original Message- From: Sherman, Paul R. [mailto:[EMAIL PROTECTED]] Sent: Friday, May 24, 2002 4:59 PM To: Multiple recipients of list ORACLE-L Subject: RE: Database backup question. Jared, What in the W is a PHB ? Inquiring minds want to know. PHP is an abbreviation for Pointy Haired Boss, who is a -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Gene Sais 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: Database backup question.
Paul, Haven't you seen Austin Powers ? $ 1 million isn't very much these days. You need to up your rates. Cheers, JoJo -Original Message- R. Mladen, It's not my fault. My karma was in the wrong quadrant as I read Jared's e-mail, and to make matters worse, the universal constant had become inconsistent. However, I do have all the answers that you seek. Simply send $1 million and I will reveal all. Thank you, Paul Sherman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JoJo Al-Zawawi 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: Database backup question.
Trang, Theoretically, the online redo log filesare be necessary, but the world has a habit of making a shambles of the theoretical.Let's say, in the event that you automate your Friday script, you'llprobably come to realize that SHUTDOWN IMMEDIATE is far from perfect (as well as far from immediate!). Over time, you'll probably construct some kind of "fail-safe" mechanism to SHUTDOWN ABORT if the initial SHUTDOWN IMMEDIATE doesn't shut down after a period of time. Pretty standard thing that DBAs have been writing for years. Hopefully, after the SHUTDOWN ABORT they also STARTUP RESTRICT and then SHUTDOWN NORMAL, but you can't count on it... So, here's the point: what if you take a cold backup in NOARCHIVELOG mode after a SHUTDOWN ABORT (that should have been a SHUTDOWN IMMEDIATE and wasn't) and you have *not* backed up those online redo log files? Answer: unusable backup. So, back up everything: all datafiles, controlfiles, and online redo logfiles. The latter are not too big anyway -- what's the point of excluding them? It is wise to take a cold backup after a clean shutdown, but you can even get a valid backup after a SHUTDOWN ABORT or a crash if you've backed up the online redo archive log files. When you restart Oracle, an instance recovery will occur automatically, and you might not evenknow it. Just be certain that the instance is truly "dead" when you take your "cold" backup... With regards to switching between ARCHIVELOG and NOARCHIVELOG, it's a waste of effort from a recoverability standpoint. At most it may be interesting, but as soon as you switch out of ARCHIVELOG mode, nothing you've done while in ARCHIVELOG mode is valid anymore. Leave it one wayor the other, and then leave it... ...just my $0.02... Another $0.02: use RMAN for your cold backups. Then you won't forget anything, because RMAN will remember for you... Hope this helps... -Tim - Original Message - From: Meomeo Nguyen To: Multiple recipients of list ORACLE-L Sent: Thursday, May 23, 2002 5:33 PM Subject: Database backup question. Hi All, I need to perform a consistent backup for my whole database every Friday by using operating system utilities. My database has been currently operatingin NOARCHIVELOG mode, so the only files need to be backed up are datafiles, control files, the initialization parameter file and other oracle product initialization files (Based on Oracle8.1.6 Backup and Recovery Guide). Since the files in this type of backup are all consistent and do not need recovery, so the online logs are not needed. Since online redo logs is very crucial for recovery, so my question is do I need to back up the online redo log files as I choose to performcold backuptype for my entire database weekly?Here is step by step what I did to back up the whole database: after the database was closed cleanly and all the above mentioned files had been backed up into the tape. I had torestart the database and mount but not open,thenswitched between NOARCHIVELOG mode to ARCHIVELOG mode in order to archive the online redo log files. Finally, I copied all archived redo log files into the tape while the databasewas open and operated in ARCHIVELOG mode. when it wasalldone, I then switched the database back to NOARCHIVELOG mode. Just wondered whether my procedure to perform a whole consistent database backup is correct? Am I safe to this point? Your help is greatly appreciated it. Your help is greatly appreciated. Thanks in advance, Trang Do You Yahoo!?LAUNCH - Your Yahoo! Music Experience
