Michael, What version or Rman are you looking at? I really did not appreciate Rman before 8.1.7 and it's predecessor in version 7. Rman for Oracle 9i is damn nice. Instead of those messy scripts and a recovery catalog you now have the ability to store all that stuff in the control file. Then a simple
rman << EOF backup database EOF is all that is needed in 9i. Yes the syntax is a little more messy if you lose your control file for recovery purposes, but at least rman can now rummage through that backup and retrieve the control file. We make limited use of rman here right now, but will we ever increase that in the future. Dick Goulet ____________________Reply Separator____________________ Author: "Mercadante; Thomas F" <[EMAIL PROTECTED]> Date: 2/11/2003 4:53 AM Michael, I use it. I trust it. Oracle support is there when needed. When you say "While I can get RMAN to work for most simple, basic and predictable recovery scenarios, true recovery situations are never so neat and clean." Just what do you mean? Loss of individual tablespaces? What? To be fair, I would suggest that you create a test database, and use Rman to perform backup and recovery operations on it. Try and beat the product so it doesn't work for you. You'll be surprised. Once you see how it works, I think you'll realize that it has matured into a good product. Hope this helps. Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Monday, February 10, 2003 5:04 PM To: Multiple recipients of list ORACLE-L As a longtime Oracle DBA who has used many products, including RMAN, I find myself guilty of a paradoxical mistrust of RMAN, dating back from the time when Oracle has tried several products, including integration with Legato and other hardware/software backup vendors, without a consistent direction. In the little I've used RMAN, it seems quite complex and kludgy. Even the nomenclature and commands used by Oracle within the product are a challenge to learn. While I can get RMAN to work for most simple, basic and predictable recovery scenarios, true recovery situations are never so neat and clean. This is not an advertisement for any particular product, but we've had great success in my shop with a product called SQL*Backtrack from BMC. I've also heard that Veritas makes a good product, but I've not used it. >From what I've seen of RMAN, at least so far, I feel far more confident with the home-cooked scripts I've been using for years. Any comments, or other interesting experiences? Perhaps we can do a list poll of favorite/preferred backup software? <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <META content="MSHTML 5.50.4912.300" name=GENERATOR></HEAD> <BODY> <DIV><SPAN class=369034312-11022003><FONT face=Arial color=#0000ff size=2>Michael,</FONT></SPAN></DIV> <DIV><SPAN class=369034312-11022003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=369034312-11022003><FONT face=Arial color=#0000ff size=2>I use it. I trust it. Oracle support is there when needed.</FONT></SPAN></DIV> <DIV><SPAN class=369034312-11022003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=369034312-11022003><FONT face=Arial color=#0000ff size=2>When you say "<FONT face="Times New Roman" color=#000000 size=3>While I can get RMAN to work for most simple, basic and predictable recovery scenarios, true <BR>recovery situations are never so neat and clean."</FONT></FONT></SPAN></DIV> <DIV><SPAN class=369034312-11022003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=369034312-11022003><FONT face=Arial color=#0000ff size=2>Just what do you mean? Loss of individual tablespaces? What?</FONT></SPAN><SPAN class=369034312-11022003><FONT face=Arial color=#0000ff size=2></FONT></SPAN></DIV> <DIV><SPAN class=369034312-11022003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=369034312-11022003><FONT face=Arial color=#0000ff size=2>To be fair, I would suggest that you create a test database, and use Rman to perform backup and recovery operations on it. Try and beat the product so it doesn't work for you. You'll be surprised. </FONT></SPAN></DIV> <DIV><SPAN class=369034312-11022003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=369034312-11022003><FONT face=Arial color=#0000ff size=2>Once you see how it works, I think you'll realize that it has matured into a good product.</FONT></SPAN></DIV> <DIV><SPAN class=369034312-11022003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=369034312-11022003><FONT face=Arial color=#0000ff size=2>Hope this helps.</FONT></SPAN></DIV> <DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV> <DIV><FONT face=Arial><FONT size=2><SPAN class=369034312-11022003>T</SPAN>om Mercadante</FONT></FONT> <BR><FONT face=Arial size=2>Oracle Certified Professional</FONT> </DIV> <BLOCKQUOTE> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Michael Fontana [mailto:[EMAIL PROTECTED]]<BR><B>Sent:</B> Monday, February 10, 2003 5:04 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RMAN: I don't trust it<BR><BR></FONT></DIV><FONT size=3><BR>As a longtime Oracle DBA who has used many products, including RMAN, I find myself<BR>guilty of a paradoxical mistrust of RMAN, dating back from the time when Oracle has tried<BR>several products, including integration with Legato and other hardware/software backup vendors,<BR>without a consistent direction. In the little I've used RMAN, it seems quite complex and kludgy. <BR>Even the nomenclature and commands used by Oracle within the product are a challenge to learn.<BR><BR>While I can get RMAN to work for most simple, basic and predictable recovery scenarios, true <BR>recovery situations are never so neat and clean. This is not an advertisement for any particular<BR>product, but we've had great success in my shop with a product called SQL*Backtrack from BMC.<BR>I've also heard that Veritas makes a good product, but I've not used it. <BR><BR>From what I've seen of RMAN, at least so far, I feel far more confident with the home-cooked scripts<BR>I've been using for years. <BR><BR>Any comments, or other interesting experiences? <BR><BR>Perhaps we can do a list poll of favorite/preferred backup software?<BR><BR></FONT><BR></BLOCKQUOTE></BODY></HTML> -- 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).