Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:RE: RMAN: I don't trust it
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" <NDATFM_at_labor.state.ny.us> 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:mfontana_at_verio.net]<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: dgoulet_at_vicr.com 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: ListGuru_at_fatcity.com (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).Received on Tue Feb 11 2003 - 08:29:02 CST
![]() |
![]() |