RE: rman backup
Sorry to respond to such an old thread (man I'm way behind), but what if the expected location of the archived logs isn't large enough? For example, let's say we have a 10G archive directory, and we dump 5-10G of logs per day. I have to go to a backup made a week ago. That's 35-70G worth of logs if I need to roll forward. Does RMAN try and cram 'em all in at once, or will it roll through them? That sure would be a nice feature. ;-) -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DENNIS WILLIAMS Sent: Tuesday, October 28, 2003 3:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: rman backup AK When you have RMAN back up archived logs, IIRC, in a recovery RMAN first restores those archived logs to the location that Oracle will expect them to be, and I believe that is done as part of the RESTORE DATABASE command. In my situation, I found no advantage from having RMAN store the archive logs, so I have no experience there, just what I've read in the manual. Only RMAN can perform the RESTORE DATABASE command, but once you complete that command, you can complete the recovery using svrmgrl. From everything I've seen, RMAN just issues the RECOVER DATABASE command to svrmgrl or SQL*Plus. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 1:15 PM To: Multiple recipients of list ORACLE-L Thanks Dennis for Reply, My confusion is , does RMAN sees only those archived logs which are backup using rman or it can use current archived log as well stored in original format at other disk ? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 10:49 AM AK - Unless you specify otherwise, RMAN will automatically apply archive logs to bring the database up to the time of failure (your recover database statement). This is why it is good to run disaster recovery tests on a regular basis, to ensure everything is ready, and you can try different recovery times. You will see that RMAN will not complete its recovery if the archived logs are not available. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 11:44 AM To: Multiple recipients of list ORACLE-L We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible to run { restore databse; recover database } from rman and then apply remaing archived logs from a separated disk ( not a rman backup ). Thanks, -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
Table recovery from RMAN backup
Hi Gurus, I have accidentally deleted my table in development env. RMAN is the only backup available here. How do i recover the droped table? Any help would be really appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Table recovery from RMAN backup
Take a look at TSPITR (tablespace point in time recovery), I believe that's how it's performed as I've never tried it. Essentially RMAN creates a temporary database, recovers the objects in the tablespace targeted for recovery, and then you can recover the data in the object(s) in question. At 08:14 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Hi Gurus, I have accidentally deleted my table in development env. RMAN is the only backup available here. How do i recover the droped table? Any help would be really appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Andy Rivenes Lawrence Livermore National Laboratory Phone: 925-424-9834 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Table recovery from RMAN backup
Jay, if it is 9.2.0.4 and if you have undo_retention set, you can do a flashback query. If not, you must recover the database to the specific time, you cannot recover just a single table. You should probably read the TSPITR recovery chapter in Rob Freeman's book. I have, a long time ago, but I've never done it. On 12/12/2003 11:14:33 AM, [EMAIL PROTECTED] wrote: Hi Gurus, I have accidentally deleted my table in development env. RMAN is the only backup available here. How do i recover the droped table? Any help would be really appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Table recovery from RMAN backup
Metalink Note:223543.1 has good information on how to recover just a single table using a modified TSPITR. I performed this operation successful on a data warehouse. Josh -Original Message- Sent: Friday, December 12, 2003 8:59 AM To: Multiple recipients of list ORACLE-L Jay, if it is 9.2.0.4 and if you have undo_retention set, you can do a flashback query. If not, you must recover the database to the specific time, you cannot recover just a single table. You should probably read the TSPITR recovery chapter in Rob Freeman's book. I have, a long time ago, but I've never done it. On 12/12/2003 11:14:33 AM, [EMAIL PROTECTED] wrote: Hi Gurus, I have accidentally deleted my table in development env. RMAN is the only backup available here. How do i recover the droped table? Any help would be really appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Table recovery from RMAN backup
Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I heard some positive comments about Robert Freeman's book. Thanks Sami - Original Message - Date: Friday, December 12, 2003 11:34 am Take a look at TSPITR (tablespace point in time recovery), I believe that's how it's performed as I've never tried it. Essentially RMAN creates a temporary database, recovers the objects in the tablespace targeted for recovery, and then you can recover the data in the object(s) in question. At 08:14 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Hi Gurus, I have accidentally deleted my table in development env. RMAN is the only backup available here. How do i recover the droped table? Any help would be really appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- 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). Andy Rivenes Lawrence Livermore National Laboratory Phone: 925-424-9834 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services --- -- 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Table recovery from RMAN backup
Hi! I believe flashback query works only on existing tables, you can query deleted data from it for example, but you can't see dropped tables with it. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 12, 2003 6:59 PM Jay, if it is 9.2.0.4 and if you have undo_retention set, you can do a flashback query. If not, you must recover the database to the specific time, you cannot recover just a single table. You should probably read the TSPITR recovery chapter in Rob Freeman's book. I have, a long time ago, but I've never done it. On 12/12/2003 11:14:33 AM, [EMAIL PROTECTED] wrote: Hi Gurus, I have accidentally deleted my table in development env. RMAN is the only backup available here. How do i recover the droped table? Any help would be really appreciated. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Table recovery from RMAN backup
You can use export and flashback to recover a dropped table. The only time I needed it, it gave a warning on the export but still worked OK. Simon Anderson SciSys Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/12/2003 17:49 Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Table recovery from RMAN backup Hi! I believe flashback query works only on existing tables, you can query deleted data from it for example, but you can't see dropped tables with it. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Table recovery from RMAN backup
The Oracle documentation. It's pretty good and that combined with Metalink should give you most everything you need to know. At 09:44 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I heard some positive comments about Robert Freeman's book. Thanks Sami Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Table recovery from RMAN backup
Rob Freeman's book is actually excellent. I wholeheartedly recommend it, not only because Robert is paying me commission but also because you have every hing in one place and you don't have to search endlessly for useful examples and explanations. Robert's very clear and to the point style of writing should not be underestimated (misunderestimated?) either. If you're a beginner, looking to delve into RMAN, Robert Freeman's book is a must have. Also, Joe Testa used to have some very useful examples and scripts which I've fortgotten to mention so far. scripts. On 12/12/2003 01:34:25 PM, Andy Rivenes wrote: The Oracle documentation. It's pretty good and that combined with Metalink should give you most everything you need to know. At 09:44 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I heard some positive comments about Robert Freeman's book. Thanks Sami Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Table recovery from RMAN backup
Mladen I'll send you $10 payment fee via paypal :) joe Mladen Gogala wrote: Rob Freeman's book is actually excellent. I wholeheartedly recommend it, not only because Robert is paying me commission but also because you have every hing in one place and you don't have to search endlessly for useful examples and explanations. Robert's very clear and to the point style of writing should not be underestimated (misunderestimated?) either. If you're a beginner, looking to delve into RMAN, Robert Freeman's book is a must have. Also, Joe Testa used to have some very useful examples and scripts which I've fortgotten to mention so far. scripts. On 12/12/2003 01:34:25 PM, Andy Rivenes wrote: The Oracle documentation. It's pretty good and that combined with Metalink should give you most everything you need to know. At 09:44 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I heard some positive comments about Robert Freeman's book. Thanks Sami Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Table recovery from RMAN backup
Sami, While you are purchasing the reading material also look at the 101 series as excellent references. Oracle Performance tuning 101, Oracle dba 101, Oracle backup and recovery 101.There are a lot of excellent references on the market and a lot of authors participate on this list. You can get answers to your questions here. I also recommend Robert Freeman's book on RMAN usage as well as the book Expert One-on-One by Thomas Kyte Ron [EMAIL PROTECTED] 12/12/2003 2:04:38 PM Rob Freeman's book is actually excellent. I wholeheartedly recommend it, not only because Robert is paying me commission but also because you have every hing in one place and you don't have to search endlessly for useful examples and explanations. Robert's very clear and to the point style of writing should not be underestimated (misunderestimated?) either. If you're a beginner, looking to delve into RMAN, Robert Freeman's book is a must have. Also, Joe Testa used to have some very useful examples and scripts which I've fortgotten to mention so far. scripts. On 12/12/2003 01:34:25 PM, Andy Rivenes wrote: The Oracle documentation. It's pretty good and that combined with Metalink should give you most everything you need to know. At 09:44 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I heard some positive comments about Robert Freeman's book. Thanks Sami Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Table recovery from RMAN backup
My Question: I just tried to locate the web site for Joe's scripts, and I got an error or something. Wasssup? My Contribution (xmas season and all...): http://www.secunia.com/internet_explorer_address_bar_spoofing_test Is it too early to wish merry xmas to all? Thanks in advance. Regards, Mike Thomas --- Joe Testa [EMAIL PROTECTED] wrote: Mladen I'll send you $10 payment fee via paypal :) joe Mladen Gogala wrote: Rob Freeman's book is actually excellent. I wholeheartedly recommend it, not only because Robert is paying me commission but also because you have every hing in one place and you don't have to search endlessly for useful examples and explanations. Robert's very clear and to the point style of writing should not be underestimated (misunderestimated?) either. If you're a beginner, looking to delve into RMAN, Robert Freeman's book is a must have. Also, Joe Testa used to have some very useful examples and scripts which I've fortgotten to mention so far. scripts. On 12/12/2003 01:34:25 PM, Andy Rivenes wrote: The Oracle documentation. It's pretty good and that combined with Metalink should give you most everything you need to know. At 09:44 AM 12/12/2003 -0800, [EMAIL PROTECTED] wrote: Dear Andy Mladen Thanks for your immediate help. BTW what is the best book for RMAN in the market( ver 9i). I heard some positive comments about Robert Freeman's book. Thanks Sami Andy Rivenes Email: [EMAIL PROTECTED] -- __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
rman backup
We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible to run { restore databse; recover database } from rman and then apply remaing archived logs from a separated disk ( not a rman backup ). Thanks, -ak
RE: rman backup
AK - Unless you specify otherwise, RMAN will automatically apply archive logs to bring the database up to the time of failure (your recover database statement). This is why it is good to run disaster recovery tests on a regular basis, to ensure everything is ready, and you can try different recovery times. You will see that RMAN will not complete its recovery if the archived logs are not available. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 11:44 AM To: Multiple recipients of list ORACLE-L We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible to run { restore databse; recover database } from rman and then apply remaing archived logs from a separated disk ( not a rman backup ). Thanks, -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: rman backup
You can restore database and open it to the mount phase using RMAN. Then you can get into sqlplus and type something like: alter system set log_archive_dest_1=/directory/where/log/archives/reside set autorecovery on recover database auto until cancel On 10/28/2003 12:44:24 PM, AK wrote: We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible to run { restore databse; recover database } from rman and then apply remaing archived logs from a separated disk ( not a rman backup ). Thanks, -ak Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: rman backup
Thanks Dennis for Reply, My confusion is , does RMAN sees only those archived logs which are backup using rman or it can use current archived log as well stored in original format at other disk ? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 10:49 AM AK - Unless you specify otherwise, RMAN will automatically apply archive logs to bring the database up to the time of failure (your recover database statement). This is why it is good to run disaster recovery tests on a regular basis, to ensure everything is ready, and you can try different recovery times. You will see that RMAN will not complete its recovery if the archived logs are not available. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 11:44 AM To: Multiple recipients of list ORACLE-L We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible to run { restore databse; recover database } from rman and then apply remaing archived logs from a separated disk ( not a rman backup ). Thanks, -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: rman backup
As long as you have the database in archivelog mode and have a level 0 backup as your starting point then you can recover. Make sure that your level 0 includes the controlfiles. HTH, Ruth -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of AKSent: Tuesday, October 28, 2003 12:44 PMTo: Multiple recipients of list ORACLE-LSubject: rman backup We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible to run { restore databse; recover database } from rman and then apply remaing archived logs from a separated disk ( not a rman backup ). Thanks, -ak
RE: rman backup
AK When you have RMAN back up archived logs, IIRC, in a recovery RMAN first restores those archived logs to the location that Oracle will expect them to be, and I believe that is done as part of the RESTORE DATABASE command. In my situation, I found no advantage from having RMAN store the archive logs, so I have no experience there, just what I've read in the manual. Only RMAN can perform the RESTORE DATABASE command, but once you complete that command, you can complete the recovery using svrmgrl. From everything I've seen, RMAN just issues the RECOVER DATABASE command to svrmgrl or SQL*Plus. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 1:15 PM To: Multiple recipients of list ORACLE-L Thanks Dennis for Reply, My confusion is , does RMAN sees only those archived logs which are backup using rman or it can use current archived log as well stored in original format at other disk ? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 10:49 AM AK - Unless you specify otherwise, RMAN will automatically apply archive logs to bring the database up to the time of failure (your recover database statement). This is why it is good to run disaster recovery tests on a regular basis, to ensure everything is ready, and you can try different recovery times. You will see that RMAN will not complete its recovery if the archived logs are not available. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 11:44 AM To: Multiple recipients of list ORACLE-L We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible to run { restore databse; recover database } from rman and then apply remaing archived logs from a separated disk ( not a rman backup ). Thanks, -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: AW: RMAN Backup to tape or disk (SAN) ???
Hi, If I remember correctly MMLs like Veritas and/or Legato let you rebuild the indexes if you have the tape in hand - It can be slow but I thought it could be done. Regard, Craig. At 09:46 AM 8/05/2003 -0800, Stephen Lee wrote: One consideration with MML if this is a case of a tornado wiped out the data center: The MML is dependent on its media index(es); which (if I understanding the operation of the MML correctly) is dependent on the sys admins being able to restore the non-Oracle part of the box. So, in a case of it hit the fan so hard the blades broke off (either that or a root user was experimenting with rm -rf * (Where did it go?!)), it seems to me that you have a dependency on the reliability of your sys admins. I thought I would toss that in just in case you were feeling an uncontrollable urge to go breathe down somebody's neck. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Craig Munday INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Checking RMAN backup results
We are working with windows servers and we check the error level after Rman finish. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, September 17, 2003 8:39 AM Posted on behalf of Rich Holland ([EMAIL PROTECTED]): Apparently my ISP went off-line for a couple days, and my oracle-L mailing list subscripshun [purposefully spelled incorrectly to avoid the listmangler filters -rjh] was moved to the bounced mailing list. Below is a message I sent on 9/10. I tried searching the online archives @ ListGuru and orafaq with no luck (I can't even find my original posting from 9/10, let alone any replies). If you replied, can you re-send your response via email? I'd greatly appreciate it... Thanks! Rich -- Rich Holland [EMAIL PROTECTED] SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message- Sent: Wednesday, September 10, 2003 11:13 AM Subject: Checking RMAN backup results Before I reinvent the wheel, I thought I'd ping the list to see how other folks are validating their RMAN backups. In other words, when your backup_full script runs, do you just parse the results looking for RMAN- or ORA- errors, Backup completed successfully etc? Or do you run a validate step and process that? What's the general consensus on automating backup checking? I'd like to just be emailed when there's a problem, rather than doing manual checks every day for the previous night's backups. -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); - end returned message - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Checking RMAN backup results
Title: RE: Checking RMAN backup results Alghough I use the RMAN catalog and so backup success/failure can be seen from there. I find it easiest to write out a log of the entire backup process in my calling script to a specific directory /dblogs/backups All my backup scripts are written their with date/timestamp in the name along with database name. At the end of the backup I parse out the word SUCCESS or FAILURE with the same Unix commands and sent mails. Eventually I want to write a process that looks at the logs for all the backups for a particular date which I will run each night and sends a comprehensive list which would be compared against a list of all the databases I administer. I have written the scripts to basically run just passing parameters - so I utilize the same stored scripts, I have uniquely named call scripts which only pass database name. Then I run some basic rman call scripts for various types of backups. Everything has been running like a charm for years now and this approach has made it very easy to support multiple catalogs in one database or multiple rcat catalogs. If you would like I could send you some examples. I know others have posted their rman stuff which I keep telling myself I will have time to look at. Probably some along the same lines. -Original Message- From: Bruce A. Bergman To: Multiple recipients of list ORACLE-L Sent: 9/17/03 2:39 AM Subject: FWD: Checking RMAN backup results Posted on behalf of Rich Holland ([EMAIL PROTECTED]): Apparently my ISP went off-line for a couple days, and my oracle-L mailing list subscripshun [purposefully spelled incorrectly to avoid the listmangler filters -rjh] was moved to the bounced mailing list. Below is a message I sent on 9/10. I tried searching the online archives @ ListGuru and orafaq with no luck (I can't even find my original posting from 9/10, let alone any replies). If you replied, can you re-send your response via email? I'd greatly appreciate it... Thanks! Rich -- Rich Holland [EMAIL PROTECTED] SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message- Sent: Wednesday, September 10, 2003 11:13 AM Subject: Checking RMAN backup results Before I reinvent the wheel, I thought I'd ping the list to see how other folks are validating their RMAN backups. In other words, when your backup_full script runs, do you just parse the results looking for RMAN- or ORA- errors, Backup completed successfully etc? Or do you run a validate step and process that? What's the general consensus on automating backup checking? I'd like to just be emailed when there's a problem, rather than doing manual checks every day for the previous night's backups. -- Rich Holland (913) 645-1950 SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); - end returned message - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Checking RMAN backup results
Rich, I parse the Rman output using Perl and look for RMAN-00569 in the output file. If I find it, then I send email to myself with a subject line indicating that the backup failed. Pretty simple. And it's been working well for a few years now. The Perl script is available free. Just email me off-line. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 17, 2003 2:39 AM To: Multiple recipients of list ORACLE-L Posted on behalf of Rich Holland ([EMAIL PROTECTED]): Apparently my ISP went off-line for a couple days, and my oracle-L mailing list subscripshun [purposefully spelled incorrectly to avoid the listmangler filters -rjh] was moved to the bounced mailing list. Below is a message I sent on 9/10. I tried searching the online archives @ ListGuru and orafaq with no luck (I can't even find my original posting from 9/10, let alone any replies). If you replied, can you re-send your response via email? I'd greatly appreciate it... Thanks! Rich -- Rich Holland [EMAIL PROTECTED] SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message- Sent: Wednesday, September 10, 2003 11:13 AM Subject: Checking RMAN backup results Before I reinvent the wheel, I thought I'd ping the list to see how other folks are validating their RMAN backups. In other words, when your backup_full script runs, do you just parse the results looking for RMAN- or ORA- errors, Backup completed successfully etc? Or do you run a validate step and process that? What's the general consensus on automating backup checking? I'd like to just be emailed when there's a problem, rather than doing manual checks every day for the previous night's backups. -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); - end returned message - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
FWD: Checking RMAN backup results
Posted on behalf of Rich Holland ([EMAIL PROTECTED]): Apparently my ISP went off-line for a couple days, and my oracle-L mailing list subscripshun [purposefully spelled incorrectly to avoid the listmangler filters -rjh] was moved to the bounced mailing list. Below is a message I sent on 9/10. I tried searching the online archives @ ListGuru and orafaq with no luck (I can't even find my original posting from 9/10, let alone any replies). If you replied, can you re-send your response via email? I'd greatly appreciate it... Thanks! Rich -- Rich Holland [EMAIL PROTECTED] SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message- Sent: Wednesday, September 10, 2003 11:13 AM Subject: Checking RMAN backup results Before I reinvent the wheel, I thought I'd ping the list to see how other folks are validating their RMAN backups. In other words, when your backup_full script runs, do you just parse the results looking for RMAN- or ORA- errors, Backup completed successfully etc? Or do you run a validate step and process that? What's the general consensus on automating backup checking? I'd like to just be emailed when there's a problem, rather than doing manual checks every day for the previous night's backups. -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); - end returned message - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup and recovery scenarios
Prem - I haven't found anything significant online. Perhaps someone else (Bwill point to a resource. If you want to learn RMAN, my recommendation is to (Bget a couple of books. The advantage of a book is you end up with a (Bcomprehensive resource for reference. Myself, I need to go back and refresh (Bmyself now and then. (B - Oracle9i RMAN Backup Recovery by Robert Freeman (B - I found Oracle 101 Backup Recovery (Smith and Haisley) helpful to get (Bstarted. About half of it is RMAN. It has very simple tutorials that you can (Bfollow step-by-step to understand the basic RMAN concepts. But Robert's book (Bwasn't published when I was trying to set up RMAN. (B (BDennis Williams (BDBA, 80%OCP, 100% DBA (BLifetouch, Inc. (B[EMAIL PROTECTED] (B (B (B-Original Message- (BSent: Thursday, September 04, 2003 1:44 AM (BTo: Multiple recipients of list ORACLE-L (B (B (BHi all, (B (BIs there any doc./URL which lists out RMAN backup and recovery scenarios ? (Bdid not find one in metalink. (B (BThanks Regards, (BJp. (B (B (B (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Prem Khanna J (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing). (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: DENNIS WILLIAMS (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing).
RE: RMAN backup and recovery scenarios
Look at the Backup and Recovery Doc's. And there are sample scripts in OH/rdbms/demo/case1.rcv thru case4.rcv. The backup and recovery manual is a great resource! HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Prem Khanna J Sent: Thursday, September 04, 2003 2:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup and recovery scenarios Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup and recovery scenarios
My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter devoted to case studies and RMAN. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/4/2003 11:44 AM Look at the Backup and Recovery Doc's. And there are sample scripts in OH/rdbms/demo/case1.rcv thru case4.rcv. The backup and recovery manual is a great resource! HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Prem Khanna J Sent: Thursday, September 04, 2003 2:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup and recovery scenarios Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup and recovery scenarios
Besides you may refer to Backup Recovery by Rama Velpuri (8/8i). A bit old but nevertheless good. All said and done, create a clone database and keep crashing it in all ways you can think of, and try to recover it. That should give you the confidence , letting you know how oracle handles the internals etc. Go thru Recovery principles, Case Studies by Rama Velpuri. (Add RF's book too). Try doing the same with Standby too. HTH GovindanK My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter devoted to case studies and RMAN. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 9/4/2003 11:44 AM Look at the Backup and Recovery Doc's. And there are sample scripts in OH/rdbms/demo/case1.rcv thru case4.rcv. The backup and recovery manual is a great resource! HTH, Ruth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Prem Khanna J Sent: Thursday, September 04, 2003 2:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup and recovery scenarios Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: GovindanK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RE: RMAN backup and recovery scenarios
Thanx Dennis,Robert,and Ruth. I'm going thro' Roberts's book now. as Robert said, it has a dedicated chapter for that. ...and i'm trying all the scenarios one by one . but just thought, i could some more inputs from you Gurus. thanx a lot guys. I will continue with the book. Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RMAN backup and recovery scenarios
Hi all, Is there any doc./URL which lists out RMAN backup and recovery scenarios ? did not find one in metalink. Thanks Regards, Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RMAN Backup piece being placed in wrong directory
Title: Message OS: Win2K DB: 8.1.7.4 All, Here is what I am running: run{set archivelog destination to 'D:\backup\oracle\Hotbackup';set controlfile autobackup format for device type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak';backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog;} Here is a the result after I run it: (The part I'm concerned about is in red. I would like that stuff to go to 'D:\backup\oracle\Hotbackup'). executing command: SET ARCHIVELOG DESTINATION executing command: SET CONTROLFILE AUTOBACKUP FORMAT Starting backup at 07-AUG-03current log archivedusing channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=4 recid=2 stamp=500738572channel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_2: starting archive log backupsetchannel ORA_DISK_2: specifying archive log(s) in backup setinput archive log thread=1 sequence=5 recid=1 stamp=500738568input archive log thread=1 sequence=6 recid=3 stamp=500738573input archive log thread=1 sequence=7 recid=4 stamp=500738574input archive log thread=1 sequence=8 recid=5 stamp=500815654input archive log thread=1 sequence=9 recid=6 stamp=500824391input archive log thread=1 sequence=10 recid=7 stamp=501340112channel ORA_DISK_2: starting piece 1 at 07-AUG-03channel ORA_DISK_3: starting archive log backupsetchannel ORA_DISK_3: specifying archive log(s) in backup setinput archive log thread=1 sequence=11 recid=8 stamp=501343673input archive log thread=1 sequence=12 recid=9 stamp=501343804input archive log thread=1 sequence=13 recid=10 stamp=501347437input archive log thread=1 sequence=14 recid=11 stamp=501347562input archive log thread=1 sequence=15 recid=12 stamp=501407160input archive log thread=1 sequence=16 recid=13 stamp=501407288channel ORA_DISK_3: starting piece 1 at 07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:16channel ORA_DISK_3: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 comment=NONEchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:16channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=17 recid=14 stamp=501407709input archive log thread=1 sequence=18 recid=15 stamp=501407832input archive log thread=1 sequence=19 recid=16 stamp=501407991channel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_2: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:20Finished backup at 07-AUG-03 Starting backup at 07-AUG-03using channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=2 name=D:\ORACLE\EWFMS\UNDOTBS01.DBFinput datafile fno=00010 name=D:\ORACLE\EWFMS\TCS_INDEXES01.DBFinput datafile fno=00011 name=D:\ORACLE\EWFMS\NOTF_DATA.DBFinput datafile fno=3 name=D:\ORACLE\EWFMS\CWMLITE01.DBFchannel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_2: starting full datafile backupsetchannel ORA_DISK_2: specifying datafile(s) in backupsetinput datafile fno=8 name=D:\ORACLE\EWFMS\XDB01.DBFinput datafile fno=00012 name=D:\ORACLE\EWFMS\NOTF_INDX.DBFinput datafile fno=9 name=D:\ORACLE\EWFMS\TCS_DATA01.DBFinput datafile fno=6 name=D:\ORACLE\EWFMS\TOOLS01.DBFchannel ORA_DISK_2: starting piece 1 at 07-AUG-03channel ORA_DISK_3: starting full datafile backupsetchannel ORA_DISK_3: specifying datafile(s) in backupsetinput datafile fno=1 name=D:\ORACLE\EWFMS\SYSTEM01.DBFinput datafile fno=4 name=D:\ORACLE\EWFMS\DRSYS01.DBFinput datafile fno=5 name=D:\ORACLE\EWFMS\INDX01.DBFinput datafile fno=7 name=D:\ORACLE\EWFMS\USERS01.DBFchannel ORA_DISK_3: starting piece 1 at 07-AUG-03channel ORA_DISK_2: finished piece 1 at 07-AUG-03piece handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1FEU5O8D_1_1.BAK comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:46channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1EEU5O8D_1_1.BAK comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:41channel ORA_DISK_3: finished piece 1 at 07-AUG-03piece handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1GEU5O8D_1_1.BAK comment=NONEchannel ORA_DISK_3: backup set
RE: RMAN Backup piece being placed in wrong directory
Good point Tom RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/7/2003 1:29 PM Ronald, It looks like just the archivelog was not going into the correct directory, right? But then you did *not* include a format clause for the archivelog. Looking at the docs, it looks like you should change the following: backup database format 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; to backup database format 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog format 'D:\backup\oracle\Hotbackup\arcs_d%d_t%t_U%U.bak' Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 1:15 PM To: Multiple recipients of list ORACLE-L Robert? Dennis? Anyone? -Original Message- Sent: Thursday, August 07, 2003 9:24 AM To: Multiple recipients of list ORACLE-L OS: Win2K DB: 8.1.7.4 All, Here is what I am running: run{ set archivelog destination to 'D:\backup\oracle\Hotbackup'; set controlfile autobackup format for device type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak'; backup database format 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; } Here is a the result after I run it: (The part I'm concerned about is in red. I would like that stuff to go to 'D:\backup\oracle\Hotbackup'). executing command: SET ARCHIVELOG DESTINATION executing command: SET CONTROLFILE AUTOBACKUP FORMAT Starting backup at 07-AUG-03 current log archived using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=4 recid=2 stamp=500738572 channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_2: starting archive log backupset channel ORA_DISK_2: specifying archive log(s) in backup set input archive log thread=1 sequence=5 recid=1 stamp=500738568 input archive log thread=1 sequence=6 recid=3 stamp=500738573 input archive log thread=1 sequence=7 recid=4 stamp=500738574 input archive log thread=1 sequence=8 recid=5 stamp=500815654 input archive log thread=1 sequence=9 recid=6 stamp=500824391 input archive log thread=1 sequence=10 recid=7 stamp=501340112 channel ORA_DISK_2: starting piece 1 at 07-AUG-03 channel ORA_DISK_3: starting archive log backupset channel ORA_DISK_3: specifying archive log(s) in backup set input archive log thread=1 sequence=11 recid=8 stamp=501343673 input archive log thread=1 sequence=12 recid=9 stamp=501343804 input archive log thread=1 sequence=13 recid=10 stamp=501347437 input archive log thread=1 sequence=14 recid=11 stamp=501347562 input archive log thread=1 sequence=15 recid=12 stamp=501407160 input archive log thread=1 sequence=16 recid=13 stamp=501407288 channel ORA_DISK_3: starting piece 1 at 07-AUG-03 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16 channel ORA_DISK_3: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:16 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=17 recid=14 stamp=501407709 input archive log thread=1 sequence=18 recid=15 stamp=501407832 input archive log thread=1 sequence=19 recid=16 stamp=501407991 channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 channel ORA_DISK_2: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:20 Finished backup at 07-AUG-03 Starting backup at 07-AUG-03 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=2 name=D:\ORACLE\EWFMS\UNDOTBS01.DBF input datafile fno=00010 name=D:\ORACLE\EWFMS\TCS_INDEXES01.DBF input datafile fno=00011 name=D:\ORACLE\EWFMS\NOTF_DATA.DBF input datafile fno=3 name=D:\ORACLE\EWFMS\CWMLITE01.DBF channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_2: starting full datafile backupset channel ORA_DISK_2: specifying datafile(s) in backupset input datafile fno=8 name=D:\ORACLE\EWFMS\XDB01.DBF input datafile fno=00012 name=D:\ORACLE\EWFMS\NOTF_INDX.DBF input datafile fno=9 name=D:\ORACLE\EWFMS\TCS_DATA01.DBF input datafile fno=6 name=D:\ORACLE\EWFMS\TOOLS01.DBF channel ORA_DISK_2: starting piece 1 at 07-AUG-03 channel ORA_DISK_3: starting full datafile backupset
RE: RMAN Backup piece being placed in wrong directory
Syntax error: backup database format = 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; add the = after the format and it should run. RMAN is trying to help you by ignoring this error and proceeding to backup the database to the default location. RF -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/7/2003 12:14 PM Robert? Dennis? Anyone? -Original Message- Sent: Thursday, August 07, 2003 9:24 AM To: Multiple recipients of list ORACLE-L OS: Win2K DB: 8.1.7.4 All, Here is what I am running: run{ set archivelog destination to 'D:\backup\oracle\Hotbackup'; set controlfile autobackup format for device type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak'; backup database format 'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; } Here is a the result after I run it: (The part I'm concerned about is in red. I would like that stuff to go to 'D:\backup\oracle\Hotbackup'). executing command: SET ARCHIVELOG DESTINATION executing command: SET CONTROLFILE AUTOBACKUP FORMAT Starting backup at 07-AUG-03 current log archived using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=4 recid=2 stamp=500738572 channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_2: starting archive log backupset channel ORA_DISK_2: specifying archive log(s) in backup set input archive log thread=1 sequence=5 recid=1 stamp=500738568 input archive log thread=1 sequence=6 recid=3 stamp=500738573 input archive log thread=1 sequence=7 recid=4 stamp=500738574 input archive log thread=1 sequence=8 recid=5 stamp=500815654 input archive log thread=1 sequence=9 recid=6 stamp=500824391 input archive log thread=1 sequence=10 recid=7 stamp=501340112 channel ORA_DISK_2: starting piece 1 at 07-AUG-03 channel ORA_DISK_3: starting archive log backupset channel ORA_DISK_3: specifying archive log(s) in backup set input archive log thread=1 sequence=11 recid=8 stamp=501343673 input archive log thread=1 sequence=12 recid=9 stamp=501343804 input archive log thread=1 sequence=13 recid=10 stamp=501347437 input archive log thread=1 sequence=14 recid=11 stamp=501347562 input archive log thread=1 sequence=15 recid=12 stamp=501407160 input archive log thread=1 sequence=16 recid=13 stamp=501407288 channel ORA_DISK_3: starting piece 1 at 07-AUG-03 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:16 channel ORA_DISK_3: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 comment=NONE channel ORA_DISK_3: backup set complete, elapsed time: 00:00:16 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=17 recid=14 stamp=501407709 input archive log thread=1 sequence=18 recid=15 stamp=501407832 input archive log thread=1 sequence=19 recid=16 stamp=501407991 channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_1: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 channel ORA_DISK_2: finished piece 1 at 07-AUG-03 piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 comment=NONE channel ORA_DISK_2: backup set complete, elapsed time: 00:00:20 Finished backup at 07-AUG-03 Starting backup at 07-AUG-03 using channel ORA_DISK_1 using channel ORA_DISK_2 using channel ORA_DISK_3 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=2 name=D:\ORACLE\EWFMS\UNDOTBS01.DBF input datafile fno=00010 name=D:\ORACLE\EWFMS\TCS_INDEXES01.DBF input datafile fno=00011 name=D:\ORACLE\EWFMS\NOTF_DATA.DBF input datafile fno=3 name=D:\ORACLE\EWFMS\CWMLITE01.DBF channel ORA_DISK_1: starting piece 1 at 07-AUG-03 channel ORA_DISK_2: starting full datafile backupset channel ORA_DISK_2: specifying datafile(s) in backupset input datafile fno=8 name=D:\ORACLE\EWFMS\XDB01.DBF input datafile fno=00012 name=D:\ORACLE\EWFMS\NOTF_INDX.DBF input datafile fno=9 name=D:\ORACLE\EWFMS\TCS_DATA01.DBF input datafile fno=6 name=D:\ORACLE\EWFMS\TOOLS01.DBF channel ORA_DISK_2: starting piece 1 at 07-AUG-03 channel ORA_DISK_3: starting full datafile backupset channel ORA_DISK_3: specifying datafile(s) in backupset input datafile fno=1 name=D:\ORACLE\EWFMS\SYSTEM01.DBF input datafile fno=4 name=D:\ORACLE\EWFMS\DRSYS01.DBF input datafile fno=5 name=D:\ORACLE\EWFMS\INDX01.DBF input datafile fno=7 name=D:\ORACLE\EWFMS\USERS01.DBF channel ORA_DISK_3: starting piece 1 at 07-AUG-03 channel ORA_DISK_2: finished piece 1 at 07-AUG-03 piece
FW: RMAN Backup piece being placed in wrong directory
Title: Message Robert? Dennis? Anyone? -Original Message-From: Stefick Ronald S Contr ESC/HRIDD Sent: Thursday, August 07, 2003 9:24 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN Backup piece being placed in wrong directory OS: Win2K DB: 8.1.7.4 All, Here is what I am running: run{set archivelog destination to 'D:\backup\oracle\Hotbackup';set controlfile autobackup format for device type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak';backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog;} Here is a the result after I run it: (The part I'm concerned about is in red. I would like that stuff to go to 'D:\backup\oracle\Hotbackup'). executing command: SET ARCHIVELOG DESTINATION executing command: SET CONTROLFILE AUTOBACKUP FORMAT Starting backup at 07-AUG-03current log archivedusing channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=4 recid=2 stamp=500738572channel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_2: starting archive log backupsetchannel ORA_DISK_2: specifying archive log(s) in backup setinput archive log thread=1 sequence=5 recid=1 stamp=500738568input archive log thread=1 sequence=6 recid=3 stamp=500738573input archive log thread=1 sequence=7 recid=4 stamp=500738574input archive log thread=1 sequence=8 recid=5 stamp=500815654input archive log thread=1 sequence=9 recid=6 stamp=500824391input archive log thread=1 sequence=10 recid=7 stamp=501340112channel ORA_DISK_2: starting piece 1 at 07-AUG-03channel ORA_DISK_3: starting archive log backupsetchannel ORA_DISK_3: specifying archive log(s) in backup setinput archive log thread=1 sequence=11 recid=8 stamp=501343673input archive log thread=1 sequence=12 recid=9 stamp=501343804input archive log thread=1 sequence=13 recid=10 stamp=501347437input archive log thread=1 sequence=14 recid=11 stamp=501347562input archive log thread=1 sequence=15 recid=12 stamp=501407160input archive log thread=1 sequence=16 recid=13 stamp=501407288channel ORA_DISK_3: starting piece 1 at 07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:16channel ORA_DISK_3: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 comment=NONEchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:16channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=17 recid=14 stamp=501407709input archive log thread=1 sequence=18 recid=15 stamp=501407832input archive log thread=1 sequence=19 recid=16 stamp=501407991channel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_2: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:20Finished backup at 07-AUG-03 Starting backup at 07-AUG-03using channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=2 name=D:\ORACLE\EWFMS\UNDOTBS01.DBFinput datafile fno=00010 name=D:\ORACLE\EWFMS\TCS_INDEXES01.DBFinput datafile fno=00011 name=D:\ORACLE\EWFMS\NOTF_DATA.DBFinput datafile fno=3 name=D:\ORACLE\EWFMS\CWMLITE01.DBFchannel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_2: starting full datafile backupsetchannel ORA_DISK_2: specifying datafile(s) in backupsetinput datafile fno=8 name=D:\ORACLE\EWFMS\XDB01.DBFinput datafile fno=00012 name=D:\ORACLE\EWFMS\NOTF_INDX.DBFinput datafile fno=9 name=D:\ORACLE\EWFMS\TCS_DATA01.DBFinput datafile fno=6 name=D:\ORACLE\EWFMS\TOOLS01.DBFchannel ORA_DISK_2: starting piece 1 at 07-AUG-03channel ORA_DISK_3: starting full datafile backupsetchannel ORA_DISK_3: specifying datafile(s) in backupsetinput datafile fno=1 name=D:\ORACLE\EWFMS\SYSTEM01.DBFinput datafile fno=4 name=D:\ORACLE\EWFMS\DRSYS01.DBFinput datafile fno=5 name=D:\ORACLE\EWFMS\INDX01.DBFinput datafile fno=7 name=D:\ORACLE\EWFMS\USERS01.DBFchannel ORA_DISK_3: starting piece 1 at 07-AUG-03channel ORA_DISK_2: finished piece 1 at 07-AUG-03piece handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1FEU5O8D_1_1.BAK comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:46channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=D:\BACKUP\ORACLE\HOTBACKUP\RMAN_DEWFMS_T501408013_U1EEU5O8D_1_1.BAK comment=NONEchannel
RE: RMAN Backup piece being placed in wrong directory
Title: Message Doh! Thanks for pointing out the obvious to me. I'm sure that will work. I'll go crawl back in my cave now :ol Thanks Tom! -Scott Stefick -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, August 07, 2003 1:29 PMTo: Multiple recipients of list ORACLE-LSubject: RE: RMAN Backup piece being placed in wrong directory Ronald, It looks like just the archivelog was not going into the correct directory, right? But then you did *not* include a format clause for the archivelog. Looking at the docs, it looks like you should change the following: backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; to backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog format 'D:\backup\oracle\Hotbackup\arcs_d%d_t%t_U%U.bak' Good Luck! Tom Mercadante Oracle Certified Professional -Original Message-From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 1:15 PMTo: Multiple recipients of list ORACLE-LSubject: FW: RMAN Backup piece being placed in wrong directory Robert? Dennis? Anyone? -Original Message-From: Stefick Ronald S Contr ESC/HRIDD Sent: Thursday, August 07, 2003 9:24 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN Backup piece being placed in wrong directory OS: Win2K DB: 8.1.7.4 All, Here is what I am running: run{set archivelog destination to 'D:\backup\oracle\Hotbackup';set controlfile autobackup format for device type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak';backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog;} Here is a the result after I run it: (The part I'm concerned about is in red. I would like that stuff to go to 'D:\backup\oracle\Hotbackup'). executing command: SET ARCHIVELOG DESTINATION executing command: SET CONTROLFILE AUTOBACKUP FORMAT Starting backup at 07-AUG-03current log archivedusing channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=4 recid=2 stamp=500738572channel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_2: starting archive log backupsetchannel ORA_DISK_2: specifying archive log(s) in backup setinput archive log thread=1 sequence=5 recid=1 stamp=500738568input archive log thread=1 sequence=6 recid=3 stamp=500738573input archive log thread=1 sequence=7 recid=4 stamp=500738574input archive log thread=1 sequence=8 recid=5 stamp=500815654input archive log thread=1 sequence=9 recid=6 stamp=500824391input archive log thread=1 sequence=10 recid=7 stamp=501340112channel ORA_DISK_2: starting piece 1 at 07-AUG-03channel ORA_DISK_3: starting archive log backupsetchannel ORA_DISK_3: specifying archive log(s) in backup setinput archive log thread=1 sequence=11 recid=8 stamp=501343673input archive log thread=1 sequence=12 recid=9 stamp=501343804input archive log thread=1 sequence=13 recid=10 stamp=501347437input archive log thread=1 sequence=14 recid=11 stamp=501347562input archive log thread=1 sequence=15 recid=12 stamp=501407160input archive log thread=1 sequence=16 recid=13 stamp=501407288channel ORA_DISK_3: starting piece 1 at 07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:16channel ORA_DISK_3: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 comment=NONEchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:16channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=17 recid=14 stamp=501407709input archive log thread=1 sequence=18 recid=15 stamp=501407832input archive log thread=1 sequence=19 recid=16 stamp=501407991channel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_2: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:20Finished backup at 07-AUG-03 Starting backup at 07-AUG-03using channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting full datafile
RE: RMAN Backup piece being placed in wrong directory
Title: Message Ronald, It looks like just the archivelog was not going into the correct directory, right? But then you did *not* include a format clause for the archivelog. Looking at the docs, it looks like you should change the following: backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog; to backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog format 'D:\backup\oracle\Hotbackup\arcs_d%d_t%t_U%U.bak' Good Luck! Tom Mercadante Oracle Certified Professional -Original Message-From: Stefick Ronald S Contr ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 1:15 PMTo: Multiple recipients of list ORACLE-LSubject: FW: RMAN Backup piece being placed in wrong directory Robert? Dennis? Anyone? -Original Message-From: Stefick Ronald S Contr ESC/HRIDD Sent: Thursday, August 07, 2003 9:24 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN Backup piece being placed in wrong directory OS: Win2K DB: 8.1.7.4 All, Here is what I am running: run{set archivelog destination to 'D:\backup\oracle\Hotbackup';set controlfile autobackup format for device type disk to 'D:\backup\oracle\Hotbackup\cf_%F.bak';backup database format'D:\backup\oracle\Hotbackup\rman_d%d_t%t_U%U.bak' plus archivelog;} Here is a the result after I run it: (The part I'm concerned about is in red. I would like that stuff to go to 'D:\backup\oracle\Hotbackup'). executing command: SET ARCHIVELOG DESTINATION executing command: SET CONTROLFILE AUTOBACKUP FORMAT Starting backup at 07-AUG-03current log archivedusing channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=4 recid=2 stamp=500738572channel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_2: starting archive log backupsetchannel ORA_DISK_2: specifying archive log(s) in backup setinput archive log thread=1 sequence=5 recid=1 stamp=500738568input archive log thread=1 sequence=6 recid=3 stamp=500738573input archive log thread=1 sequence=7 recid=4 stamp=500738574input archive log thread=1 sequence=8 recid=5 stamp=500815654input archive log thread=1 sequence=9 recid=6 stamp=500824391input archive log thread=1 sequence=10 recid=7 stamp=501340112channel ORA_DISK_2: starting piece 1 at 07-AUG-03channel ORA_DISK_3: starting archive log backupsetchannel ORA_DISK_3: specifying archive log(s) in backup setinput archive log thread=1 sequence=11 recid=8 stamp=501343673input archive log thread=1 sequence=12 recid=9 stamp=501343804input archive log thread=1 sequence=13 recid=10 stamp=501347437input archive log thread=1 sequence=14 recid=11 stamp=501347562input archive log thread=1 sequence=15 recid=12 stamp=501407160input archive log thread=1 sequence=16 recid=13 stamp=501407288channel ORA_DISK_3: starting piece 1 at 07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1AEU5O7O_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:16channel ORA_DISK_3: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1CEU5O7O_1_1 comment=NONEchannel ORA_DISK_3: backup set complete, elapsed time: 00:00:16channel ORA_DISK_1: starting archive log backupsetchannel ORA_DISK_1: specifying archive log(s) in backup setinput archive log thread=1 sequence=17 recid=14 stamp=501407709input archive log thread=1 sequence=18 recid=15 stamp=501407832input archive log thread=1 sequence=19 recid=16 stamp=501407991channel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_1: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1DEU5O89_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:02channel ORA_DISK_2: finished piece 1 at 07-AUG-03piece handle=C:\ORACLE\ORACLE\9.2.0\DATABASE\1BEU5O7O_1_1 comment=NONEchannel ORA_DISK_2: backup set complete, elapsed time: 00:00:20Finished backup at 07-AUG-03 Starting backup at 07-AUG-03using channel ORA_DISK_1using channel ORA_DISK_2using channel ORA_DISK_3channel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetinput datafile fno=2 name=D:\ORACLE\EWFMS\UNDOTBS01.DBFinput datafile fno=00010 name=D:\ORACLE\EWFMS\TCS_INDEXES01.DBFinput datafile fno=00011 name=D:\ORACLE\EWFMS\NOTF_DATA.DBFinput datafile fno=3 name=D:\ORACLE\EWFMS\CWMLITE01.DBFchannel ORA_DISK_1: starting piece 1 at 07-AUG-03channel ORA_DISK_2: starting full datafile backupsetchannel ORA_DISK_2: specifying datafile(s) in backupsetinput datafile fno=8 name=D:\ORACLE\EWFMS\XDB01.DBFinput datafile fno=00012
RMAN backup with MULTIPLE CHANNELS ......
Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup with MULTIPLE CHANNELS ......
Babu - We allocated multiple channels on an RMAN disk backup and the backup time was reduced. I would suggest you try to figure out where your bottleneck is. Are you writing to multiple tapes? Actually, RMAN has several features to keep the tape streaming, you may want to look at these. If your tape isn't streaming, you might get more throughput from a single tape drive than you are now. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 20, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup with MULTIPLE CHANNELS ......
Dennis, Thanks for your reply. Iam taking tape backup with 3 channels as we have multiple tape drives. I don't know where the bottleneck is. In the RMAN output I see it is using all the three channels simultaneously with 10 datafiles per channel. But Iam not getting the throuput. It is taking the same amount of time as it used to take for single channel. I don't know where to look, and don't know how to fix the problem and take advantage of multiple channels. -- Babu -Original Message- Sent: Thursday, February 20, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Babu - We allocated multiple channels on an RMAN disk backup and the backup time was reduced. I would suggest you try to figure out where your bottleneck is. Are you writing to multiple tapes? Actually, RMAN has several features to keep the tape streaming, you may want to look at these. If your tape isn't streaming, you might get more throughput from a single tape drive than you are now. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 20, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup with MULTIPLE CHANNELS ......
One possibility is that the backup job is already maxing out the network connection between the client system and the Veritas NetBackup master server and/or media server. If you have a 10megabit network and LTO drives, the network will never be able to keep the tapes streaming. Adding 3 channels won't help if your network can't keep up. I'm speculating here, as you don't really supply enough info about your environment. Jared Janardhana Babu Donga [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/20/2003 10:47 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN backup with MULTIPLE CHANNELS .. Dennis, Thanks for your reply. Iam taking tape backup with 3 channels as we have multiple tape drives. I don't know where the bottleneck is. In the RMAN output I see it is using all the three channels simultaneously with 10 datafiles per channel. But Iam not getting the throuput. It is taking the same amount of time as it used to take for single channel. I don't know where to look, and don't know how to fix the problem and take advantage of multiple channels. -- Babu -Original Message- Sent: Thursday, February 20, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Babu - We allocated multiple channels on an RMAN disk backup and the backup time was reduced. I would suggest you try to figure out where your bottleneck is. Are you writing to multiple tapes? Actually, RMAN has several features to keep the tape streaming, you may want to look at these. If your tape isn't streaming, you might get more throughput from a single tape drive than you are now. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 20, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup with MULTIPLE CHANNELS ......
Jared, Please let me know what info you need. I would collect it from my Netbackup administrator and let you know. Thanks, -- Babu -Original Message- Sent: Thursday, February 20, 2003 1:02 PM To: Multiple recipients of list ORACLE-L One possibility is that the backup job is already maxing out the network connection between the client system and the Veritas NetBackup master server and/or media server. If you have a 10megabit network and LTO drives, the network will never be able to keep the tapes streaming. Adding 3 channels won't help if your network can't keep up. I'm speculating here, as you don't really supply enough info about your environment. Jared Janardhana Babu Donga [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/20/2003 10:47 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN backup with MULTIPLE CHANNELS .. Dennis, Thanks for your reply. Iam taking tape backup with 3 channels as we have multiple tape drives. I don't know where the bottleneck is. In the RMAN output I see it is using all the three channels simultaneously with 10 datafiles per channel. But Iam not getting the throuput. It is taking the same amount of time as it used to take for single channel. I don't know where to look, and don't know how to fix the problem and take advantage of multiple channels. -- Babu -Original Message- Sent: Thursday, February 20, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Babu - We allocated multiple channels on an RMAN disk backup and the backup time was reduced. I would suggest you try to figure out where your bottleneck is. Are you writing to multiple tapes? Actually, RMAN has several features to keep the tape streaming, you may want to look at these. If your tape isn't streaming, you might get more throughput from a single tape drive than you are now. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 20, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
RE: RMAN backup with MULTIPLE CHANNELS ......
Look for something like channels-per-tapedrive on the backup server configuration. You have to be above this figure to use multiple tape drives. [EMAIL PROTECTED] 02/21/03 07:47a.m. Dennis, Thanks for your reply. Iam taking tape backup with 3 channels as we have multiple tape drives. I don't know where the bottleneck is. In the RMAN output I see it is using all the three channels simultaneously with 10 datafiles per channel. But Iam not getting the throuput. It is taking the same amount of time as it used to take for single channel. I don't know where to look, and don't know how to fix the problem and take advantage of multiple channels. -- Babu -Original Message- Sent: Thursday, February 20, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Babu - We allocated multiple channels on an RMAN disk backup and the backup time was reduced. I would suggest you try to figure out where your bottleneck is. Are you writing to multiple tapes? Actually, RMAN has several features to keep the tape streaming, you may want to look at these. If your tape isn't streaming, you might get more throughput from a single tape drive than you are now. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 20, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup with MULTIPLE CHANNELS ......
also check Maximum Jobs per client. you will find this setting in the Netbackup preferences window (Netbackup Java console). -Mandar -Original Message- From: Janardhana Babu Donga [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 8:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup with MULTIPLE CHANNELS .. Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup with MULTIPLE CHANNELS ......
Just be sure and post it to the list. There are folks here with more NBU/RMAN experience than I. Network between database server, master server and media server. 10Megabit, 100 Megabit, Gigabit? Concurrent backup jobs? # of Tape drives dedicated to this backup? Type of drive? LTO, DLT, Super DLT? This question is better phrased as: What is the streaming capacity of the drives involved in the backup? There are more questions, but this is a start. Jared Janardhana Babu Donga [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/20/2003 02:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN backup with MULTIPLE CHANNELS .. Jared, Please let me know what info you need. I would collect it from my Netbackup administrator and let you know. Thanks, -- Babu -Original Message- Sent: Thursday, February 20, 2003 1:02 PM To: Multiple recipients of list ORACLE-L One possibility is that the backup job is already maxing out the network connection between the client system and the Veritas NetBackup master server and/or media server. If you have a 10megabit network and LTO drives, the network will never be able to keep the tapes streaming. Adding 3 channels won't help if your network can't keep up. I'm speculating here, as you don't really supply enough info about your environment. Jared Janardhana Babu Donga [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 02/20/2003 10:47 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN backup with MULTIPLE CHANNELS .. Dennis, Thanks for your reply. Iam taking tape backup with 3 channels as we have multiple tape drives. I don't know where the bottleneck is. In the RMAN output I see it is using all the three channels simultaneously with 10 datafiles per channel. But Iam not getting the throuput. It is taking the same amount of time as it used to take for single channel. I don't know where to look, and don't know how to fix the problem and take advantage of multiple channels. -- Babu -Original Message- Sent: Thursday, February 20, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Babu - We allocated multiple channels on an RMAN disk backup and the backup time was reduced. I would suggest you try to figure out where your bottleneck is. Are you writing to multiple tapes? Actually, RMAN has several features to keep the tape streaming, you may want to look at these. If your tape isn't streaming, you might get more throughput from a single tape drive than you are now. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 20, 2003 10:44 AM To: Multiple recipients of list ORACLE-L Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send
RE: RMAN backup with MULTIPLE CHANNELS ......
Mandar, Thanks for your reply. Iam in the process of checking with my Netbackup Administrator about the parameter: Max_jobs_per_client. After seeing your E-Mail, I too looked into the online manual and it seems the value should be = Number of streams X No.Of Classes. In my case No.Of classes equals to 1, and since I would like to use 3 tape drives thru 3 channels, I think Max_Jobs_per_client must be set to 3. I forwarded the info to my Netbackup Admin. Thanks for the info. -- Babu -Original Message- Sent: Thursday, February 20, 2003 2:52 PM To: Multiple recipients of list ORACLE-L also check Maximum Jobs per client. you will find this setting in the Netbackup preferences window (Netbackup Java console). -Mandar -Original Message- From: Janardhana Babu Donga [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 20, 2003 8:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup with MULTIPLE CHANNELS .. Dear List, I have changed my RMAN backup script to use multiple channels(3) as we have plenty of tape drives. It is taking the same amount of time as it used to with single channel. The DB size is 120gig. The output indicates it is using three channels while backing up. Anyone has any idea why the multiple channels not reduced the backup time. Iam using Veritas Netbackup. Thanks in advance for any help. -- Babu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Janardhana Babu Donga INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RMAN backup/restore to disk on 600G - terabyte Databases?? SPEED?
Hi, I looking at implementing RMAN backup and recovery to disk (fast disk) on a high avail. system...so recovery time is crucial.. Anybody know how fast I might restore a full backup of a 600gig to a Terabyte database. The machine probably will have 10+ cpus HP machine and EMC disk although the backups will probably sit on a fast SAN. There will be 12Gig of fast memory... 200,000 users...max 10,000 concurrent, 100MB io card. IF anyone has done it...what speeds could you obtain with RMAN from Disk? What were the best SPEED enhancing factors?? ( I know cpus, mult-channels, and memory, disk ban widths anymore?) Thanks, Brian Spears -Original Message- Sent: Thursday, January 30, 2003 10:09 AM To: Multiple recipients of list ORACLE-L OK, that's it. My mountain bike is coming out TODAY. I don't care if it's 10F out. There's no snow, so it won't be as fun, but that's alright. And, Lisa, in '99 I pedalled 450 miles from Superior to Madison, WI in a week. I admit that I spent some time in Rehab afterwards for rough cartilage (I was BORN geeky, too!), but it was a blast nonetheless. Hm...maybe I'd better set my arse on the stationary bike for a few weeks first before taking on the trails. Now I'm depressed. Thank God it's Beer Day! http://society.servebeer.com :) Now back to your regularly schedule database problems... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 5:15 PM To: Multiple recipients of list ORACLE-L Hey, I'm calling it a day, and heading to the beach now for a 10K run since it is the high 70s where I work likely around 70 on the beach. Point your browser at www.camzone.com and click the on the Del Mar Beach Cam link. I'll wave as I go buy in about 1 hour. HAND! Koivu, Lisa Lisa.Koivu@efairTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] field.com cc: Sent by: Subject: RE: Take Care of your DBAs [EMAIL PROTECTED] 01/29/2003 01:54 PM Please respond to ORACLE-L I used to play Ping Pong with the sysadmins and the app architect... aahh, the glory dotcom days when I could bring my dog to work :) Most of the dba's I have met are not into physical activity and exercise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Spears, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup/restore to disk on 600G - terabyte Databases?? SP
Title: RE: RMAN backup/restore to disk on 600G - terabyte Databases?? SPEED? Brian, If time is of the essence and you have EMC BCV's, look at Time Finder. I believe that's EMC's piece of software that allows you to sync and split a third mirror. That will be much faster for recovery than just about anything you can tweak. Have fun ! Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Spears, Brian [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 11:21 AM To: Multiple recipients of list ORACLE-L Subject: RMAN backup/restore to disk on 600G - terabyte Databases?? SPEED? Hi, I looking at implementing RMAN backup and recovery to disk (fast disk) on a high avail. system...so recovery time is crucial.. Anybody know how fast I might restore a full backup of a 600gig to a Terabyte database. The machine probably will have 10+ cpus HP machine and EMC disk although the backups will probably sit on a fast SAN. There will be 12Gig of fast memory... 200,000 users...max 10,000 concurrent, 100MB io card. IF anyone has done it...what speeds could you obtain with RMAN from Disk? What were the best SPEED enhancing factors?? ( I know cpus, mult-channels, and memory, disk ban widths anymore?) Thanks, Brian Spears -Original Message- Sent: Thursday, January 30, 2003 10:09 AM To: Multiple recipients of list ORACLE-L OK, that's it. My mountain bike is coming out TODAY. I don't care if it's 10F out. There's no snow, so it won't be as fun, but that's alright. And, Lisa, in '99 I pedalled 450 miles from Superior to Madison, WI in a week. I admit that I spent some time in Rehab afterwards for rough cartilage (I was BORN geeky, too!), but it was a blast nonetheless. Hm...maybe I'd better set my arse on the stationary bike for a few weeks first before taking on the trails. Now I'm depressed. Thank God it's Beer Day! http://society.servebeer.com :) Now back to your regularly schedule database problems... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 5:15 PM To: Multiple recipients of list ORACLE-L Hey, I'm calling it a day, and heading to the beach now for a 10K run since it is the high 70s where I work likely around 70 on the beach. Point your browser at www.camzone.com and click the on the Del Mar Beach Cam link. I'll wave as I go buy in about 1 hour. HAND! Koivu, Lisa Lisa.Koivu@efair To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] field.com cc: Sent by: Subject: RE: Take Care of your DBAs [EMAIL PROTECTED] 01/29/2003 01:54 PM Please respond to ORACLE-L I used to play Ping Pong with the sysadmins and the app architect... aahh, the glory dotcom days when I could bring my dog to work :) Most of the dba's I have met are not into physical activity and exercise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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.net -- Author: Spears, Brian INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: RMAN backup/restore to disk on 600G - terabyte Databases?? SP
Hi, I have used 12 channels to backup 700GB database and writing to FOUR TAPES at the same time. I used to backed up in 4 1/2 hours. On EMC disk, restore was done in 8 hours. allocate channel c1 type 'SBT_TAPE'; allocate channel c2 type 'SBT_TAPE'; allocate channel c3 type 'SBT_TAPE'; allocate channel c4 type 'SBT_TAPE'; allocate channel c5 type 'SBT_TAPE'; allocate channel c6 type 'SBT_TAPE'; allocate channel c7 type 'SBT_TAPE'; allocate channel c8 type 'SBT_TAPE'; allocate channel c9 type 'SBT_TAPE'; allocate channel c10 type 'SBT_TAPE'; allocate channel c11 type 'SBT_TAPE'; allocate channel c12 type 'SBT_TAPE'; setlimit channel c1 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c2 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c3 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c4 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c5 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c6 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c7 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c8 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c9 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c10 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c11 kbytes 2097150 maxopenfiles 16 readrate 500; setlimit channel c12 kbytes 2097150 maxopenfiles 16 readrate 500; Thanks Muqthar Ahmed DBA -Original Message- Sent: Thursday, January 30, 2003 11:21 AM To: Multiple recipients of list ORACLE-L SPEED? Hi, I looking at implementing RMAN backup and recovery to disk (fast disk) on a high avail. system...so recovery time is crucial.. Anybody know how fast I might restore a full backup of a 600gig to a Terabyte database. The machine probably will have 10+ cpus HP machine and EMC disk although the backups will probably sit on a fast SAN. There will be 12Gig of fast memory... 200,000 users...max 10,000 concurrent, 100MB io card. IF anyone has done it...what speeds could you obtain with RMAN from Disk? What were the best SPEED enhancing factors?? ( I know cpus, mult-channels, and memory, disk ban widths anymore?) Thanks, Brian Spears -Original Message- Sent: Thursday, January 30, 2003 10:09 AM To: Multiple recipients of list ORACLE-L OK, that's it. My mountain bike is coming out TODAY. I don't care if it's 10F out. There's no snow, so it won't be as fun, but that's alright. And, Lisa, in '99 I pedalled 450 miles from Superior to Madison, WI in a week. I admit that I spent some time in Rehab afterwards for rough cartilage (I was BORN geeky, too!), but it was a blast nonetheless. Hm...maybe I'd better set my arse on the stationary bike for a few weeks first before taking on the trails. Now I'm depressed. Thank God it's Beer Day! http://society.servebeer.com :) Now back to your regularly schedule database problems... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 5:15 PM To: Multiple recipients of list ORACLE-L Hey, I'm calling it a day, and heading to the beach now for a 10K run since it is the high 70s where I work likely around 70 on the beach. Point your browser at www.camzone.com and click the on the Del Mar Beach Cam link. I'll wave as I go buy in about 1 hour. HAND! Koivu, Lisa Lisa.Koivu@efairTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] field.com cc: Sent by: Subject: RE: Take Care of your DBAs [EMAIL PROTECTED] 01/29/2003 01:54 PM Please respond to ORACLE-L I used to play Ping Pong with the sysadmins and the app architect... aahh, the glory dotcom days when I could bring my dog to work :) Most of the dba's I have met are not into physical activity and exercise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself
RE: RMAN backup - basic Qs
I stand corrected. thanks Robert. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, January 16, 2003 3:20 PM To: Multiple recipients of list ORACLE-L RMAN does no compression on any blocks with data. The only compression that occurs that blocks above the HWM are not included. No compression of data occurs, and in fact empty blocks can and are backed up by RMAN. RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- Sent: Thursday, January 16, 2003 1:54 PM To: Multiple recipients of list ORACLE-L No. Because Rman is not placing the tablespaces in a HOT BACKUP mode. Rman is simply reading the blocks, compressing them, and writing them to tape. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, January 16, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup - basic Qs
Also, RMAN can do incremental backups, copying only the blocks that changed since last backup. More about all this in Oracle Manuals and in Robert's book. - Kirti -Original Message- Sent: Thursday, January 16, 2003 10:04 PM To: Multiple recipients of list ORACLE-L Maria - Definitely faster. Often hot backups can generate additional redo. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 16, 2003 9:24 PM To: Multiple recipients of list ORACLE-L does this make RMAN hot backups faster or slower than when backing up file in backup mode? [EMAIL PROTECTED] wrote: To better answer the original question, my understanding of this difference is as under: Why do you put the tablespace in backup mode during normal hot backups without RMAN? This is to avoid backing up split blocks. Say, you have a database with a block size of 16K. And that a block is in the process of being backed up, with reads happening in chunks of say, 512 bytes. Assume a user transaction updates this block while the backup is in progress. This could result in an inconsistent version of the block being backed up, or what is called as split blocks. Putting a tablespace in backup mode, is primarily, a flag which tells Oracle to copy the entire block into the redo stream, and not just the changed vectors or deltas, which it would have done otherwise. This is so that, in case of recovery, the entire block can be read from the redo stream, and applied. Hence, this results in an increase in the redo size during normal hot backups. RMAN however, does not place the tablespaces in hot backup mode. They use the same read consistency mechanism used by the SQL statements. Hence, no excessive redo is generated. Hope this helps. Raj Original Message- Sent: Thursday, January 16, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Rman uses the same construct to get the right data in a hot backup as sqlplus, the SCN of the database. It reduces excess redo because you don't have to put the datafile in backup mode with a begin backup and take it out with and end backup. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 12:35 PM Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RMAN backup - basic Qs
Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup - basic Qs
No. Because Rman is not placing the tablespaces in a HOT BACKUP mode. Rman is simply reading the blocks, compressing them, and writing them to tape. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, January 16, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup - basic Qs
Rman uses the same construct to get the right data in a hot backup as sqlplus, the SCN of the database. It reduces excess redo because you don't have to put the datafile in backup mode with a begin backup and take it out with and end backup. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 12:35 PM Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup - basic Qs
RMAN does no compression on any blocks with data. The only compression that occurs that blocks above the HWM are not included. No compression of data occurs, and in fact empty blocks can and are backed up by RMAN. RF Robert G. Freeman Technical Management Consultant TUSC - The Oracle Experts www.tusc.com 904.708.5076 Cell (it's everywhere that I am!) Author of several books you can find on Amazon.com! -Original Message- Sent: Thursday, January 16, 2003 1:54 PM To: Multiple recipients of list ORACLE-L No. Because Rman is not placing the tablespaces in a HOT BACKUP mode. Rman is simply reading the blocks, compressing them, and writing them to tape. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, January 16, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup - basic Qs
Title: RE: RMAN backup - basic Qs what happens when a 'snapshot too old' situation occurs??...how can RMAN produce a valid backup in that case? many i'm missing something. -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: RMAN backup - basic Qs Rman uses the same construct to get the right data in a hot backup as sqlplus, the SCN of the database. It reduces excess redo because you don't have to put the datafile in backup mode with a begin backup and take it out with and end backup. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 12:35 PM Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: RMAN backup - basic Qs
Maybe you could explain why you think ORA-1550 is related to backups? It isn't, but you have some misconception about it to clear up. Jared Chris Stephens [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/16/2003 01:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RMAN backup - basic Qs what happens when a 'snapshot too old' situation occurs??...how can RMAN produce a valid backup in that case? many i'm missing something. -Original Message- Sent: Thursday, January 16, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Rman uses the same construct to get the right data in a hot backup as sqlplus, the SCN of the database. It reduces excess redo because you don't have to put the datafile in backup mode with a begin backup and take it out with and end backup. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 12:35 PM Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup - basic Qs
To better answer the original question, my understanding of this difference is as under: Why do you put the tablespace in backup mode during normal hot backups without RMAN? This is to avoid backing up split blocks. Say, you have a database with a block size of 16K. And that a block is in the process of being backed up, with reads happening in chunks of say, 512 bytes. Assume a user transaction updates this block while the backup is in progress. This could result in an inconsistent version of the block being backed up, or what is called as split blocks. Putting a tablespace in backup mode, is primarily, a flag which tells Oracle to copy the entire block into the redo stream, and not just the changed vectors or deltas, which it would have done otherwise. This is so that, in case of recovery, the entire block can be read from the redo stream, and applied. Hence, this results in an increase in the redo size during normal hot backups. RMAN however, does not place the tablespaces in hot backup mode. They use the same read consistency mechanism used by the SQL statements. Hence, no excessive redo is generated. Hope this helps. Raj Original Message- Sent: Thursday, January 16, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Rman uses the same construct to get the right data in a hot backup as sqlplus, the SCN of the database. It reduces excess redo because you don't have to put the datafile in backup mode with a begin backup and take it out with and end backup. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 12:35 PM Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup - basic Qs
does this make RMAN hot backups faster or slower than when backing up file in backup mode? [EMAIL PROTECTED] wrote: To better answer the original question, my understanding of this difference is as under: Why do you put the tablespace in backup mode during normal hot backups without RMAN? This is to avoid backing up split blocks. Say, you have a database with a block size of 16K. And that a block is in the process of being backed up, with reads happening in chunks of say, 512 bytes. Assume a user transaction updates this block while the backup is in progress. This could result in an inconsistent version of the block being backed up, or what is called as split blocks. Putting a tablespace in backup mode, is primarily, a flag which tells Oracle to copy the entire block into the redo stream, and not just the changed vectors or deltas, which it would have done otherwise. This is so that, in case of recovery, the entire block can be read from the redo stream, and applied. Hence, this results in an increase in the redo size during normal hot backups. RMAN however, does not place the tablespaces in hot backup mode. They use the same read consistency mechanism used by the SQL statements. Hence, no excessive redo is generated. Hope this helps. Raj Original Message- Sent: Thursday, January 16, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Rman uses the same construct to get the right data in a hot backup as sqlplus, the SCN of the database. It reduces excess redo because you don't have to put the datafile in backup mode with a begin backup and take it out with and end backup. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 12:35 PM Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. If you don't risk anything, you risk even more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup - basic Qs
Maria - Definitely faster. Often hot backups can generate additional redo. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 16, 2003 9:24 PM To: Multiple recipients of list ORACLE-L does this make RMAN hot backups faster or slower than when backing up file in backup mode? [EMAIL PROTECTED] wrote: To better answer the original question, my understanding of this difference is as under: Why do you put the tablespace in backup mode during normal hot backups without RMAN? This is to avoid backing up split blocks. Say, you have a database with a block size of 16K. And that a block is in the process of being backed up, with reads happening in chunks of say, 512 bytes. Assume a user transaction updates this block while the backup is in progress. This could result in an inconsistent version of the block being backed up, or what is called as split blocks. Putting a tablespace in backup mode, is primarily, a flag which tells Oracle to copy the entire block into the redo stream, and not just the changed vectors or deltas, which it would have done otherwise. This is so that, in case of recovery, the entire block can be read from the redo stream, and applied. Hence, this results in an increase in the redo size during normal hot backups. RMAN however, does not place the tablespaces in hot backup mode. They use the same read consistency mechanism used by the SQL statements. Hence, no excessive redo is generated. Hope this helps. Raj Original Message- Sent: Thursday, January 16, 2003 1:54 PM To: Multiple recipients of list ORACLE-L Rman uses the same construct to get the right data in a hot backup as sqlplus, the SCN of the database. It reduces excess redo because you don't have to put the datafile in backup mode with a begin backup and take it out with and end backup. HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 16, 2003 12:35 PM Is Excessive Redo Generated during RMAN OPEN Database backup using backup sets as happens in case of HOT Backup ? If NOT , Why ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. If you don't risk anything, you risk even more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Restoring DB from specific RMAN backup set.
How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB IDCUR Reset SCN Reset Time --- --- --- -- -- 37 38 DB2 1600772452 NO 1 15-NOV-02 37 256 DB2 1600772452 NO 259591 23-NOV-02 37 627 DB2 1600772452 NO 792890 11-DEC-02 37 654 DB2 1600772452 NO 792890 11-DEC-02 37 712 DB2 1600772452 NO 792890 11-DEC-02 37 680 DB2 1600772452 NO 792890 11-DEC-02 37 764 DB2 1600772452 NO 823456 11-DEC-02 37 816 DB2 1600772452 YES 823456 18-DEC-02 37 893 DB2 1600772452 NO 823456 19-DEC-02 The backup summary list looks like: List of Backups === Key TY LV S Device Type Completion Time #Pieces #Copies Tag --- -- -- - --- --- --- --- --- 47 B F A DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-DEC-02 1 1 I've tried resetting the database to incarnation 816, but when I restore the control file and data files from that it is not what I think it should be. I end up with FULL_DB_INSTALLED. I can restore the control file I want from the auto backup file. How can I then tell RMAN to restore the data files associated with either backup set 791 (tag=WF_TESTING)? Thanks. -- Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Restoring DB from specific RMAN backup set.
As long as you haven't opened the database with resetlogs between the time of the backup you want and the present you can just restore it and recover, using backup controlfile, until cancel. If you have opened it with resetlogs, you will have to change the incarnation of the database, Consult the documentation and if that doesn't help, open a TAR,' HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 10:39 AM How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB IDCUR Reset SCN Reset Time --- --- --- -- -- 37 38 DB2 1600772452 NO 1 15-NOV-02 37 256 DB2 1600772452 NO 259591 23-NOV-02 37 627 DB2 1600772452 NO 792890 11-DEC-02 37 654 DB2 1600772452 NO 792890 11-DEC-02 37 712 DB2 1600772452 NO 792890 11-DEC-02 37 680 DB2 1600772452 NO 792890 11-DEC-02 37 764 DB2 1600772452 NO 823456 11-DEC-02 37 816 DB2 1600772452 YES 823456 18-DEC-02 37 893 DB2 1600772452 NO 823456 19-DEC-02 The backup summary list looks like: List of Backups === Key TY LV S Device Type Completion Time #Pieces #Copies Tag --- -- -- - --- --- --- --- --- 47 B F A DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-DEC-02 1 1 I've tried resetting the database to incarnation 816, but when I restore the control file and data files from that it is not what I think it should be. I end up with FULL_DB_INSTALLED. I can restore the control file I want from the auto backup file. How can I then tell RMAN to restore the data files associated with either backup set 791 (tag=WF_TESTING)? Thanks. -- Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Restoring DB from specific RMAN backup set.
Paul - Can you specify what you mean by no archive log mode and backed up with RMAN? Was the database open? Which Oracle version? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 19, 2002 9:40 AM To: Multiple recipients of list ORACLE-L How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB IDCUR Reset SCN Reset Time --- --- --- -- -- 37 38 DB2 1600772452 NO 1 15-NOV-02 37 256 DB2 1600772452 NO 259591 23-NOV-02 37 627 DB2 1600772452 NO 792890 11-DEC-02 37 654 DB2 1600772452 NO 792890 11-DEC-02 37 712 DB2 1600772452 NO 792890 11-DEC-02 37 680 DB2 1600772452 NO 792890 11-DEC-02 37 764 DB2 1600772452 NO 823456 11-DEC-02 37 816 DB2 1600772452 YES 823456 18-DEC-02 37 893 DB2 1600772452 NO 823456 19-DEC-02 The backup summary list looks like: List of Backups === Key TY LV S Device Type Completion Time #Pieces #Copies Tag --- -- -- - --- --- --- --- --- 47 B F A DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-DEC-02 1 1 I've tried resetting the database to incarnation 816, but when I restore the control file and data files from that it is not what I think it should be. I end up with FULL_DB_INSTALLED. I can restore the control file I want from the auto backup file. How can I then tell RMAN to restore the data files associated with either backup set 791 (tag=WF_TESTING)? Thanks. -- Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Restoring DB from specific RMAN backup set.
Database is 9.0.1.4 running on Win2K. The database called DB2 is not running in archivelog mode. The database is being backed up using RMAN: I.e. set ORACLE_SID=DB2 rman target / catalog rman@otherdb shutdown immediate; startup mount; backup database format=f:\oracle_backup\%d\%d_%U tag full_backup; alter database open; I figured out what the problem was. After I restored the controlfile from the autobackup file I was not mounting the database before doing a database restore. Thanks. -- Paul -Original Message- WILLIAMS Sent: Thursday, December 19, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Paul - Can you specify what you mean by no archive log mode and backed up with RMAN? Was the database open? Which Oracle version? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 19, 2002 9:40 AM To: Multiple recipients of list ORACLE-L How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB IDCUR Reset SCN Reset Time --- --- --- -- -- 37 38 DB2 1600772452 NO 1 15-NOV-02 37 256 DB2 1600772452 NO 259591 23-NOV-02 37 627 DB2 1600772452 NO 792890 11-DEC-02 37 654 DB2 1600772452 NO 792890 11-DEC-02 37 712 DB2 1600772452 NO 792890 11-DEC-02 37 680 DB2 1600772452 NO 792890 11-DEC-02 37 764 DB2 1600772452 NO 823456 11-DEC-02 37 816 DB2 1600772452 YES 823456 18-DEC-02 37 893 DB2 1600772452 NO 823456 19-DEC-02 The backup summary list looks like: List of Backups === Key TY LV S Device Type Completion Time #Pieces #Copies Tag --- -- -- - --- --- --- --- --- 47 B F A DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-DEC-02 1 1 I've tried resetting the database to incarnation 816, but when I restore the control file and data files from that it is not what I think it should be. I end up with FULL_DB_INSTALLED. I can restore the control file I want from the auto backup file. How can I then tell RMAN to restore the data files associated with either backup set 791 (tag=WF_TESTING)? Thanks. -- Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: Restoring DB from specific RMAN backup set.
Paul, Who chose 'DB2' as a SID? That must be confusing. DBA1: What are you backing up? DBA2: DB2 DBA1: What? I thought it was an Oracle database? DBA2: Yeah it is, DB2. DBA1: But if it's Oracle, why are you backing up DB2? DBA2: It's an Oracle database called DB2. DBA1: But, if you call Oracle DB2, what do you call DB2? DBA2: DB2. DBA1: ARRRGGH!! ... Paul Heely [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/19/2002 10:17 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Restoring DB from specific RMAN backup set. Database is 9.0.1.4 running on Win2K. The database called DB2 is not running in archivelog mode. The database is being backed up using RMAN: I.e. set ORACLE_SID=DB2 rman target / catalog rman@otherdb shutdown immediate; startup mount; backup database format=f:\oracle_backup\%d\%d_%U tag full_backup; alter database open; I figured out what the problem was. After I restored the controlfile from the autobackup file I was not mounting the database before doing a database restore. Thanks. -- Paul -Original Message- WILLIAMS Sent: Thursday, December 19, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Paul - Can you specify what you mean by no archive log mode and backed up with RMAN? Was the database open? Which Oracle version? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 19, 2002 9:40 AM To: Multiple recipients of list ORACLE-L How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB IDCUR Reset SCN Reset Time --- --- --- -- -- 37 38 DB2 1600772452 NO 1 15-NOV-02 37 256 DB2 1600772452 NO 259591 23-NOV-02 37 627 DB2 1600772452 NO 792890 11-DEC-02 37 654 DB2 1600772452 NO 792890 11-DEC-02 37 712 DB2 1600772452 NO 792890 11-DEC-02 37 680 DB2 1600772452 NO 792890 11-DEC-02 37 764 DB2 1600772452 NO 823456 11-DEC-02 37 816 DB2 1600772452 YES 823456 18-DEC-02 37 893 DB2 1600772452 NO 823456 19-DEC-02 The backup summary list looks like: List of Backups === Key TY LV S Device Type Completion Time #Pieces #Copies Tag --- -- -- - --- --- --- --- --- 47 B F A DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-DEC-02 1 1 I've tried resetting the database to incarnation 816, but when I restore the control file and data files from that it is not what I think it should be. I end up with FULL_DB_INSTALLED. I can restore the control file I want from the auto backup file. How can I then tell RMAN to restore the data files associated with either backup set 791 (tag=WF_TESTING)? Thanks. -- Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: Restoring DB from specific RMAN backup set.
Fortunately that is not the real SID name, had to sanitize it before I posted. Realized after I sent it that DB2 was not the best choice. Where are Abbot and Costello when you need them :) -- Paul -Original Message- Sent: Thursday, December 19, 2002 2:29 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Paul, Who chose 'DB2' as a SID? That must be confusing. DBA1: What are you backing up? DBA2: DB2 DBA1: What? I thought it was an Oracle database? DBA2: Yeah it is, DB2. DBA1: But if it's Oracle, why are you backing up DB2? DBA2: It's an Oracle database called DB2. DBA1: But, if you call Oracle DB2, what do you call DB2? DBA2: DB2. DBA1: ARRRGGH!! ... Paul Heely [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/19/2002 10:17 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Restoring DB from specific RMAN backup set. Database is 9.0.1.4 running on Win2K. The database called DB2 is not running in archivelog mode. The database is being backed up using RMAN: I.e. set ORACLE_SID=DB2 rman target / catalog rman@otherdb shutdown immediate; startup mount; backup database format=f:\oracle_backup\%d\%d_%U tag full_backup; alter database open; I figured out what the problem was. After I restored the controlfile from the autobackup file I was not mounting the database before doing a database restore. Thanks. -- Paul -Original Message- WILLIAMS Sent: Thursday, December 19, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Paul - Can you specify what you mean by no archive log mode and backed up with RMAN? Was the database open? Which Oracle version? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 19, 2002 9:40 AM To: Multiple recipients of list ORACLE-L How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB IDCUR Reset SCN Reset Time --- --- --- -- -- 37 38 DB2 1600772452 NO 1 15-NOV-02 37 256 DB2 1600772452 NO 259591 23-NOV-02 37 627 DB2 1600772452 NO 792890 11-DEC-02 37 654 DB2 1600772452 NO 792890 11-DEC-02 37 712 DB2 1600772452 NO 792890 11-DEC-02 37 680 DB2 1600772452 NO 792890 11-DEC-02 37 764 DB2 1600772452 NO 823456 11-DEC-02 37 816 DB2 1600772452 YES 823456 18-DEC-02 37 893 DB2 1600772452 NO 823456 19-DEC-02 The backup summary list looks like: List of Backups === Key TY LV S Device Type Completion Time #Pieces #Copies Tag --- -- -- - --- --- --- --- --- 47 B F A DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-DEC-02 1 1 I've tried resetting the database to incarnation 816, but when I restore the control file and data files from that it is not what I think it should be. I end up with FULL_DB_INSTALLED. I can restore the control file I want from the auto backup file. How can I then tell RMAN to restore the data files associated with either backup set 791 (tag=WF_TESTING)? Thanks. -- Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City
RE: Restoring DB from specific RMAN backup set.
Title: RE: Restoring DB from specific RMAN backup set. Jared, LOL. Sounds like Abbot and Costello doing the DBA version of 'Who's on First'. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Paul, Who chose 'DB2' as a SID? That must be confusing. DBA1: What are you backing up? DBA2: DB2 DBA1: What? I thought it was an Oracle database? DBA2: Yeah it is, DB2. DBA1: But if it's Oracle, why are you backing up DB2? DBA2: It's an Oracle database called DB2. DBA1: But, if you call Oracle DB2, what do you call DB2? DBA2: DB2. DBA1: ARRRGGH!! ...
RE: Restoring DB from specific RMAN backup set.
At 1st and 3rd? -Original Message- Sent: Thursday, December 19, 2002 2:42 PM To: Multiple recipients of list ORACLE-L Fortunately that is not the real SID name, had to sanitize it before I posted. Realized after I sent it that DB2 was not the best choice. Where are Abbot and Costello when you need them :) -- Paul -Original Message- Sent: Thursday, December 19, 2002 2:29 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Paul, Who chose 'DB2' as a SID? That must be confusing. DBA1: What are you backing up? DBA2: DB2 DBA1: What? I thought it was an Oracle database? DBA2: Yeah it is, DB2. DBA1: But if it's Oracle, why are you backing up DB2? DBA2: It's an Oracle database called DB2. DBA1: But, if you call Oracle DB2, what do you call DB2? DBA2: DB2. DBA1: ARRRGGH!! ... Paul Heely [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/19/2002 10:17 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Restoring DB from specific RMAN backup set. Database is 9.0.1.4 running on Win2K. The database called DB2 is not running in archivelog mode. The database is being backed up using RMAN: I.e. set ORACLE_SID=DB2 rman target / catalog rman@otherdb shutdown immediate; startup mount; backup database format=f:\oracle_backup\%d\%d_%U tag full_backup; alter database open; I figured out what the problem was. After I restored the controlfile from the autobackup file I was not mounting the database before doing a database restore. Thanks. -- Paul -Original Message- WILLIAMS Sent: Thursday, December 19, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Paul - Can you specify what you mean by no archive log mode and backed up with RMAN? Was the database open? Which Oracle version? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 19, 2002 9:40 AM To: Multiple recipients of list ORACLE-L How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB IDCUR Reset SCN Reset Time --- --- --- -- -- 37 38 DB2 1600772452 NO 1 15-NOV-02 37 256 DB2 1600772452 NO 259591 23-NOV-02 37 627 DB2 1600772452 NO 792890 11-DEC-02 37 654 DB2 1600772452 NO 792890 11-DEC-02 37 712 DB2 1600772452 NO 792890 11-DEC-02 37 680 DB2 1600772452 NO 792890 11-DEC-02 37 764 DB2 1600772452 NO 823456 11-DEC-02 37 816 DB2 1600772452 YES 823456 18-DEC-02 37 893 DB2 1600772452 NO 823456 19-DEC-02 The backup summary list looks like: List of Backups === Key TY LV S Device Type Completion Time #Pieces #Copies Tag --- -- -- - --- --- --- --- --- 47 B F A DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-DEC-02 1 1 I've tried resetting the database to incarnation 816, but when I restore the control file and data files from that it is not what I think it should be. I end up with FULL_DB_INSTALLED. I can restore the control file I want from the auto backup file. How can I then tell RMAN to restore the data files associated with either backup set 791 (tag=WF_TESTING)? Thanks. -- Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Problem doing RMAN backup of Clone?
Thanks to everyone .. all useful info.. this procedure worked like a charm!! Thanks a lot! - Dc. On Mon, 25 Nov 2002 07:34:16 -0800, you wrote: Doug, I have successfully tested this method for changing the the dbid {gleaned from Ron Yount's procedure]. Changing the Dbid of copied database: Ron Yount from the Oracle-L provided the following steps if it becomes necessary to change the Dbid of a copied database to allow an RMAN catalog to backup both source and target database. This should occur at the tail of the SAP Database Copy procedure. [Tested successfully on GTS refresh 5/13/02] Use sqlplus to connect internal (if using sqlplus comment # must be changed to 'rem' or '--') SQL startup nomount SQL @c.sql /* create controlfile with set database resetlogs */ SQL select name,dbid from v$database; (There should be a new name, but same dbid from step 3) SQL shutdown normal SQL startup mount SQL exec dbms_backup_restore.zeroDbid(0); SQL shutdown normal Rename the control files from the new instance, so they will appear to be missing. SQL startup nomount SQL @c.sql SQL alter database open resetlogs; SQL select name, dbid from v$database. (There should be the new name, and new dbid) HTH Mike Hand Polaroid Corp. -Original Message- Sent: Sunday, November 24, 2002 10:14 PM To: Multiple recipients of list ORACLE-L Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug ** @@ This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Problem doing RMAN backup of Clone?
Ditto! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 25, 2002 9:59 AM Good to hear from you Lisa!! Welcome Back!! -Original Message- Sent: Monday, November 25, 2002 7:49 AM To: Multiple recipients of list ORACLE-L Hi Doug, I can't answer the question about rman... but if you recreate the controlfile you will have a new incarnation number of the database. Have you tried that? Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- Sent: Sunday, November 24, 2002 10:14 PM To: Multiple recipients of list ORACLE-L Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Problem doing RMAN backup of Clone?
Doug, I think I may have seen a post that answered this question already, but just to be on the safe side: You cannot backup two databases with the same dbid using the same rman catalog. This always the case with cloned databases unless... 9i - You use the dbid utility to change the dbid of the clone 8i - You use the dbms_backup_restore.zerodbid(0) (MAKE SURE YOU understand this before implementing it) -Ron- -Original Message- Gramolini Sent: Tuesday, November 26, 2002 8:34 AM To: Multiple recipients of list ORACLE-L Ditto! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 25, 2002 9:59 AM Good to hear from you Lisa!! Welcome Back!! -Original Message- Sent: Monday, November 25, 2002 7:49 AM To: Multiple recipients of list ORACLE-L Hi Doug, I can't answer the question about rman... but if you recreate the controlfile you will have a new incarnation number of the database. Have you tried that? Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- Sent: Sunday, November 24, 2002 10:14 PM To: Multiple recipients of list ORACLE-L Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ron Yount INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Problem doing RMAN backup of Clone?
Create the clone using RMAN duplicate command. Than it gets new ID -Original Message- Sent: maandag 25 november 2002 4:14 To: Multiple recipients of list ORACLE-L Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Problem doing RMAN backup of Clone?
Title: RE: Problem doing RMAN backup of Clone? Hi Doug, I can't answer the question about rman... but if you recreate the controlfile you will have a new incarnation number of the database. Have you tried that? Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Doug C [SMTP: ] Sent: Sunday, November 24, 2002 10:14 PM To: Multiple recipients of list ORACLE-L Subject: Problem doing RMAN backup of Clone? Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Problem doing RMAN backup of Clone?
Unfortunately, this problem is with the DBID, not anything in the controlfile. Oracle 9.2 comes with a utility called 'nid' in $ORACLE_HOME/bin/, which can change the DBID of a database. AFAIK, there is no other way to change the DBID, and you just have to use another catalog. I think nid may work on lower version databases, but I am not sure. Check out the docs. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 25 Nov 2002, Koivu, Lisa wrote: I can't answer the question about rman... but if you recreate the controlfile you will have a new incarnation number of the database. Have you tried that? -Original Message- From: Doug C [SMTP: ] Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Problem doing RMAN backup of Clone?
Title: RE: Problem doing RMAN backup of Clone? Good to hear from you Lisa!! Welcome Back!! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, November 25, 2002 7:49 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Problem doing RMAN backup of Clone? Hi Doug, I can't answer the question about rman... but if you recreate the controlfile you will have a new incarnation number of the database. Have you tried that? Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Doug C [SMTP: ] Sent: Sunday, November 24, 2002 10:14 PM To: Multiple recipients of list ORACLE-L Subject: Problem doing RMAN backup of Clone? Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Problem doing RMAN backup of Clone?
Doug, I have successfully tested this method for changing the the dbid {gleaned from Ron Yount's procedure]. Changing the Dbid of copied database: Ron Yount from the Oracle-L provided the following steps if it becomes necessary to change the Dbid of a copied database to allow an RMAN catalog to backup both source and target database. This should occur at the tail of the SAP Database Copy procedure. [Tested successfully on GTS refresh 5/13/02] Use sqlplus to connect internal (if using sqlplus comment # must be changed to 'rem' or '--') SQL startup nomount SQL @c.sql /* create controlfile with set database resetlogs */ SQL select name,dbid from v$database; (There should be a new name, but same dbid from step 3) SQL shutdown normal SQL startup mount SQL exec dbms_backup_restore.zeroDbid(0); SQL shutdown normal Rename the control files from the new instance, so they will appear to be missing. SQL startup nomount SQL @c.sql SQL alter database open resetlogs; SQL select name, dbid from v$database. (There should be the new name, and new dbid) HTH Mike Hand Polaroid Corp. -Original Message- Sent: Sunday, November 24, 2002 10:14 PM To: Multiple recipients of list ORACLE-L Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug ** @@ This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Problem doing RMAN backup of Clone?
Use following command to generate new dbid. dbms_backup_restore.zeroDbid(0) Read Note:164870.1 on metalink for complete procedure. HTH -Shaleen - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, November 25, 2002 7:05 AM Unfortunately, this problem is with the DBID, not anything in the controlfile. Oracle 9.2 comes with a utility called 'nid' in $ORACLE_HOME/bin/, which can change the DBID of a database. AFAIK, there is no other way to change the DBID, and you just have to use another catalog. I think nid may work on lower version databases, but I am not sure. Check out the docs. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Mon, 25 Nov 2002, Koivu, Lisa wrote: I can't answer the question about rman... but if you recreate the controlfile you will have a new incarnation number of the database. Have you tried that? -Original Message- From: Doug C [SMTP: ] Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: orafaq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Problem doing RMAN backup of Clone?
You can change the DBID as mentioned in other messages. (see metalink doc id 174625.1) If you don't want to change the DBID, you can still backup the database using RMAN; you just can't use the same schema in the same rman catalog database as the original. You can: 1. Use a different catalog database. 2. Use a different schema in the same catalog database (for example rman_prod and rman_test schemas). 3. Don't use a catalog, and rely entirely on the control files as your catalog. -Original Message- Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Problem doing RMAN backup of Clone?
Also, Oracle9iR2 has a new utility, DBNEWID, that allows you to change the DBID of a copied database safely. With it you can change: 1. The DBID 2. The DBNAME 3. A combination of 1 and 2. This utility is covered in pages 412-413 of my new RMAN book. Prior to 9iR2, you could also use (CAREFULLY) use the procedure sys.dbms_backup_restore.zerodbid. This is documented in page 395 of my RMAN Backup and Recovery book. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Monday, November 25, 2002 3:24 AM To: Multiple recipients of list ORACLE-L Create the clone using RMAN duplicate command. Than it gets new ID -Original Message- Sent: maandag 25 november 2002 4:14 To: Multiple recipients of list ORACLE-L Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Problem doing RMAN backup of Clone?
Someone has just told me you can't do an RMAN backup of a clone because it has the same database id as the original. Is this true or not? If so, how to get around it? Thanks, Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup
And of course there is the obvious reason, a level 0 also backs up the controlfile. This is essential for point in tijme recovery. Ruth - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Saturday, November 16, 2002 1:23 PM Subject: Re: RMAN backup How about switching to incremental (from "full") backups? Even if all youdo are level-0 backups?My understanding of the difference between a "full" and a "level-0" backup(besides the obvious impact on any subsequent level-n incremental backups)is that level-0 backups only back up database blocks that are currently inuse, as opposed to "full" backups which back up all database blocks whichhave ever been used (i.e. no longer "unformatted").- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Friday, November 15, 2002 9:39 PM Hello All, Is resizing the datafiles the only way of reducing the size of an RMANfull backup? Oracle Version 8.0.6. We take RMAN hot backups to disk, and the size of the backup has grown considerably. There's one large table whichwe were considering truncating. But looks like that would not reduce the size of the backup. Dropping the table will call for an production outage. Iam considering moving the table to another tablespace, and dropping the existing one. Any ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - 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: Tim Gorman INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: RMAN backup
Joe - Which type of RMAN backup are you doing? If you are doing RMAN datafile backups, then the size of your datafiles matter. If you are using the RMAN backup command, you are creating RMAN backup pieces. RMAN backup pieces contain parts of several data files, and you can't control that. You can control the maximum size of each piece. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, November 16, 2002 2:33 PM To: Multiple recipients of list ORACLE-L Joe Tim, It is accurate to state the both full and level 0 have the same impact on the database, and both backup all used blocks. It is also accurate that a full backup cannot be used as a piece of an incremental strategy. Although there may be rare instances (no pun intended :-) ) when you want to use a full backup (e.g. separate from your incremental flow) I never use full backups in RMAN myself. If you want to reduce the size of your backups: 1) Reduce the size of segments by reorging data (yes, I now this is stating the obvious) 2) Make any tablespaces containing static data read-only (thereby skipping them in RMAN after level 0) 3) Use an incremental strategy (level 0, 1...) Of course you must balance MTTR. If you just need to reduce disk space utilized, consider integrating RMAN with your backup vendor's software (Legato, Veritas...) so the backups go directly to tape. HTH, -Ron- Joe, nice to see you still contributing to this group. Hope all is well. -Ron- -Original Message- Sent: Saturday, November 16, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Tim, i'd be glad to hear someone else verify your statement as my understanding is the the only difference between full and level 0 is that full cannot be used as part of an incremental strategy, other than that they both back up the ever used blocks. Anyone else care to jump in on this one? joe Tim Gorman wrote: How about switching to incremental (from full) backups? Even if all you do are level-0 backups? My understanding of the difference between a full and a level-0 backup (besides the obvious impact on any subsequent level-n incremental backups) is that level-0 backups only back up database blocks that are currently in use, as opposed to full backups which back up all database blocks which have ever been used (i.e. no longer unformatted). - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 15, 2002 9:39 PM Hello All, Is resizing the datafiles the only way of reducing the size of an RMAN full backup? Oracle Version 8.0.6. We take RMAN hot backups to disk, and the size of the backup has grown considerably. There's one large table which we were considering truncating. But looks like that would not reduce the size of the backup. Dropping the table will call for an production outage. I am considering moving the table to another tablespace, and dropping the existing one. Any ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ron/Sarah Yount INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
Re: RMAN backup
How about switching to incremental (from full) backups? Even if all you do are level-0 backups? My understanding of the difference between a full and a level-0 backup (besides the obvious impact on any subsequent level-n incremental backups) is that level-0 backups only back up database blocks that are currently in use, as opposed to full backups which back up all database blocks which have ever been used (i.e. no longer unformatted). - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 15, 2002 9:39 PM Hello All, Is resizing the datafiles the only way of reducing the size of an RMAN full backup? Oracle Version 8.0.6. We take RMAN hot backups to disk, and the size of the backup has grown considerably. There's one large table which we were considering truncating. But looks like that would not reduce the size of the backup. Dropping the table will call for an production outage. I am considering moving the table to another tablespace, and dropping the existing one. Any ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup
Tim, i'd be glad to hear someone else verify your statement as my understanding is the the only difference between full and level 0 is that full cannot be used as part of an incremental strategy, other than that they both back up the ever used blocks. Anyone else care to jump in on this one? joe Tim Gorman wrote: How about switching to incremental (from full) backups? Even if all you do are level-0 backups? My understanding of the difference between a full and a level-0 backup (besides the obvious impact on any subsequent level-n incremental backups) is that level-0 backups only back up database blocks that are currently in use, as opposed to full backups which back up all database blocks which have ever been used (i.e. no longer unformatted). - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 15, 2002 9:39 PM Hello All, Is resizing the datafiles the only way of reducing the size of an RMAN full backup? Oracle Version 8.0.6. We take RMAN hot backups to disk, and the size of the backup has grown considerably. There's one large table which we were considering truncating. But looks like that would not reduce the size of the backup. Dropping the table will call for an production outage. I am considering moving the table to another tablespace, and dropping the existing one. Any ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN backup
Joe Tim, It is accurate to state the both full and level 0 have the same impact on the database, and both backup all used blocks. It is also accurate that a full backup cannot be used as a piece of an incremental strategy. Although there may be rare instances (no pun intended :-) ) when you want to use a full backup (e.g. separate from your incremental flow) I never use full backups in RMAN myself. If you want to reduce the size of your backups: 1) Reduce the size of segments by reorging data (yes, I now this is stating the obvious) 2) Make any tablespaces containing static data read-only (thereby skipping them in RMAN after level 0) 3) Use an incremental strategy (level 0, 1...) Of course you must balance MTTR. If you just need to reduce disk space utilized, consider integrating RMAN with your backup vendor's software (Legato, Veritas...) so the backups go directly to tape. HTH, -Ron- Joe, nice to see you still contributing to this group. Hope all is well. -Ron- -Original Message- Sent: Saturday, November 16, 2002 1:33 PM To: Multiple recipients of list ORACLE-L Tim, i'd be glad to hear someone else verify your statement as my understanding is the the only difference between full and level 0 is that full cannot be used as part of an incremental strategy, other than that they both back up the ever used blocks. Anyone else care to jump in on this one? joe Tim Gorman wrote: How about switching to incremental (from full) backups? Even if all you do are level-0 backups? My understanding of the difference between a full and a level-0 backup (besides the obvious impact on any subsequent level-n incremental backups) is that level-0 backups only back up database blocks that are currently in use, as opposed to full backups which back up all database blocks which have ever been used (i.e. no longer unformatted). - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, November 15, 2002 9:39 PM Hello All, Is resizing the datafiles the only way of reducing the size of an RMAN full backup? Oracle Version 8.0.6. We take RMAN hot backups to disk, and the size of the backup has grown considerably. There's one large table which we were considering truncating. But looks like that would not reduce the size of the backup. Dropping the table will call for an production outage. I am considering moving the table to another tablespace, and dropping the existing one. Any ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ron/Sarah Yount INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RMAN backup
Hello All, Is resizing the datafiles the only way of reducing the size of an RMAN full backup? Oracle Version 8.0.6. We take RMAN hot backups to disk, and the size of the backup has grown considerably. There's one large table which we were considering truncating. But looks like that would not reduce the size of the backup. Dropping the table will call for an production outage. I am considering moving the table to another tablespace, and dropping the existing one. Any ideas? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle9i RMAN Backup and Recovery
Thanks Jared! RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 8:13 PM To: Multiple recipients of list ORACLE-L Looks very enticing Robert, can't wait to see it. Jared Freeman, Robert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/10/2002 07:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle9i RMAN Backup and Recovery Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is at the printer. We have a sample chapter available and TOC for you all to look at if you like. Here is the URL: http://shop.osborne.com/cgi-bin/osborne/0072226625.html Enjoy! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 9:28 AM To: Multiple recipients of list ORACLE-L We are in the midst of a big move to RMAN. We use EMC's EDM to do backups, and the SAs have been pushing us towards RMAN for a while now, cause the EDM interface intergrates w/ RMAN seamlessly. It really is a nice backup solution. (We started the process by upgrading all our EDM units to 5.0) Anyhow, we are setting up the RMAN catalog databases ringht on the EDM boxes. (The EDMs are Solaris boxes.) It's working well. We haven't yet fully rolled out, but all our testing has worked fine. We're about to start the production database migration next week. -Mark On Thu, 2002-10-10 at 06:23, Connor McDonald wrote: There is a Metalink note (73431.1) which talks about the rman version compatibility, but it also states: Ensure that the RMAN executable version matches the version of the target database that it is backing up which I presume to mean that you need to run rman from each target and push to the catalog storage management node(s). This is how I've always seen it done - but I've often wondered if one could get away driving eveything from the catalog node, pulling client databases over sqlnet - thus only having a single TSM client (and license) on the rman catalog node. Cheers Connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: I'm trying to use RMAN and TSM to backup multiple databases spread across various nodes with some nodes hosting more than one database. The RMAN catalog database will reside on a node different from any of the nodes hosting the other databases. I have long used ADSM without the RMAN clothing to backup the databases. I have convinced the SA's to move on to TSM, and now I need to add the RMAN adornments. I assume I need the SA's to install TDP for Oracle on all the nodes requiring RMAN backup. Do I also need to install it on the machine which will host the catalog database. That database will undergo cold backup using naked TSM. The same question applies to the tdpo.opt file. Do I need multiple TDPO_FS values and multiple tdpo.opt files to hold them. I am also assuming I will start RMAN from one of the databases requiring backup and connect also to the RMAN catalog. Is this typical. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http
Oracle9i RMAN Backup and Recovery
Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is at the printer. We have a sample chapter available and TOC for you all to look at if you like. Here is the URL: http://shop.osborne.com/cgi-bin/osborne/0072226625.html Enjoy! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 9:28 AM To: Multiple recipients of list ORACLE-L We are in the midst of a big move to RMAN. We use EMC's EDM to do backups, and the SAs have been pushing us towards RMAN for a while now, cause the EDM interface intergrates w/ RMAN seamlessly. It really is a nice backup solution. (We started the process by upgrading all our EDM units to 5.0) Anyhow, we are setting up the RMAN catalog databases ringht on the EDM boxes. (The EDMs are Solaris boxes.) It's working well. We haven't yet fully rolled out, but all our testing has worked fine. We're about to start the production database migration next week. -Mark On Thu, 2002-10-10 at 06:23, Connor McDonald wrote: There is a Metalink note (73431.1) which talks about the rman version compatibility, but it also states: Ensure that the RMAN executable version matches the version of the target database that it is backing up which I presume to mean that you need to run rman from each target and push to the catalog storage management node(s). This is how I've always seen it done - but I've often wondered if one could get away driving eveything from the catalog node, pulling client databases over sqlnet - thus only having a single TSM client (and license) on the rman catalog node. Cheers Connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: I'm trying to use RMAN and TSM to backup multiple databases spread across various nodes with some nodes hosting more than one database. The RMAN catalog database will reside on a node different from any of the nodes hosting the other databases. I have long used ADSM without the RMAN clothing to backup the databases. I have convinced the SA's to move on to TSM, and now I need to add the RMAN adornments. I assume I need the SA's to install TDP for Oracle on all the nodes requiring RMAN backup. Do I also need to install it on the machine which will host the catalog database. That database will undergo cold backup using naked TSM. The same question applies to the tdpo.opt file. Do I need multiple TDPO_FS values and multiple tdpo.opt files to hold them. I am also assuming I will start RMAN from one of the databases requiring backup and connect also to the RMAN catalog. Is this typical. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 http://www.fatcity.com
RE: Oracle9i RMAN Backup and Recovery
Congratulations, Robert!! Looking forward to receiving my copy... - Kirti -Original Message- Sent: Thursday, October 10, 2002 9:59 AM To: Multiple recipients of list ORACLE-L Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is at the printer. We have a sample chapter available and TOC for you all to look at if you like. Here is the URL: http://shop.osborne.com/cgi-bin/osborne/0072226625.html Enjoy! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 9:28 AM To: Multiple recipients of list ORACLE-L We are in the midst of a big move to RMAN. We use EMC's EDM to do backups, and the SAs have been pushing us towards RMAN for a while now, cause the EDM interface intergrates w/ RMAN seamlessly. It really is a nice backup solution. (We started the process by upgrading all our EDM units to 5.0) Anyhow, we are setting up the RMAN catalog databases ringht on the EDM boxes. (The EDMs are Solaris boxes.) It's working well. We haven't yet fully rolled out, but all our testing has worked fine. We're about to start the production database migration next week. -Mark On Thu, 2002-10-10 at 06:23, Connor McDonald wrote: There is a Metalink note (73431.1) which talks about the rman version compatibility, but it also states: Ensure that the RMAN executable version matches the version of the target database that it is backing up which I presume to mean that you need to run rman from each target and push to the catalog storage management node(s). This is how I've always seen it done - but I've often wondered if one could get away driving eveything from the catalog node, pulling client databases over sqlnet - thus only having a single TSM client (and license) on the rman catalog node. Cheers Connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: I'm trying to use RMAN and TSM to backup multiple databases spread across various nodes with some nodes hosting more than one database. The RMAN catalog database will reside on a node different from any of the nodes hosting the other databases. I have long used ADSM without the RMAN clothing to backup the databases. I have convinced the SA's to move on to TSM, and now I need to add the RMAN adornments. I assume I need the SA's to install TDP for Oracle on all the nodes requiring RMAN backup. Do I also need to install it on the machine which will host the catalog database. That database will undergo cold backup using naked TSM. The same question applies to the tdpo.opt file. Do I need multiple TDPO_FS values and multiple tdpo.opt files to hold them. I am also assuming I will start RMAN from one of the databases requiring backup and connect also to the RMAN catalog. Is this typical. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
RE: Oracle9i RMAN Backup and Recovery
I hope it meets everyone's expectations. We worked like dogs to get this one done by OOW. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 11:54 AM To: Multiple recipients of list ORACLE-L Congratulations, Robert!! Looking forward to receiving my copy... - Kirti -Original Message- Sent: Thursday, October 10, 2002 9:59 AM To: Multiple recipients of list ORACLE-L Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is at the printer. We have a sample chapter available and TOC for you all to look at if you like. Here is the URL: http://shop.osborne.com/cgi-bin/osborne/0072226625.html Enjoy! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 9:28 AM To: Multiple recipients of list ORACLE-L We are in the midst of a big move to RMAN. We use EMC's EDM to do backups, and the SAs have been pushing us towards RMAN for a while now, cause the EDM interface intergrates w/ RMAN seamlessly. It really is a nice backup solution. (We started the process by upgrading all our EDM units to 5.0) Anyhow, we are setting up the RMAN catalog databases ringht on the EDM boxes. (The EDMs are Solaris boxes.) It's working well. We haven't yet fully rolled out, but all our testing has worked fine. We're about to start the production database migration next week. -Mark On Thu, 2002-10-10 at 06:23, Connor McDonald wrote: There is a Metalink note (73431.1) which talks about the rman version compatibility, but it also states: Ensure that the RMAN executable version matches the version of the target database that it is backing up which I presume to mean that you need to run rman from each target and push to the catalog storage management node(s). This is how I've always seen it done - but I've often wondered if one could get away driving eveything from the catalog node, pulling client databases over sqlnet - thus only having a single TSM client (and license) on the rman catalog node. Cheers Connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: I'm trying to use RMAN and TSM to backup multiple databases spread across various nodes with some nodes hosting more than one database. The RMAN catalog database will reside on a node different from any of the nodes hosting the other databases. I have long used ADSM without the RMAN clothing to backup the databases. I have convinced the SA's to move on to TSM, and now I need to add the RMAN adornments. I assume I need the SA's to install TDP for Oracle on all the nodes requiring RMAN backup. Do I also need to install it on the machine which will host the catalog database. That database will undergo cold backup using naked TSM. The same question applies to the tdpo.opt file. Do I need multiple TDPO_FS values and multiple tdpo.opt files to hold them. I am also assuming I will start RMAN from one of the databases requiring backup and connect also to the RMAN catalog. Is this typical. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San
Re: Oracle9i RMAN Backup and Recovery
Looks very enticing Robert, can't wait to see it. Jared Freeman, Robert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/10/2002 07:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle9i RMAN Backup and Recovery Well, our new Oracle Press Oracle9i RMAN Backup and Recovery book is at the printer. We have a sample chapter available and TOC for you all to look at if you like. Here is the URL: http://shop.osborne.com/cgi-bin/osborne/0072226625.html Enjoy! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 10, 2002 9:28 AM To: Multiple recipients of list ORACLE-L We are in the midst of a big move to RMAN. We use EMC's EDM to do backups, and the SAs have been pushing us towards RMAN for a while now, cause the EDM interface intergrates w/ RMAN seamlessly. It really is a nice backup solution. (We started the process by upgrading all our EDM units to 5.0) Anyhow, we are setting up the RMAN catalog databases ringht on the EDM boxes. (The EDMs are Solaris boxes.) It's working well. We haven't yet fully rolled out, but all our testing has worked fine. We're about to start the production database migration next week. -Mark On Thu, 2002-10-10 at 06:23, Connor McDonald wrote: There is a Metalink note (73431.1) which talks about the rman version compatibility, but it also states: Ensure that the RMAN executable version matches the version of the target database that it is backing up which I presume to mean that you need to run rman from each target and push to the catalog storage management node(s). This is how I've always seen it done - but I've often wondered if one could get away driving eveything from the catalog node, pulling client databases over sqlnet - thus only having a single TSM client (and license) on the rman catalog node. Cheers Connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: I'm trying to use RMAN and TSM to backup multiple databases spread across various nodes with some nodes hosting more than one database. The RMAN catalog database will reside on a node different from any of the nodes hosting the other databases. I have long used ADSM without the RMAN clothing to backup the databases. I have convinced the SA's to move on to TSM, and now I need to add the RMAN adornments. I assume I need the SA's to install TDP for Oracle on all the nodes requiring RMAN backup. Do I also need to install it on the machine which will host the catalog database. That database will undergo cold backup using naked TSM. The same question applies to the tdpo.opt file. Do I need multiple TDPO_FS values and multiple tdpo.opt files to hold them. I am also assuming I will start RMAN from one of the databases requiring backup and connect also to the RMAN catalog. Is this typical. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Remember amateurs built the ark - Professionals built the Titanic __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- -- Mark J. Bobak Oracle DBA [EMAIL PROTECTED] It is not enough to have a good mind. The main thing is to use it well. -- Rene Descartes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark J. Bobak INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
RE: Should I post a preview of Oracle9i RMAN Backup and Recovery
Sure, do post it Aleem -Original Message- Sent: Friday, September 27, 2002 1:31 AM To: Multiple recipients of list ORACLE-L Subject:Should I post a preview of Oracle9i RMAN Backup and Recovery Hand I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 I post a preview of Oracle9i RMAN Backup and Recovery Hand
One more vote for it -Original Message- Robert Sent: Thursday, September 26, 2002 10:31 PM To: Multiple recipients of list ORACLE-L Hand I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 I post a preview of Oracle9i RMAN Backup and Recovery
yea i'm interested by all means. joe Freeman, Robert wrote: I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 I post a preview of Oracle9i RMAN Backup and Recovery
yea i'm interested by all means. joe Freeman, Robert wrote: I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 I post a preview of Oracle9i RMAN Backup and Recovery Hand
Yes, I would like that too. A lot of people are awaiting your book, btw. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 4:30 PM I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 I post a preview of Oracle9i RMAN Backup and Recovery
Thanks Ruth, I may have some legal issues with posting it on the newsgroup, and I'm trying to work that out with OP right now. They want to post it, but I have to have the list owner agree to it, and the item posted has to go through some changes. With the nature of news groups, it may not be practical. I may have to get a web site to post it. (Joe Testa, would you be interested if your site is still up and running)?? Of course, once it's up on Amazon there will be previews available there. I'm really excited about the book. It's going to print Monday, and will be out in time for OOW. The rush to get it out for OOW was MURDER, but I think it will be worth it. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -Original Message- Sent: Friday, September 27, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Recovery Hand Yes, I would like that too. A lot of people are awaiting your book, btw. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 4:30 PM I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 I post a preview of Oracle9i RMAN Backup and Recovery Hand
I would love to read that . bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 27, 2002 11:08 AM Hand Yes, I would like that too. A lot of people are awaiting your book, btw. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 4:30 PM I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: BigP INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 I post a preview of Oracle9i RMAN Backup and Recovery
Me too. Bing Wong Open Systems Database Administrator This e-mail may contain material that is confidential. Any review, reliance or distribution by others or forwarding without express permission is strictly prohibited. If you are not the intended recipient, please contact the sender and delete all copies received. -Original Message- Sent: Friday, September 27, 2002 5:03 PM To: Multiple recipients of list ORACLE-L Recovery Hand I would love to read that . bp - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 27, 2002 11:08 AM Hand Yes, I would like that too. A lot of people are awaiting your book, btw. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 4:30 PM I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: BigP INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 I post a preview of Oracle9i RMAN Backup and Recovery Hand
I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 I post a preview of Oracle9i RMAN Backup and Recovery
Since I plan to buy the book, I would be very interested in previewing it. Thanks Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 26, 2002 3:31 PM To: Multiple recipients of list ORACLE-L Hand I was wondering if anyone would be interested in me posting one chapter from Oracle9i RMAN Backup and Recovery by Mathew Hart and Myself. I don't want to just force it on you all, or make it seem like a marketing ploy. So, if there are enough folks interested in me doing so, I will, and if you object let me know and I will not (as long as the list owner doesn't mind too). Please let me know guys! Robert Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! The avalanche has begun, It is too late for the pebbles to vote. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).